RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax_phylum = "Thermoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermoplasmatota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJNA879314 · 23 ✖

analysis 1

  • blastn · 23 ✖

tax_clade 0

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
2133161 2133161 PRJNA879314_P_NODE_10742_length_243_cov_0.917647_g10692_i0 PRJNA879314 10742 243 0.917647 2.22988221 Methanomethylophilus alvi 1291540 Archaea Archaea 230 9.43e-56   NTclustered gi|1721134198|emb|LR699000.1| 1291540 g10692 i0 83.951 2 243 35 99 4 1 241 1364758 1364518 Candidatus Methanomethylophilus alvus isolate MGYG-HGUT-02456 genome assembly, chromosome: 1 blastn 486 230 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Methanomethylophilus Methanomethylophilus alvi
2133195 2133195 PRJNA879314_P_NODE_3102_length_284_cov_1.109005_g3052_i0 PRJNA879314 3102 284 1.109005 3.1495742 Candidatus Methanoplasma termitum 1577791 Archaea Archaea 124 5.48e-24   NTclustered gi|731480732|gb|CP010070.1| 1577791 g3052 i0 100 2.17605633802817 67 0 24 0 1 67 316053 316119 Candidatus Methanoplasma termitum strain MpT1, complete genome blastn 618 124 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanoplasma Candidatus Methanoplasma termitum
2133223 2133223 PRJNA879314_P_NODE_5482_length_251_cov_0.876404_g5432_i0 PRJNA879314 5482 251 0.876404 2.19977404 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 318 2.03e-82   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g5432 i0 89.641 35.0876494023904 251 24 99 2 1 250 1816327 1816576 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 8807 318 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
2133278 2133278 PRJNA879314_P_NODE_9702_length_244_cov_0.947368_g9652_i0 PRJNA879314 9702 244 0.947368 2.31157792 Methanomethylophilus alvi 1291540 Archaea Archaea 191 4.47e-44   NTclustered gi|1721134198|emb|LR699000.1| 1291540 g9652 i0 81.172 1.95901639344262 239 43 98 2 3 240 982434 982197 Candidatus Methanomethylophilus alvus isolate MGYG-HGUT-02456 genome assembly, chromosome: 1 blastn 478 191 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae Methanomethylophilus Methanomethylophilus alvi
3408633 3408633 PRJNA879314_P_NODE_2543_length_303_cov_1.017391_g2493_i0 PRJNA879314 2543 303 1.017391 3.08269473 Thermoplasmatales archaeon BRNA1 1054217 Archaea Archaea 287 7.11e-73   NTclustered gi|472831278|gb|CP002916.1| 1054217 g2493 i0 83.828 4.74587458745875 303 47 99 2 1 302 1362287 1362588 Thermoplasmatales archaeon BRNA1, complete genome blastn 1438 287 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon BRNA1
4686246 4686246 PRJNA879314_P_NODE_3604_length_271_cov_1.949495_g3554_i0 PRJNA879314 3604 271 1.949495 5.28313145 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 222 1.79e-53   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g3554 i0 88.172 4.08856088560886 186 22 69 0 4 189 108457 108272 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 1108 222 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
7236052 7236052 PRJNA879314_P_NODE_8006_length_247_cov_0.896552_g7956_i0 PRJNA879314 8006 247 0.896552 2.21448344 Methanomassiliicoccaceae archaeon 2052168 Archaea Archaea 346 9.14e-91   NTclustered gi|2621703346|emb|OY760646.1| 2052168 g7956 i0 91.903 1 247 20 100 0 1 247 1879970 1879724 MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 blastn 247 346 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
9785735 9785735 PRJNA879314_P_NODE_6808_length_249_cov_0.886364_g6758_i0 PRJNA879314 6808 249 0.886364 2.20704636 Candidatus Methanogranum gryphiswaldense 2848114 Archaea Archaea 207 4.54e-49   NTclustered gi|2067799480|gb|CP076745.1| 2848114 g6758 i0 81.781 0.991967871485944 247 45 99 0 1 247 199786 200032 MAG: Candidatus Methanogranum gryphiswaldense isolate U3.2.1 chromosome, complete genome blastn 247 207 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanogranum Candidatus Methanogranum gryphiswaldense
9785760 9785760 PRJNA879314_P_NODE_8568_length_246_cov_0.901734_g8518_i0 PRJNA879314 8568 246 0.901734 2.21826564 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 303 5.56e-78   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g8518 i0 89.873 11.4959349593496 237 22 96 2 9 244 731054 730819 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 2828 303 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
9785778 9785778 PRJNA879314_P_NODE_9768_length_244_cov_0.912281_g9718_i0 PRJNA879314 9768 244 0.912281 2.22596564 Methanomassiliicoccaceae archaeon 2052168 Archaea Archaea 315 2.5399999999999992e-81   NTclustered gi|2621703346|emb|OY760646.1| 2052168 g9718 i0 90.083 0.991803278688525 242 24 99 0 1 242 1566906 1567147 MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 blastn 242 315 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
13611480 13611480 PRJNA879314_P_NODE_2151_length_321_cov_0.943548_g2101_i0 PRJNA879314 2151 321 0.943548 3.02878908 Candidatus Methanogranum gryphiswaldense 2848114 Archaea Archaea 119 2.93e-22   NTclustered gi|2067799480|gb|CP076745.1| 2848114 g2101 i0 88.235 2.13395638629284 102 9 32 3 72 173 829848 829750 MAG: Candidatus Methanogranum gryphiswaldense isolate U3.2.1 chromosome, complete genome blastn 685 119 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanogranum Candidatus Methanogranum gryphiswaldense
13611522 13611522 PRJNA879314_P_NODE_5971_length_251_cov_0.876404_g5921_i0 PRJNA879314 5971 251 0.876404 2.19977404 Methanomassiliicoccaceae archaeon 2052168 Archaea Archaea 143 1.31e-29   NTclustered gi|2621703346|emb|OY760646.1| 2052168 g5921 i0 77.642 0.9800796812749 246 47 96 6 1 242 2267821 2268062 MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 blastn 246 143 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
14885839 14885839 PRJNA879314_P_NODE_2152_length_321_cov_0.935484_g2102_i0 PRJNA879314 2152 321 0.935484 3.00290364 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 86.1 2.97e-12   NTclustered gi|2621784586|emb|OY781044.1| 2517205 g2102 i0 79.07 0.401869158878505 129 23 40 4 1 128 491407 491532 MAG: Candidatus Methanomethylophilaceae archaeon isolate 11c15bc4-9f39-4069-9170-00aaf79b19ed genome assembly, chromosome: 1 blastn 129 86.1 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
14885865 14885865 PRJNA879314_P_NODE_4272_length_254_cov_1.292818_g4222_i0 PRJNA879314 4272 254 1.292818 3.28375772 Candidatus Methanomethylophilaceae archaeon 2517205 Archaea Archaea 195 3.62e-45   NTclustered gi|2621784586|emb|OY781044.1| 2517205 g4222 i0 86.441 0.696850393700787 177 24 70 0 78 254 856551 856375 MAG: Candidatus Methanomethylophilaceae archaeon isolate 11c15bc4-9f39-4069-9170-00aaf79b19ed genome assembly, chromosome: 1 blastn 177 195 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomethylophilaceae   Candidatus Methanomethylophilaceae archaeon
16160559 16160559 PRJNA879314_P_NODE_7293_length_248_cov_0.891429_g7243_i0 PRJNA879314 7293 248 0.891429 2.21074392 Methanomassiliicoccaceae archaeon 2052168 Archaea Archaea 209 1.26e-49   NTclustered gi|2621703346|emb|OY760646.1| 2052168 g7243 i0 82.627 0.951612903225806 236 41 95 0 5 240 866740 866975 MAG: Methanomassiliicoccaceae archaeon isolate 2dded12f-1c8b-4e4a-b374-f87b1937d54c genome assembly, chromosome: 1 blastn 236 209 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon
17436021 17436021 PRJNA879314_P_NODE_2894_length_290_cov_1.078341_g2844_i0 PRJNA879314 2894 290 1.078341 3.1271889 Candidatus Methanoplasma termitum 1577791 Archaea Archaea 182 3.28e-41   NTclustered gi|731480732|gb|CP010070.1| 1577791 g2844 i0 80.591 1.5551724137931 237 44 81 2 12 247 556008 555773 Candidatus Methanoplasma termitum strain MpT1, complete genome blastn 451 182 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanoplasma Candidatus Methanoplasma termitum
17436025 17436025 PRJNA879314_P_NODE_3354_length_277_cov_1.441176_g3304_i0 PRJNA879314 3354 277 1.441176 3.99205752 Methanomassiliicoccales archaeon LGM-DZ1 3018978 Archaea Archaea 195 4e-45   NTclustered gi|2514100973|gb|CP115556.1| 3018978 g3304 i0 80 1.90613718411552 270 49 96 5 1 267 1372549 1372816 Methanomassiliicoccales archaeon LGM-DZ1 chromosome, complete genome blastn 528 195 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon LGM-DZ1
18709266 18709266 PRJNA879314_P_NODE_6115_length_250_cov_0.881356_g6065_i0 PRJNA879314 6115 250 0.881356 2.20339 Methanomassiliicoccaceae archaeon DOK 1535962 Archaea Archaea 169 2.15e-37   NTclustered gi|1799215713|gb|CP047880.1| 1535962 g6065 i0 87.162 2.308 148 19 59 0 70 217 494947 495094 Methanomassiliicoccaceae archaeon DOK chromosome, complete genome blastn 577 169 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae   Methanomassiliicoccaceae archaeon DOK
19984507 19984507 PRJNA879314_P_NODE_10876_length_242_cov_1.384615_g10826_i0 PRJNA879314 10876 242 1.384615 3.3507683 Thermoplasmatales archaeon BRNA1 1054217 Archaea Archaea 222 1.57e-53   NTclustered gi|472831278|gb|CP002916.1| 1054217 g10826 i0 84.279 0.946280991735537 229 34 94 2 1 228 610993 611220 Thermoplasmatales archaeon BRNA1, complete genome blastn 229 222 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales     Thermoplasmatales archaeon BRNA1
19984590 19984590 PRJNA879314_P_NODE_756_length_485_cov_1.325243_g706_i0 PRJNA879314 756 485 1.325243 6.42742855 Candidatus Methanogranum gryphiswaldense 2848114 Archaea Archaea 484 3.929999999999999e-132   NTclustered gi|2067799480|gb|CP076745.1| 2848114 g706 i0 85.084 4.27010309278351 476 69 98 2 1 475 69975 69501 MAG: Candidatus Methanogranum gryphiswaldense isolate U3.2.1 chromosome, complete genome blastn 2071 484 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanogranum Candidatus Methanogranum gryphiswaldense
21259886 21259886 PRJNA879314_P_NODE_2597_length_301_cov_0.890351_g2547_i0 PRJNA879314 2597 301 0.890351 2.67995651 methanogenic archaeon ISO4-H5 1495144 Archaea Archaea 189 2.05e-43   NTclustered gi|992543061|gb|CP014214.1| 1495144 g2547 i0 86.55 0.568106312292359 171 23 57 0 71 241 142978 143148 Methanogenic archaeon ISO4-H5 chromosome, complete genome blastn 171 189 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata       methanogenic archaeon ISO4-H5
22534535 22534535 PRJNA879314_P_NODE_3458_length_275_cov_1.158416_g3408_i0 PRJNA879314 3458 275 1.158416 3.185644 Candidatus Methanoplasma termitum 1577791 Archaea Archaea 67.6 9.03e-7   NTclustered gi|731480732|gb|CP010070.1| 1577791 g3408 i0 82.051 0.283636363636364 78 14 28 0 6 83 763708 763631 Candidatus Methanoplasma termitum strain MpT1, complete genome blastn 78 67.6 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanoplasma Candidatus Methanoplasma termitum
25084026 25084026 PRJNA879314_P_NODE_9980_length_244_cov_0.912281_g9930_i0 PRJNA879314 9980 244 0.912281 2.22596564 Methanomassiliicoccales archaeon LGM-RCC1 3018355 Archaea Archaea 128 3.55e-25   NTclustered gi|2514099340|gb|CP115555.1| 3018355 g9930 i0 81.366 0.659836065573771 161 26 65 4 81 239 185086 185244 Methanomassiliicoccales archaeon LGM-RCC1 chromosome, complete genome blastn 161 128 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales     Methanomassiliicoccales archaeon LGM-RCC1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;