RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJEB10140" and tax_kingdom = "Methanobacteriati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Methanobacteriati · 15 ✖

bioproject 1

  • PRJEB10140 · 15 ✖

analysis 1

  • blastn · 15 ✖
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
2562809 2562809 PRJEB10140_P_NODE_285303_length_163_cov_0.877193_g267994_i0 PRJEB10140 285303 163 0.877193 1.42982459 Methanobrevibacter millerae 230361 Archaea Archaea 134 4.72e-27   NTclustered gi|968564921|gb|CP011266.1| 230361 g267994 i0 81.595 1 163 28 99 2 2 163 757 596 Methanobrevibacter millerae strain SM9, complete genome blastn 163 134 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter millerae
5115691 5115691 PRJEB10140_P_NODE_72905_length_503_cov_7.222467_g55742_i0 PRJEB10140 72905 503 7.222467 36.32900901 Acidiplasma sp. 1872114 Archaea Archaea 52.8 0.049   NTclustered gi|2573969472|gb|CP133599.1| 1872114 g55742 i0 100 0.0556660039761431 28 0 6 0 411 438 625798 625825 MAG: Acidiplasma sp. isolate BR_02 chromosome, complete genome blastn 28 52.8 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Ferroplasmaceae Acidiplasma Acidiplasma sp.
6390701 6390701 PRJEB10140_P_NODE_256906_length_167_cov_0.881356_g239597_i0 PRJEB10140 256906 167 0.881356 1.47186452 Methanosphaera sp. BMS 1789762 Archaea Archaea 309 7.53e-80   NTclustered gi|1409374143|gb|CP014213.1| 1789762 g239597 i0 100 1 167 0 100 0 1 167 1717993 1717827 Methanosphaera sp. BMS chromosome, complete genome blastn 167 309 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanosphaera Methanosphaera sp. BMS
6391412 6391412 PRJEB10140_P_NODE_59186_length_619_cov_3.000000_g42539_i0 PRJEB10140 59186 619 3 18.57 uncultured Candidatus Methanogranum sp. 2093355 Archaea Archaea 54.7 0.017   NTclustered gi|2621784480|emb|OY780938.1| 2093355 g42539 i0 100 0.0936995153473344 29 0 5 0 79 107 1261363 1261391 MAG: uncultured Candidatus Methanogranum sp. isolate 9d90576e-3f35-4afd-8682-ecdb60e67c32 genome assembly, chromosome: 1 blastn 58 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Methanomassiliicoccales Methanomassiliicoccaceae Candidatus Methanogranum uncultured Candidatus Methanogranum sp.
7664871 7664871 PRJEB10140_P_NODE_263387_length_166_cov_0.888889_g246078_i0 PRJEB10140 263387 166 0.888889 1.47555574 Methanobrevibacter sp. YE315 1609968 Archaea Archaea 176 7.91e-40   NTclustered gi|985614202|gb|CP010834.1| 1609968 g246078 i0 85.976 0.987951807228916 164 23 99 0 3 166 524045 523882 Methanobrevibacter sp. YE315, complete genome blastn 164 176 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter sp. YE315
7665029 7665029 PRJEB10140_P_NODE_274807_length_164_cov_0.904348_g257498_i0 PRJEB10140 274807 164 0.904348 1.48313072 Methanobrevibacter ruminantium 83816 Archaea Archaea 147 6.109999999999999e-31   NTclustered gi|288541968|gb|CP001719.1| 634498 g257498 i0 83.648 0.969512195121951 159 23 96 3 7 164 2479778 2479622 Methanobrevibacter ruminantium M1, complete genome blastn 159 147 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter ruminantium
8940359 8940359 PRJEB10140_P_NODE_82928_length_441_cov_7.612245_g65667_i0 PRJEB10140 82928 441 7.612245 33.57000045 Candidatus Methanoperedenaceae archaeon GB37 2691037 Archaea Archaea 56.5 0.003   NTclustered gi|1964039634|emb|LR991653.1| 2691037 g65667 i0 96.97 0.0748299319727891 33 1 7 0 75 107 1721911 1721879 Candidatus Methanoperedenaceae archaeon GB37 isolate gfbio:2ba61e4a-a911-483b-ba5e-e0ad8afd3b38:GoM-Arc1_E37 genome assembly, chromosome: 1 blastn 33 56.5 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanosarcinales Candidatus Methanoperedentaceae   Candidatus Methanoperedenaceae archaeon GB37
10214239 10214239 PRJEB10140_P_NODE_115869_length_315_cov_2.533835_g98563_i0 PRJEB10140 115869 315 2.533835 7.98158025 Picrophilus oshimae 46632 Archaea Archaea 54.7 0.008   NTclustered gi|48429720|gb|AE017261.1| 1122961 g98563 i0 100 0.0920634920634921 29 0 9 0 267 295 836273 836245 Picrophilus torridus DSM 9790, complete genome blastn 29 54.7 1 Archaea   Methanobacteriati Thermoplasmatota Thermoplasmata Thermoplasmatales Picrophilaceae Picrophilus Picrophilus oshimae
11489888 11489888 PRJEB10140_P_NODE_185090_length_208_cov_0.899371_g167781_i0 PRJEB10140 185090 208 0.899371 1.87069168 Thermococcus eurythermalis 1505907 Archaea Archaea 52.8 0.018   NTclustered gi|700302025|gb|CP008887.1| 1505907 g167781 i0 100 0.134615384615385 28 0 13 0 121 148 1432384 1432357 Thermococcus eurythermalis strain A501, complete genome blastn 28 52.8 1 Archaea   Methanobacteriati Methanobacteriota Thermococci Thermococcales Thermococcaceae Thermococcus Thermococcus eurythermalis
17865118 17865118 PRJEB10140_P_NODE_79335_length_462_cov_4.239709_g62093_i0 PRJEB10140 79335 462 4.239709 19.58745558 Methanocaldococcus jannaschii 2190 Archaea Archaea 52.8 0.045   NTclustered gi|6626255|gb|L77117.1| 243232 g62093 i0 94.286 0.0757575757575758 35 0 8 2 405 439 442886 442918 Methanocaldococcus jannaschii DSM 2661, complete genome blastn 35 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanococci Methanococcales Methanocaldococcaceae Methanocaldococcus Methanocaldococcus jannaschii
19137319 19137319 PRJEB10140_P_NODE_174276_length_218_cov_1.739645_g156967_i0 PRJEB10140 174276 218 1.739645 3.7924261 Methanocorpusculum labreanum 83984 Archaea Archaea 52.8 0.019   NTclustered gi|124362370|gb|CP000559.1| 410358 g156967 i0 100 0.128440366972477 28 0 13 0 159 186 1026969 1026942 Methanocorpusculum labreanum Z, complete genome blastn 28 52.8 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanocorpusculaceae Methanocorpusculum Methanocorpusculum labreanum
21688257 21688257 PRJEB10140_P_NODE_140938_length_261_cov_3.363208_g123631_i0 PRJEB10140 140938 261 3.363208 8.77797288 uncultured euryarchaeote 114243 Archaea Archaea 52.8 0.024   NTclustered gi|730903769|gb|KP211855.1| 114243 g123631 i0 100 0.10727969348659 28 0 11 0 229 256 7464 7491 Uncultured euryarchaeote clone MedDCM-JUL2012-C734 genomic sequence blastn 28 52.8 1 Archaea   Methanobacteriati Methanobacteriota         uncultured euryarchaeote
21689490 21689490 PRJEB10140_P_NODE_278358_length_164_cov_0.895652_g261049_i0 PRJEB10140 278358 164 0.895652 1.46886928 Methanobrevibacter olleyae 294671 Archaea Archaea 241 2.72e-59   NTclustered gi|998157363|gb|CP014265.1| 294671 g261049 i0 93.293 1.8780487804878 164 10 100 1 1 164 91798 91636 Methanobrevibacter olleyae strain YLM1 chromosome, complete genome blastn 308 241 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter olleyae
22964468 22964468 PRJEB10140_P_NODE_262099_length_166_cov_0.888889_g244790_i0 PRJEB10140 262099 166 0.888889 1.47555574 Methanobrevibacter olleyae 294671 Archaea Archaea 268 1.27e-67   NTclustered gi|998157363|gb|CP014265.1| 294671 g244790 i0 96.341 50.3614457831325 164 4 98 2 4 166 1756883 1756721 Methanobrevibacter olleyae strain YLM1 chromosome, complete genome blastn 8360 268 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter olleyae
24237967 24237967 PRJEB10140_P_NODE_199560_length_195_cov_2.917808_g182251_i0 PRJEB10140 199560 195 2.917808 5.6897256 Methanobrevibacter olleyae 294671 Archaea Archaea 52.8 0.017   NTclustered gi|998157363|gb|CP014265.1| 294671 g182251 i0 100 0.143589743589744 28 0 14 0 168 195 1011816 1011789 Methanobrevibacter olleyae strain YLM1 chromosome, complete genome blastn 28 52.8 1 Archaea Methanomada group Methanobacteriati Methanobacteriota Methanobacteria Methanobacteriales Methanobacteriaceae Methanobrevibacter Methanobrevibacter olleyae

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