contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 298404 | 298404 | PRJNA1148190_P_NODE_641141_length_248_cov_0.880000_g629968_i0 | PRJNA1148190 | 641141 | 248 | 0.88 | 2.1824 | Methanobacterium formicicum | 2162 | Archaea | Archaea | 442 | 1.1399999999999995e-119 | NTclustered | gi|693274827|gb|CP006933.1| | 2162 | g629968 | i0 | 98.79 | 3.98387096774194 | 248 | 3 | 100 | 0 | 1 | 248 | 982321 | 982074 | Methanobacterium formicicum strain BRM9, complete genome | blastn | 988 | 442 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium formicicum | |
| 299604 | 299604 | PRJNA1148190_P_NODE_741061_length_243_cov_0.905882_g729888_i0 | PRJNA1148190 | 741061 | 243 | 0.905882 | 2.20129326 | Methanobrevibacter acididurans | 120963 | Archaea | Archaea | 449 | 6.65e-122 | NTclustered | gi|2871247231|gb|CP166991.1| | 120963 | g729888 | i0 | 100 | 1.81481481481481 | 243 | 0 | 100 | 0 | 1 | 243 | 1462158 | 1462400 | Methanobrevibacter acididurans strain DSM 15163 chromosome, complete genome | blastn | 441 | 449 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter acididurans | |
| 2311148 | 2311148 | PRJNA1148190_P_NODE_626502_length_249_cov_0.875000_g615329_i0 | PRJNA1148190 | 626502 | 249 | 0.875 | 2.17875 | Methanobrevibacter | 2172 | Archaea | Archaea | 460 | 3.16e-125 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g615329 | i0 | 100 | 7 | 249 | 0 | 100 | 0 | 1 | 249 | 779377 | 779625 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1743 | 460 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 4122747 | 4122747 | PRJNA1148190_P_NODE_447404_length_277_cov_1.200980_g436231_i0 | PRJNA1148190 | 447404 | 277 | 1.20098 | 3.3267146 | uncultured Methanobacterium sp. | 176306 | Archaea | Archaea | 429 | 1.0099999999999999e-115 | NTclustered | gi|2621703503|emb|OY762552.1| | 176306 | g436231 | i0 | 94.585 | 6.014440433213 | 277 | 15 | 100 | 0 | 1 | 277 | 306956 | 307232 | MAG: uncultured Methanobacterium sp. isolate 3f2017ab-9e69-417f-80a5-32741c1572f8 genome assembly, chromosome: 1 | blastn | 1666 | 429 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | uncultured Methanobacterium sp. | |
| 5400507 | 5400507 | PRJNA1148190_P_NODE_561665_length_255_cov_1.126374_g550492_i0 | PRJNA1148190 | 561665 | 255 | 1.126374 | 2.8722537 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 466 | 6.98e-127 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g550492 | i0 | 99.608 | 6.98823529411765 | 255 | 1 | 100 | 0 | 1 | 255 | 24552 | 24806 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1782 | 466 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 6674188 | 6674188 | PRJNA1148190_P_NODE_482066_length_270_cov_1.390863_g470893_i0 | PRJNA1148190 | 482066 | 270 | 1.390863 | 3.7553301 | Methanobrevibacter sp. TLL-48-HuF1 | 2870563 | Archaea | Archaea | 488 | 1.5899999999999995e-133 | NTclustered | gi|2246976648|gb|CP081485.1| | 2870563 | g470893 | i0 | 99.259 | 6.64444444444444 | 270 | 2 | 100 | 0 | 1 | 270 | 114770 | 115039 | Methanobrevibacter sp. TLL-48-HuF1 chromosome, complete genome | blastn | 1794 | 488 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. TLL-48-HuF1 | |
| 7948978 | 7948978 | PRJNA1148190_P_NODE_457367_length_275_cov_1.237624_g446194_i0 | PRJNA1148190 | 457367 | 275 | 1.237624 | 3.403466 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 483 | 7.559999999999998e-132 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g446194 | i0 | 98.545 | 6.90909090909091 | 275 | 1 | 100 | 1 | 1 | 275 | 1351703 | 1351432 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1900 | 483 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 7951075 | 7951075 | PRJNA1148190_P_NODE_611687_length_250_cov_0.870056_g600514_i0 | PRJNA1148190 | 611687 | 250 | 0.870056 | 2.17514 | Methanosphaera stadtmanae | 2317 | Archaea | Archaea | 435 | 1.92e-117 | NTclustered | gi|1721134173|emb|LR698975.1| | 2317 | g600514 | i0 | 98 | 1.624 | 250 | 5 | 100 | 0 | 1 | 250 | 1574033 | 1574282 | Methanosphaera stadtmanae isolate MGYG-HGUT-02164 genome assembly, chromosome: 1 | blastn | 406 | 435 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanosphaera | Methanosphaera stadtmanae | |
| 8689163 | 8689163 | PRJNA1148190_P_NODE_699247_length_245_cov_0.895349_g688074_i0 | PRJNA1148190 | 699247 | 245 | 0.895349 | 2.19360505 | Methanobrevibacter | 2172 | Archaea | Archaea | 448 | 2.41e-121 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g688074 | i0 | 99.592 | 7.93469387755102 | 245 | 1 | 100 | 0 | 1 | 245 | 1267327 | 1267571 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1944 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 10495951 | 10495951 | PRJNA1148190_P_NODE_213809_length_366_cov_1.313993_g202639_i0 | PRJNA1148190 | 213809 | 366 | 1.313993 | 4.80921438 | Methanobrevibacter millerae | 230361 | Archaea | Archaea | 52.8 | 0.035 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g202639 | i0 | 100 | 0.0765027322404372 | 28 | 0 | 8 | 0 | 247 | 274 | 409297 | 409324 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 10499497 | 10499497 | PRJNA1148190_P_NODE_445969_length_277_cov_1.455882_g434796_i0 | PRJNA1148190 | 445969 | 277 | 1.455882 | 4.03279314 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 58.4 | 5.48e-4 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g434796 | i0 | 92.683 | 0.148014440433213 | 41 | 2 | 15 | 1 | 171 | 211 | 24512 | 24473 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 41 | 58.4 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 11773581 | 11773581 | PRJNA1148190_P_NODE_384350_length_289_cov_1.745370_g373177_i0 | PRJNA1148190 | 384350 | 289 | 1.74537 | 5.0441193 | uncultured Methanobacteriaceae archaeon | 176233 | Archaea | Archaea | 156 | 1.98e-33 | NTclustered | gi|2874253795|emb|OY969779.1| | 176233 | g373177 | i0 | 86.111 | 0.498269896193772 | 144 | 20 | 50 | 0 | 146 | 289 | 2548495 | 2548352 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD04716.bin.c.1 genome assembly, chromosome: 1 | blastn | 144 | 156 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 12514106 | 12514106 | PRJNA1148190_P_NODE_486870_length_269_cov_1.464286_g475697_i0 | PRJNA1148190 | 486870 | 269 | 1.464286 | 3.93892934 | Methanococcus | 2184 | Archaea | Archaea | 52.8 | 0.025 | NTclustered | gi|2891706660|gb|CP178162.1| | 39152 | g475697 | i0 | 100 | 0.41635687732342 | 28 | 0 | 10 | 0 | 135 | 162 | 318727 | 318700 | Methanococcus maripaludis strain LL chromosome, complete genome | blastn | 112 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanococci | Methanococcales | Methanococcaceae | Methanococcus | Methanococcus maripaludis | |
| 15595764 | 15595764 | PRJNA1148190_P_NODE_249773_length_343_cov_2.170370_g238603_i0 | PRJNA1148190 | 249773 | 343 | 2.17037 | 7.4443691 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 172 | 2.39e-38 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g238603 | i0 | 76.656 | 49.3935860058309 | 317 | 71 | 92 | 3 | 8 | 323 | 195673 | 195359 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 16942 | 172 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 16338945 | 16338945 | PRJNA1148190_P_NODE_88373_length_575_cov_1.629482_g77239_i0 | PRJNA1148190 | 88373 | 575 | 1.629482 | 9.3695215 | Methanobacterium | 2160 | Archaea | Archaea | 56.5 | 0.004 | NTclustered | gi|1297867845|gb|CP017766.1| | 59277 | g77239 | i0 | 100 | 0.156521739130435 | 30 | 0 | 5 | 0 | 34 | 63 | 1974788 | 1974759 | Methanobacterium subterraneum strain MO-MB1 chromosome, complete genome | blastn | 90 | 56.5 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium subterraneum | |
| 16875720 | 16875720 | PRJNA1148190_P_NODE_664214_length_247_cov_0.885057_g653041_i0 | PRJNA1148190 | 664214 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 457 | 4.05e-124 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g653041 | i0 | 100 | 7 | 247 | 0 | 100 | 0 | 1 | 247 | 910885 | 911131 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 1729 | 457 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 18151919 | 18151919 | PRJNA1148190_P_NODE_788115_length_241_cov_0.916667_g776942_i0 | PRJNA1148190 | 788115 | 241 | 0.916667 | 2.20916747 | Methanobrevibacter arboriphilus | 39441 | Archaea | Archaea | 446 | 8.519999999999999e-121 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g776942 | i0 | 100 | 1.95020746887967 | 241 | 0 | 100 | 0 | 1 | 241 | 2357753 | 2357513 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 470 | 446 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 19423761 | 19423761 | PRJNA1148190_P_NODE_578456_length_251_cov_2.219101_g567283_i0 | PRJNA1148190 | 578456 | 251 | 2.219101 | 5.56994351 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 448 | 2.48e-121 | NTclustered | gi|2188913606|dbj|AP025587.1| | 2173 | g567283 | i0 | 98.805 | 3.31872509960159 | 251 | 3 | 100 | 0 | 1 | 251 | 1045349 | 1045599 | Methanobrevibacter smithii CE91-St68 DNA, complete genome | blastn | 833 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 21975422 | 21975422 | PRJNA1148190_P_NODE_662898_length_247_cov_0.885057_g651725_i0 | PRJNA1148190 | 662898 | 247 | 0.885057 | 2.18609079 | Methanobrevibacter smithii | 2173 | Archaea | Archaea | 451 | 1.88e-122 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g651725 | i0 | 99.595 | 5.92712550607287 | 247 | 1 | 100 | 0 | 1 | 247 | 1385124 | 1385370 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 1464 | 451 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 22713225 | 22713225 | PRJNA1148190_P_NODE_766498_length_242_cov_0.911243_g755325_i0 | PRJNA1148190 | 766498 | 242 | 0.911243 | 2.20520806 | Methanobrevibacter | 2172 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|2791693311|gb|CP144200.1| | 2173 | g755325 | i0 | 100 | 7 | 242 | 0 | 100 | 0 | 1 | 242 | 968179 | 968420 | Methanobrevibacter smithii strain GRAZ-2 chromosome, complete genome | blastn | 1694 | 448 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 23250465 | 23250465 | PRJNA1148190_P_NODE_626679_length_249_cov_0.875000_g615506_i0 | PRJNA1148190 | 626679 | 249 | 0.875 | 2.17875 | Methanobrevibacter sp. TLL-48-HuF1 | 2870563 | Archaea | Archaea | 433 | 6.89e-117 | NTclustered | gi|2246976648|gb|CP081485.1| | 2870563 | g615506 | i0 | 97.992 | 1 | 249 | 5 | 100 | 0 | 1 | 249 | 267207 | 267455 | Methanobrevibacter sp. TLL-48-HuF1 chromosome, complete genome | blastn | 249 | 433 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. TLL-48-HuF1 |
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);;