contig_metadata
19 rows where bioproject = "PRJNA1240804" and tax_clade = "Methanomada group"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1049863 | 1049863 | PRJNA1240804_P_NODE_119161_length_167_cov_0.881356_g118795_i0 | PRJNA1240804 | 119161 | 167 | 0.881356 | 1.47186452 | Methanobacterium | 2160 | Archaea | Archaea | 255 | 9.950000000000001e-64 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g118795 | i0 | 96.732 | 9.32335329341317 | 153 | 5 | 92 | 0 | 1 | 153 | 2398264 | 2398416 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 1557 | 255 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 9276762 | 9276762 | PRJNA1240804_P_NODE_55028_length_212_cov_0.938650_g54662_i0 | PRJNA1240804 | 55028 | 212 | 0.93865 | 1.989938 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 259 | 1.02e-64 | NTclustered | gi|2621703503|emb|OY762552.1| | 176306 | g54662 | i0 | 90.355 | 4.56132075471698 | 197 | 19 | 93 | 0 | 2 | 198 | 1161598 | 1161794 | MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 | blastn | 967 | 259 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. | |
| 11253675 | 11253675 | PRJNA1240804_P_NODE_77349_length_188_cov_1.568345_g76983_i0 | PRJNA1240804 | 77349 | 188 | 1.568345 | 2.9484886 | Methanobrevibacter | 2172 | Archaea | Archaea | 289 | 1.13e-73 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g76983 | i0 | 96.552 | 107.037234042553 | 174 | 6 | 93 | 0 | 15 | 188 | 1285789 | 1285962 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 20123 | 289 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16352603 | 16352603 | PRJNA1240804_P_NODE_37713_length_243_cov_1.515464_g37347_i0 | PRJNA1240804 | 37713 | 243 | 1.515464 | 3.68257752 | root | 1 | Root_unresolved | Root_unresolved | 387 | 5.29e-103 | NTclustered | gi|110180137|gb|DQ649323.1| | 2162 | g37347 | i0 | 96.97 | 98.6666666666667 | 231 | 5 | 94 | 2 | 15 | 243 | 67 | 297 | Methanobacterium formicicum strain 14 16S ribosomal RNA gene, partial sequence | blastn | 23976 | 387 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 16926537 | 16926537 | PRJNA1240804_P_NODE_94774_length_177_cov_0.828125_g94408_i0 | PRJNA1240804 | 94774 | 177 | 0.828125 | 1.46578125 | Methanobacterium sp. ERen5 | 2977359 | Archaea | Archaea | 154 | 3.98e-33 | NTclustered | gi|2264313079|gb|CP099988.1| | 2977359 | g94408 | i0 | 88.281 | 2.75706214689266 | 128 | 15 | 72 | 0 | 1 | 128 | 1456930 | 1456803 | MAG: Methanobacterium sp. ERen5 chromosome, complete genome | blastn | 488 | 154 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ERen5 | |
| 18901887 | 18901887 | PRJNA1240804_P_NODE_79155_length_187_cov_1.391304_g78789_i0 | PRJNA1240804 | 79155 | 187 | 1.391304 | 2.60173848 | Methanobacterium sp. PtaU1.Bin | 2164 | Archaea | Archaea | 113 | 8.480000000000001e-29 | NR | OPY20905.1 | 1811675 | g78789 | i0 | 93.2 | 0.946524064171123 | 59 | 4 | 94.7 | 0 | 10 | 186 | 95 | 153 | OPY20905.1 MAG: hypothetical protein A4E26_01753 [Methanobacterium sp. PtaU1.Bin097] | diamond | 177 | 113 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. PtaU1.Bin097 | |
| 20176033 | 20176033 | PRJNA1240804_P_NODE_104516_length_170_cov_1.743802_g104150_i0 | PRJNA1240804 | 104516 | 170 | 1.743802 | 2.9644634 | Methanobacterium | 2160 | Archaea | Archaea | 265 | 1.68e-66 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g104150 | i0 | 98.039 | 47.5058823529412 | 153 | 2 | 89 | 1 | 14 | 165 | 1149394 | 1149546 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 8076 | 265 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 20176292 | 20176292 | PRJNA1240804_P_NODE_24476_length_288_cov_1.907950_g24110_i0 | PRJNA1240804 | 24476 | 288 | 1.90795 | 5.494896 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g24110 | i0 | 97.059 | 12.5277777777778 | 34 | 0 | 12 | 1 | 134 | 167 | 265516 | 265484 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 3608 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 23299890 | 23299890 | PRJNA1240804_P_NODE_143179_length_163_cov_0.912281_g142813_i0 | PRJNA1240804 | 143179 | 163 | 0.912281 | 1.48701803 | Methanosphaera sp. ISO3-F5 | 1452353 | Archaea | Archaea | 69.4 | 1.35e-7 | NTclustered | gi|2695672494|gb|CP118753.2| | 1452353 | g142813 | i0 | 77.966 | 1.4601226993865 | 118 | 21 | 69 | 3 | 17 | 129 | 1474151 | 1474268 | Methanosphaera sp. ISO3-F5 chromosome, complete genome | blastn | 238 | 69.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. ISO3-F5 | |
| 24001988 | 24001988 | PRJNA1240804_P_NODE_132879_length_165_cov_0.896552_g132513_i0 | PRJNA1240804 | 132879 | 165 | 0.896552 | 1.4793108 | Methanobacterium | 2160 | Archaea | Archaea | 250 | 4.5599999999999996e-62 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g132513 | i0 | 96.104 | 17.1454545454545 | 154 | 4 | 92 | 2 | 12 | 163 | 1409873 | 1410026 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 2829 | 250 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 27073411 | 27073411 | PRJNA1240804_P_NODE_112202_length_168_cov_1.546218_g111836_i0 | PRJNA1240804 | 112202 | 168 | 1.546218 | 2.59764624 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 94.4 | 3.14e-22 | NR | NYB27483.1 | 2099680 | g111836 | i0 | 100 | 0.785714285714286 | 44 | 0 | 78.6 | 0 | 166 | 35 | 91 | 134 | NYB27483.1 flavodoxin family protein [Methanobacteriaceae archaeon] | diamond | 132 | 94.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 27073504 | 27073504 | PRJNA1240804_P_NODE_71942_length_192_cov_1.342657_g71576_i0 | PRJNA1240804 | 71942 | 192 | 1.342657 | 2.57790144 | Methanobacterium sp. | 2164 | Archaea | Archaea | 115 | 1.82e-28 | NR | MCC7564072.1 | 2164 | g71576 | i0 | 98.3 | 0.921875 | 59 | 1 | 92.2 | 0 | 1 | 177 | 12 | 70 | MCC7564072.1 nucleotide sugar dehydrogenase [Methanobacterium sp.] | diamond | 177 | 115 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 27673879 | 27673879 | PRJNA1240804_P_NODE_121464_length_167_cov_0.881356_g121098_i0 | PRJNA1240804 | 121464 | 167 | 0.881356 | 1.47186452 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 94.7 | 9.27e-24 | NR | NYB26638.1 | 2099680 | g121098 | i0 | 98 | 0.880239520958084 | 49 | 1 | 88 | 0 | 18 | 164 | 1 | 49 | NYB26638.1 hypothetical protein [Methanobacteriaceae archaeon] | diamond | 147 | 94.7 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 27957867 | 27957867 | PRJNA1240804_P_NODE_11545_length_386_cov_2.427300_g11180_i0 | PRJNA1240804 | 11545 | 386 | 2.4273 | 9.369378 | Methanosphaera sp. rholeuAM27 | 2666342 | Archaea | Archaea | 56.6 | 2.36e-6 | NR | RAP51160.1 | 1945577 | g11180 | i0 | 34.2 | 0.932642487046632 | 120 | 76 | 91.7 | 2 | 354 | 1 | 222 | 340 | RAP51160.1 MAG: hypothetical protein BZ138_05820 [Methanosphaera sp. rholeuAM270] | diamond | 360 | 56.6 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera sp. rholeuAM270 | |
| 28273488 | 28273488 | PRJNA1240804_P_NODE_149566_length_162_cov_0.920354_g149200_i0 | PRJNA1240804 | 149566 | 162 | 0.920354 | 1.49097348 | Methanobacterium sp. PtaU1.Bin | 2164 | Archaea | Archaea | 88.2 | 5.76e-20 | NR | OPY19753.1 | 1811675 | g149200 | i0 | 100 | 0.814814814814815 | 44 | 0 | 81.5 | 0 | 151 | 20 | 5 | 48 | OPY19753.1 MAG: Ribonuclease HII [Methanobacterium sp. PtaU1.Bin097] | diamond | 132 | 88.2 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. PtaU1.Bin097 | |
| 29378806 | 29378806 | PRJNA1240804_P_NODE_82929_length_184_cov_2.148148_g82563_i0 | PRJNA1240804 | 82929 | 184 | 2.148148 | 3.95259232 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 112 | 1.53e-28 | NR | NYB27879.1 | 2099680 | g82563 | i0 | 98.3 | 0.945652173913043 | 58 | 1 | 94.6 | 0 | 183 | 10 | 149 | 206 | NYB27879.1 diphthine synthase [Methanobacteriaceae archaeon] | diamond | 174 | 112 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon | ||
| 29568032 | 29568032 | PRJNA1240804_P_NODE_128250_length_166_cov_0.888889_g127884_i0 | PRJNA1240804 | 128250 | 166 | 0.888889 | 1.47555574 | Methanobacterium sp. | 2164 | Archaea | Archaea | 97.1 | 4.1800000000000003e-22 | NR | HEY0196123.1 | 2164 | g127884 | i0 | 88.9 | 1.93373493975904 | 54 | 6 | 97.6 | 0 | 164 | 3 | 207 | 260 | HEY0196123.1 acetylornithine transaminase [Methanobacterium sp.] | diamond | 321 | 97.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 31653530 | 31653530 | PRJNA1240804_P_NODE_121417_length_167_cov_0.881356_g121051_i0 | PRJNA1240804 | 121417 | 167 | 0.881356 | 1.47186452 | Methanobacterium congolense | 118062 | Archaea | Archaea | 60.5 | 7.4e-9 | NR | WP_071906846.1 | 118062 | g121051 | i0 | 54.2 | 0.862275449101796 | 48 | 21 | 86.2 | 1 | 1 | 144 | 372 | 418 | WP_071906846.1 pseudomurein-binding repeat-containing protein [Methanobacterium congolense] | diamond | 144 | 60.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium congolense | |
| 32728681 | 32728681 | PRJNA1240804_P_NODE_128180_length_166_cov_0.888889_g127814_i0 | PRJNA1240804 | 128180 | 166 | 0.888889 | 1.47555574 | Methanobacteriaceae archaeon | 2099680 | Archaea | Archaea | 90.1 | 2.69e-19 | NR | NYB27195.1 | 2099680 | g127814 | i0 | 93.5 | 0.831325301204819 | 46 | 3 | 83.1 | 0 | 16 | 153 | 210 | 255 | NYB27195.1 right-handed parallel beta-helix repeat-containing protein [Methanobacteriaceae archaeon] | diamond | 138 | 90.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacteriaceae archaeon |
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);;