contig_metadata
8 rows where bioproject = "PRJEB39643" and tax_kingdom = "Methanobacteriati"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3883261 | 3883261 | PRJEB39643_P_NODE_101904_length_260_cov_1.647059_g101711_i0 | PRJEB39643 | 101904 | 260 | 1.647059 | 4.2823534 | Natrinema caseinilyticum | 2961570 | Archaea | Archaea | 54.7 | 0.007 | NTclustered | gi|2270264148|gb|CP100445.1| | 2961570 | g101711 | i0 | 96.875 | 0.123076923076923 | 32 | 1 | 12 | 0 | 177 | 208 | 2004064 | 2004033 | Natrinema caseinilyticum strain ZJ2 chromosome, complete genome | blastn | 32 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natrialbaceae | Natrinema | Natrinema caseinilyticum | |
| 7710826 | 7710826 | PRJEB39643_P_NODE_7727_length_732_cov_3.060698_g7559_i0 | PRJEB39643 | 7727 | 732 | 3.060698 | 22.40430936 | Methanobacterium sp. BRmetb2 | 2025350 | Archaea | Archaea | 54.7 | 0.02 | NTclustered | gi|1473087786|gb|CP022705.1| | 2025350 | g7559 | i0 | 94.444 | 0.0491803278688525 | 36 | 1 | 5 | 1 | 439 | 473 | 861936 | 861901 | MAG: Methanobacterium sp. BRmetb2 chromosome, complete genome | blastn | 36 | 54.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. BRmetb2 | |
| 18841296 | 18841296 | PRJEB39643_P_NODE_99015_length_262_cov_1.629630_g98822_i0 | PRJEB39643 | 99015 | 262 | 1.62963 | 4.2696306 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.007 | NTclustered | gi|452081962|emb|HF582854.1| | 268739 | g98822 | i0 | 100 | 0.248091603053435 | 29 | 0 | 11 | 0 | 169 | 197 | 1774954 | 1774926 | Natronomonas moolapensis 8.8.11 complete genome | blastn | 65 | 54.7 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Natronomonadaceae | Natronomonas | Natronomonas moolapensis | |
| 19182856 | 19182856 | PRJEB39643_P_NODE_122776_length_251_cov_1.730337_g122583_i0 | PRJEB39643 | 122776 | 251 | 1.730337 | 4.34314587 | Haloplanus halophilus | 2949993 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2252468249|gb|CP098514.1| | 2949993 | g122583 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 142 | 169 | 2469130 | 2469103 | Haloplanus sp. GDY1 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Halobacteria | Halobacteriales | Haloferacaceae | Haloplanus | Haloplanus halophilus | |
| 27406273 | 27406273 | PRJEB39643_P_NODE_16943_length_445_cov_9.193548_g16750_i0 | PRJEB39643 | 16943 | 445 | 9.193548 | 40.9112886 | Archaea | 2157 | Archaea | Archaea | 85.9 | 4.29e-18 | NR | HXQ49019.1 | 1906666 | g16750 | i0 | 38 | 2.83820224719101 | 137 | 82 | 91 | 2 | 425 | 21 | 12 | 147 | HXQ49019.1 universal stress protein [Thermoplasmata archaeon] | diamond | 1263 | 85.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 27690589 | 27690589 | PRJEB39643_P_NODE_6204_length_835_cov_3.692913_g6055_i0 | PRJEB39643 | 6204 | 835 | 3.692913 | 30.83582355 | Methanosphaera | 2316 | Archaea | Archaea | 45.8 | 0.0299 | NR | WP_288652866.1 | 262501 | g6055 | i0 | 30.6 | 0.610778443113772 | 85 | 53 | 30.2 | 2 | 541 | 792 | 51 | 130 | WP_288652866.1 hypothetical protein [uncultured Methanosphaera sp.] | diamond | 510 | 45.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | uncultured Methanosphaera sp. | |
| 28170450 | 28170450 | PRJEB39643_P_NODE_30466_length_334_cov_2.360153_g30273_i0 | PRJEB39643 | 30466 | 334 | 2.360153 | 7.88291102 | Euryarchaeota archaeon RBG_19FT_COMBO_69_17 | 1797984 | Archaea | Archaea | 43.9 | 0.0337 | NR | OGS63404.1 | 1797984 | g30273 | i0 | 62.5 | 0.287425149700599 | 32 | 11 | 28.7 | 1 | 301 | 206 | 55 | 85 | OGS63404.1 MAG: hypothetical protein A3K59_06110 [Euryarchaeota archaeon RBG_19FT_COMBO_69_17] | diamond | 96 | 43.9 | 1 | Archaea | Methanobacteriati | Methanobacteriota | Euryarchaeota archaeon RBG_19FT_COMBO_69_17 | ||||||
| 30949794 | 30949794 | PRJEB39643_P_NODE_128654_length_249_cov_1.312500_g128461_i0 | PRJEB39643 | 128654 | 249 | 1.3125 | 3.268125 | Methanobrevibacter sp. DSM 116169 | 3242727 | Archaea | Archaea | 53.1 | 8.98e-6 | NR | WP_409199671.1 | 3242727 | g128461 | i0 | 46.6 | 0.879518072289157 | 73 | 32 | 81.9 | 3 | 222 | 19 | 218 | 288 | WP_409199671.1 C1 family peptidase [Methanobrevibacter sp. DSM 116169] | diamond | 219 | 53.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. DSM 116169 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;