contig_metadata
12 rows where bioproject = "PRJNA1237347", tax_clade = "Methanomada group" and tax_phylum = "Methanobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1614013 | 1614013 | PRJNA1237347_P_NODE_244202_length_380_cov_1.736156_g237629_i0 | PRJNA1237347 | 244202 | 380 | 1.736156 | 6.5973928 | Methanothermobacter sp. CaT2 | 866790 | Archaea | Archaea | 89.8 | 2.76e-13 | NTclustered | gi|427188531|dbj|AP011952.1| | 866790 | g237629 | i0 | 94.737 | 1.74473684210526 | 57 | 3 | 15 | 0 | 69 | 125 | 5369 | 5425 | Methanothermobacter sp. CaT2 DNA, complete genome | blastn | 663 | 89.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanothermobacter | Methanothermobacter sp. CaT2 | |
| 1617201 | 1617201 | PRJNA1237347_P_NODE_407702_length_276_cov_1.896552_g401129_i0 | PRJNA1237347 | 407702 | 276 | 1.896552 | 5.23448352 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g401129 | i0 | 88.636 | 0.304347826086957 | 44 | 4 | 16 | 1 | 140 | 182 | 270610 | 270653 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 84 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 13099278 | 13099278 | PRJNA1237347_P_NODE_564011_length_230_cov_4.439490_g557437_i0 | PRJNA1237347 | 564011 | 230 | 4.43949 | 10.210827 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 52.8 | 0.021 | NTclustered | gi|2621703503|emb|OY762552.1| | 176306 | g557437 | i0 | 100 | 0.121739130434783 | 28 | 0 | 12 | 0 | 122 | 149 | 202712 | 202739 | MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. | |
| 14369971 | 14369971 | PRJNA1237347_P_NODE_320732_length_320_cov_1.870445_g314159_i0 | PRJNA1237347 | 320732 | 320 | 1.870445 | 5.985424 | Methanofervidicoccus sp. A16 | 2607662 | Archaea | Archaea | 52.8 | 0.03 | NTclustered | gi|1438970377|gb|CP022242.1| | 2607662 | g314159 | i0 | 96.774 | 0.096875 | 31 | 1 | 10 | 0 | 290 | 320 | 741381 | 741351 | Methanofervidicoccus sp. A16 chromosome, complete genome | blastn | 31 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanofervidicoccus | Methanofervidicoccus sp. A16 | ||
| 27249608 | 27249608 | PRJNA1237347_P_NODE_312603_length_325_cov_2.555556_g306030_i0 | PRJNA1237347 | 312603 | 325 | 2.555556 | 8.305557 | Methanobacteriati | 3366610 | Archaea | Archaea | 78.2 | 2.86e-14 | NR | WP_323736449.1 | 1452353 | g306030 | i0 | 41.5 | 13.6984615384615 | 106 | 54 | 97.8 | 2 | 323 | 6 | 227 | 324 | WP_323736449.1 translation elongation factor EF-1 subunit alpha [Methanosphaera sp. ISO3-F5] | diamond | 4452 | 78.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. ISO3-F5 | |
| 29062895 | 29062895 | PRJNA1237347_P_NODE_453948_length_257_cov_24.885870_g447375_i0 | PRJNA1237347 | 453948 | 257 | 24.88587 | 63.9566859 | Methanothermococcus sp. | 2614238 | Archaea | Archaea | 40.8 | 0.0269 | NR | MDK2988154.1 | 2614238 | g447375 | i0 | 41.5 | 0.618677042801556 | 53 | 27 | 59.5 | 2 | 239 | 87 | 6 | 56 | MDK2988154.1 inorganic phosphate transporter, PiT family [Methanothermococcus sp.] | diamond | 159 | 40.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanothermococcus | Methanothermococcus sp. | |
| 29396816 | 29396816 | PRJNA1237347_P_NODE_338069_length_310_cov_1.299578_g331496_i0 | PRJNA1237347 | 338069 | 310 | 1.299578 | 4.0286918 | root | 1 | Root_unresolved | Root_unresolved | 114 | 1.79e-27 | NR | WP_013179903.1 | 2188 | g331496 | i0 | 53.9 | 3.03870967741935 | 102 | 46 | 98.7 | 1 | 308 | 3 | 240 | 340 | WP_013179903.1 restriction endonuclease subunit S [Methanococcus voltae] | diamond | 942 | 114 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus voltae | |
| 29851731 | 29851731 | PRJNA1237347_P_NODE_104651_length_662_cov_1.273345_g98220_i0 | PRJNA1237347 | 104651 | 662 | 1.273345 | 8.4295439 | Methanothermobacter sp. THM-1 | 2606911 | Archaea | Archaea | 47 | 0.0355 | NR | WP_191216576.1 | 2606911 | g98220 | i0 | 34.4 | 0.276435045317221 | 61 | 38 | 27.2 | 2 | 482 | 661 | 71 | 130 | WP_191216576.1 DUF7411 family protein [Methanothermobacter sp. THM-1] | diamond | 183 | 47 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanothermobacter | Methanothermobacter sp. THM-1 | |
| 30186202 | 30186202 | PRJNA1237347_P_NODE_12992_length_2205_cov_2.011257_g11222_i0 | PRJNA1237347 | 12992 | 2205 | 2.011257 | 44.34821685 | root | 1 | Root_unresolved | Root_unresolved | 87.4 | 9.58e-14 | NR | WP_296885388.1 | 253161 | g11222 | i0 | 24.2 | 2.85034013605442 | 537 | 311 | 70.7 | 18 | 1824 | 265 | 122 | 579 | WP_296885388.1 IGHMBP2 family helicase [uncultured Methanobrevibacter sp.] | diamond | 6285 | 87.8 | 0.995444191343964 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | uncultured Methanobrevibacter sp. | |
| 31084112 | 31084112 | PRJNA1237347_P_NODE_288135_length_342_cov_2.468401_g281562_i0 | PRJNA1237347 | 288135 | 342 | 2.468401 | 8.44193142 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 48.1 | 0.00152 | NR | WP_244371746.1 | 2173 | g281562 | i0 | 29.2 | 2.34210526315789 | 89 | 56 | 78.1 | 1 | 332 | 66 | 496 | 577 | WP_244371746.1 Ig-like domain repeat protein [Methanobrevibacter smithii] | diamond | 801 | 48.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 32114879 | 32114879 | PRJNA1237347_P_NODE_301658_length_333_cov_1.176923_g295085_i0 | PRJNA1237347 | 301658 | 333 | 1.176923 | 3.91915359 | root | 1 | Root_unresolved | Root_unresolved | 132 | 2.74e-33 | NR | WP_181488698.1 | 39152 | g295085 | i0 | 60.6 | 5.9009009009009 | 109 | 42 | 97.3 | 1 | 331 | 8 | 562 | 670 | WP_181488698.1 N-6 DNA methylase [Methanococcus maripaludis] | diamond | 1965 | 132 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 32381035 | 32381035 | PRJNA1237347_P_NODE_293339_length_339_cov_1.007519_g286766_i0 | PRJNA1237347 | 293339 | 339 | 1.007519 | 3.41548941 | Methanobrevibacter sp. | 66852 | Archaea | Archaea | 44.3 | 0.0332 | NR | WP_330026081.1 | 66852 | g286766 | i0 | 30.7 | 0.893805309734513 | 101 | 67 | 88.5 | 2 | 33 | 332 | 1515 | 1613 | WP_330026081.1 right-handed parallel beta-helix repeat-containing protein, partial [Methanobrevibacter sp.] | diamond | 303 | 44.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. |
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);;