contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 601741 | 601741 | PRJNA630162_P_NODE_148081_length_165_cov_0.896552_g146558_i0 | PRJNA630162 | 148081 | 165 | 0.896552 | 1.4793108 | Methanobrevibacter olleyae | 294671 | Archaea | Archaea | 263 | 5.86e-66 | NTclustered | gi|998157363|gb|CP014265.1| | 294671 | g146558 | i0 | 96.296 | 16.9393939393939 | 162 | 3 | 96 | 3 | 2 | 160 | 1266619 | 1266780 | Methanobrevibacter olleyae strain YLM1 chromosome, complete genome | blastn | 2795 | 263 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter olleyae | |
| 1877626 | 1877626 | PRJNA630162_P_NODE_118242_length_175_cov_2.039683_g116719_i0 | PRJNA630162 | 118242 | 175 | 2.039683 | 3.56944525 | Methanobacterium sp. ERen5 | 2977359 | Archaea | Archaea | 62.1 | 2.45e-5 | NTclustered | gi|2264313079|gb|CP099988.1| | 2977359 | g116719 | i0 | 97.297 | 0.8 | 37 | 0 | 21 | 1 | 92 | 127 | 780681 | 780717 | MAG: Methanobacterium sp. ERen5 chromosome, complete genome | blastn | 140 | 62.1 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. ERen5 | |
| 3152938 | 3152938 | PRJNA630162_P_NODE_18063_length_438_cov_4.095116_g16555_i0 | PRJNA630162 | 18063 | 438 | 4.095116 | 17.93660808 | Methanobacterium alkalithermotolerans | 2731220 | Archaea | Archaea | 446 | 1.66e-120 | NTclustered | gi|2029999282|gb|CP058560.1| | 2731220 | g16555 | i0 | 85.275 | 120.563926940639 | 455 | 42 | 99 | 16 | 6 | 438 | 1650655 | 1651106 | Methanobacterium alkalithermotolerans strain CAN chromosome, complete genome | blastn | 52807 | 446 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alkalithermotolerans | |
| 5705037 | 5705037 | PRJNA630162_P_NODE_111305_length_179_cov_1.446154_g109782_i0 | PRJNA630162 | 111305 | 179 | 1.446154 | 2.58861566 | Methanobrevibacter millerae | 230361 | Archaea | Archaea | 171 | 4.01e-38 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g109782 | i0 | 85.119 | 0.93854748603352 | 168 | 23 | 93 | 2 | 10 | 176 | 2004217 | 2004051 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 168 | 171 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 8804243 | 8804243 | PRJNA630162_P_NODE_169387_length_155_cov_2.311321_g167864_i0 | PRJNA630162 | 169387 | 155 | 2.311321 | 3.58254755 | root | 1 | Root_unresolved | Root_unresolved | 213 | 5.52e-51 | NTclustered | gi|1294447101|gb|CP017803.1| | 2173 | g167864 | i0 | 93.151 | 91.2516129032258 | 146 | 8 | 94 | 2 | 3 | 148 | 459601 | 459458 | Methanobrevibacter smithii strain KB11 chromosome, complete genome | blastn | 14144 | 215 | 0.990697674418605 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter smithii | |
| 10079599 | 10079599 | PRJNA630162_P_NODE_109468_length_180_cov_1.473282_g107945_i0 | PRJNA630162 | 109468 | 180 | 1.473282 | 2.6519076 | Methanobacterium | 2160 | Archaea | Archaea | 291 | 2.9699999999999998e-74 | NTclustered | gi|584298062|gb|KF882001.1| | 2171 | g107945 | i0 | 96.571 | 112.772222222222 | 175 | 6 | 97 | 0 | 1 | 175 | 952 | 778 | Methanobacterium palustre strain F 23S ribosomal RNA gene, partial sequence | blastn | 20299 | 291 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium palustre | |
| 10080029 | 10080029 | PRJNA630162_P_NODE_69488_length_213_cov_1.268293_g67965_i0 | PRJNA630162 | 69488 | 213 | 1.268293 | 2.70146409 | Methanobrevibacter | 2172 | Archaea | Archaea | 303 | 4.69e-78 | NTclustered | gi|968564921|gb|CP011266.1| | 230361 | g67965 | i0 | 93.301 | 37.0610328638498 | 209 | 9 | 97 | 5 | 1 | 207 | 541559 | 541354 | Methanobrevibacter millerae strain SM9, complete genome | blastn | 7894 | 303 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter millerae | |
| 13905472 | 13905472 | PRJNA630162_P_NODE_63191_length_222_cov_2.936416_g61668_i0 | PRJNA630162 | 63191 | 222 | 2.936416 | 6.51884352 | Methanobacteriaceae | 2159 | Archaea | Archaea | 52.8 | 0.02 | NTclustered | gi|2047640843|dbj|AP019779.1| | 39441 | g61668 | i0 | 96.875 | 0.576576576576577 | 32 | 0 | 14 | 1 | 62 | 92 | 939319 | 939350 | Methanobrevibacter arboriphilus SA DNA, complete genome | blastn | 128 | 52.8 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter arboriphilus | |
| 14631427 | 14631427 | PRJNA630162_P_NODE_62192_length_224_cov_2.268571_g60669_i0 | PRJNA630162 | 62192 | 224 | 2.268571 | 5.08159904 | uncultured Methanobacteriaceae archaeon | 176233 | Archaea | Archaea | 350 | 6.300000000000001e-92 | NTclustered | gi|2874253877|emb|OY969932.1| | 176233 | g60669 | i0 | 95.853 | 46.5669642857143 | 217 | 8 | 97 | 1 | 1 | 217 | 29427 | 29642 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 | blastn | 10431 | 350 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 15179741 | 15179741 | PRJNA630162_P_NODE_21692_length_395_cov_2.968208_g20174_i0 | PRJNA630162 | 21692 | 395 | 2.968208 | 11.7244216 | Methanobrevibacter | 2172 | Archaea | Archaea | 713 | 0 | NTclustered | gi|5725307|emb|AJ009958.1| | 66852 | g20174 | i0 | 99.744 | 107.787341772152 | 390 | 0 | 98 | 1 | 1 | 389 | 1406 | 1017 | Methanobrevibacter sp. SM9 16S rRNA gene, partial | blastn | 42576 | 713 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobrevibacter | Methanobrevibacter sp. | |
| 15179785 | 15179785 | PRJNA630162_P_NODE_29672_length_332_cov_3.731449_g28150_i0 | PRJNA630162 | 29672 | 332 | 3.731449 | 12.38841068 | root | 1 | Root_unresolved | Root_unresolved | 407 | 5.789999999999999e-109 | NTclustered | gi|2165124678|dbj|LC664176.1| | 2164 | g28150 | i0 | 100 | 103.596385542169 | 220 | 0 | 100 | 0 | 113 | 332 | 1196 | 977 | Methanobacterium sp. TO1 gene for 16S rRNA, partial sequence | blastn | 34394 | 407 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 15905054 | 15905054 | PRJNA630162_P_NODE_3013_length_1068_cov_3.209028_g2273_i0 | PRJNA630162 | 3013 | 1068 | 3.209028 | 34.27241904 | Methanobacterium alcaliphilum | 392018 | Archaea | Archaea | 1554 | 0 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g2273 | i0 | 93.045 | 158.035580524345 | 1064 | 72 | 99 | 2 | 3 | 1064 | 1746 | 683 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 168782 | 1554 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 18453478 | 18453478 | PRJNA630162_P_NODE_11795_length_556_cov_2.477318_g10338_i0 | PRJNA630162 | 11795 | 556 | 2.477318 | 13.77388808 | Methanobacterium alcaliphilum | 392018 | Archaea | Archaea | 907 | 0 | NTclustered | gi|584298067|gb|KF882006.1| | 392018 | g10338 | i0 | 96.37 | 176.519784172662 | 551 | 20 | 99 | 0 | 6 | 556 | 1932 | 2482 | Methanobacterium alcaliphilum strain WeN4 23S ribosomal RNA gene, partial sequence | blastn | 98145 | 907 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium alcaliphilum | |
| 19727998 | 19727998 | PRJNA630162_P_NODE_110596_length_179_cov_2.292308_g109073_i0 | PRJNA630162 | 110596 | 179 | 2.292308 | 4.10323132 | Methanobacterium aridiramus | 2584467 | Archaea | Archaea | 300 | 4.9e-77 | NTclustered | gi|2523005876|gb|CP040735.1| | 2584467 | g109073 | i0 | 97.701 | 50.7486033519553 | 174 | 4 | 97 | 0 | 6 | 179 | 1373410 | 1373583 | Methanobacterium aridiramus strain CWC-01 chromosome, complete genome | blastn | 9084 | 300 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium aridiramus | |
| 19729307 | 19729307 | PRJNA630162_P_NODE_83716_length_197_cov_3.108108_g82193_i0 | PRJNA630162 | 83716 | 197 | 3.108108 | 6.12297276 | uncultured Methanobacteriaceae archaeon | 176233 | Archaea | Archaea | 318 | 1.52e-82 | NTclustered | gi|2874253877|emb|OY969932.1| | 176233 | g82193 | i0 | 96.373 | 140.507614213198 | 193 | 7 | 98 | 0 | 1 | 193 | 28139 | 28331 | MAG: uncultured Methanobacteriaceae archaeon isolate MFD09286.bin.c.5 genome assembly, chromosome: 1 | blastn | 27680 | 318 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | uncultured Methanobacteriaceae archaeon | ||
| 22828688 | 22828688 | PRJNA630162_P_NODE_16198_length_466_cov_4.484412_g14700_i0 | PRJNA630162 | 16198 | 466 | 4.484412 | 20.89735992 | root | 1 | Root_unresolved | Root_unresolved | 822 | 0 | NTclustered | gi|2230636480|gb|ON341022.1| | 2164 | g14700 | i0 | 98.498 | 106.961373390558 | 466 | 7 | 100 | 0 | 1 | 466 | 907 | 442 | Methanobacterium sp. strain ERen54 16S ribosomal RNA gene, partial sequence | blastn | 49844 | 828 | 0.992753623188406 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanobacteriaceae | Methanobacterium | Methanobacterium sp. | |
| 25378034 | 25378034 | PRJNA630162_P_NODE_84760_length_196_cov_2.612245_g83237_i0 | PRJNA630162 | 84760 | 196 | 2.612245 | 5.1200002 | Methanobacteriota | 28890 | Archaea | Archaea | 71.3 | 4.68e-8 | NTclustered | gi|507148390|ref|NR_103193.1| | 2180 | g83237 | i0 | 93.617 | 2.02551020408163 | 47 | 3 | 24 | 0 | 73 | 119 | 1176 | 1222 | Methanothermus fervidus strain DSM 2088 23S ribosomal RNA gene, complete sequence | blastn | 397 | 71.3 | 1 | Archaea | Methanomada group | Methanobacteriati | Methanobacteriota | Methanobacteria | Methanobacteriales | Methanothermaceae | Methanothermus | Methanothermus fervidus |
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);;