RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA380416" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA380416 · 18 ✖

analysis 1

  • blastn · 18 ✖

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
1074175 1074175 PRJNA380416_P_NODE_8621_length_194_cov_1.958621_g8474_i0 PRJNA380416 8621 194 1.958621 3.79972474 Thermotoga 2335 Bacteria Bacteria 359 8.809999999999999e-95   NTclustered gi|806984312|ref|NG_042010.1| 93929 g8474 i0 100 117.355670103093 194 0 100 0 1 194 1343 1536 Thermotoga petrophila strain RKU-1 23S ribosomal RNA gene, complete sequence blastn 22767 359 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
1074179 1074179 PRJNA380416_P_NODE_9681_length_183_cov_1.522388_g9534_i0 PRJNA380416 9681 183 1.522388 2.78597004 Thermotoga 2335 Bacteria Bacteria 339 1.07e-88   NTclustered gi|147734689|gb|CP000702.1| 390874 g9534 i0 100 13.016393442623 183 0 100 0 1 183 294269 294087 Thermotoga petrophila RKU-1, complete genome blastn 2382 339 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
4902079 4902079 PRJNA380416_P_NODE_7444_length_210_cov_1.267081_g7297_i0 PRJNA380416 7444 210 1.267081 2.6608701 Thermotoga 2335 Bacteria Bacteria 388 1.24e-103   NTclustered gi|170175310|gb|CP000969.1| 126740 g7297 i0 100 12 210 0 100 0 1 210 1839233 1839442 Thermotoga sp. RQ2, complete genome blastn 2520 388 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. RQ2
6779739 6779739 PRJNA380416_P_NODE_11386_length_167_cov_0.864407_g11239_i0 PRJNA380416 11386 167 0.864407 1.44355969 Thermotoga petrophila 93929 Bacteria Bacteria 309 7.53e-80   NTclustered gi|61657378|emb|AJ872269.1| 390874 g11239 i0 100 13.9520958083832 167 0 100 0 1 167 27774 27940 Thermotoga petrophila 16S rRNA gene, 23S rRNA gene, 5S rRNA gene, ORF1 (partial), ORF2, ORF3, ruvA gene, folC gene, deoB gene, leuS gene, ORF9, ORF10, ORF11, ahcY gene, topG gene, hppa gene, acp gene, ORF16, ORF17, priA gene, ORF18, ORF19, ORF20, ORF21, ORF22, mrsA gene, ORF24, rrp2 gene, fsr gene, ORF27, ORF28, ORF29, ORF31, ORF32 (partial), tRNA-Ile gene, tRNA-Ala gene, tRNA-Ala gene, tRNA-Arg gene, tRNA-His gene, tRNA-Arg gene, tRNA-Gly gene, group I intron, IGS, ITS1 and ITS2, strain RKU-1 blastn 2330 309 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
7452060 7452060 PRJNA380416_P_NODE_13686_length_161_cov_1.812500_g13539_i0 PRJNA380416 13686 161 1.8125 2.918125 Thermotoga 2335 Bacteria Bacteria 298 1.56e-76   NTclustered gi|147734689|gb|CP000702.1| 390874 g13539 i0 100 11 161 0 100 0 1 161 532173 532013 Thermotoga petrophila RKU-1, complete genome blastn 1771 298 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
8055243 8055243 PRJNA380416_P_NODE_10447_length_175_cov_1.206349_g10300_i0 PRJNA380416 10447 175 1.206349 2.11111075 Thermotoga petrophila 93929 Bacteria Bacteria 324 2.83e-84   NTclustered gi|147734689|gb|CP000702.1| 390874 g10300 i0 100 13 175 0 100 0 1 175 379953 380127 Thermotoga petrophila RKU-1, complete genome blastn 2275 324 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
8055244 8055244 PRJNA380416_P_NODE_10767_length_171_cov_2.491803_g10620_i0 PRJNA380416 10767 171 2.491803 4.26098313 Thermotoga petrophila 93929 Bacteria Bacteria 316 4.6e-82   NTclustered gi|147734689|gb|CP000702.1| 390874 g10620 i0 100 11 171 0 100 0 1 171 1537723 1537553 Thermotoga petrophila RKU-1, complete genome blastn 1881 316 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
10002244 10002244 PRJNA380416_P_NODE_13928_length_161_cov_0.910714_g13781_i0 PRJNA380416 13928 161 0.910714 1.46624954 Thermotoga 2335 Bacteria Bacteria 298 1.56e-76   NTclustered gi|811641277|gb|CP011108.1| 2336 g13781 i0 100 10.9813664596273 161 0 100 0 1 161 556589 556749 Thermotoga maritima strain Tma100, complete genome blastn 1768 298 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga maritima
11277327 11277327 PRJNA380416_P_NODE_3169_length_338_cov_1.401384_g3022_i0 PRJNA380416 3169 338 1.401384 4.73667792 Thermotoga 2335 Bacteria Bacteria 608 1.509999999999999e-169   NTclustered gi|559112577|tpe|HG525342.1| 126740 g3022 i0 99.112 18.0325443786982 338 3 100 0 1 338 8 345 TPA: Thermotoga sp. RQ2 tmRNA gene Therm_sp_RQ2 blastn 6095 614 0.990228013029316 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. RQ2
12552666 12552666 PRJNA380416_P_NODE_4210_length_289_cov_1.062500_g4063_i0 PRJNA380416 4210 289 1.0625 3.070625 Thermotoga 2335 Bacteria Bacteria 534 2.18e-147   NTclustered gi|806984312|ref|NG_042010.1| 93929 g4063 i0 100 165.429065743945 289 0 100 0 1 289 833 1121 Thermotoga petrophila strain RKU-1 23S ribosomal RNA gene, complete sequence blastn 47809 534 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
12552668 12552668 PRJNA380416_P_NODE_5030_length_259_cov_3.347619_g4883_i0 PRJNA380416 5030 259 3.347619 8.67033321 Thermotoga 2335 Bacteria Bacteria 473 4.25e-129   NTclustered gi|811641277|gb|CP011108.1| 2336 g4883 i0 99.614 17.5019305019305 259 1 100 0 1 259 1124835 1124577 Thermotoga maritima strain Tma100, complete genome blastn 4533 473 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga maritima
16376589 16376589 PRJNA380416_P_NODE_11293_length_167_cov_0.864407_g11146_i0 PRJNA380416 11293 167 0.864407 1.44355969 Thermotoga 2335 Bacteria Bacteria 309 7.53e-80   NTclustered gi|170175310|gb|CP000969.1| 126740 g11146 i0 100 10.8023952095808 167 0 100 0 1 167 1390842 1391008 Thermotoga sp. RQ2, complete genome blastn 1804 309 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. RQ2
18253674 18253674 PRJNA380416_P_NODE_5515_length_247_cov_1.474747_g5368_i0 PRJNA380416 5515 247 1.474747 3.64262509 Thermotoga petrophila 93929 Bacteria Bacteria 457 4.05e-124   NTclustered gi|147734689|gb|CP000702.1| 390874 g5368 i0 100 12.9838056680162 247 0 100 0 1 247 1536500 1536746 Thermotoga petrophila RKU-1, complete genome blastn 3207 457 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
18925584 18925584 PRJNA380416_P_NODE_11795_length_166_cov_0.871795_g11648_i0 PRJNA380416 11795 166 0.871795 1.4471797 Thermotoga 2335 Bacteria Bacteria 302 1.2500000000000001e-77   NTclustered gi|147734689|gb|CP000702.1| 390874 g11648 i0 99.398 10.789156626506 166 1 100 0 1 166 381334 381499 Thermotoga petrophila RKU-1, complete genome blastn 1791 302 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
20200228 20200228 PRJNA380416_P_NODE_13096_length_163_cov_0.894737_g12949_i0 PRJNA380416 13096 163 0.894737 1.45842131 Thermotoga 2335 Bacteria Bacteria 296 5.68e-76   NTclustered gi|170175310|gb|CP000969.1| 126740 g12949 i0 99.387 11 163 1 100 0 1 163 420168 420330 Thermotoga sp. RQ2, complete genome blastn 1793 296 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga sp. RQ2
22750930 22750930 PRJNA380416_P_NODE_11298_length_167_cov_0.864407_g11151_i0 PRJNA380416 11298 167 0.864407 1.44355969 Thermotoga 2335 Bacteria Bacteria 309 7.53e-80   NTclustered gi|221571364|gb|CP000916.1| 309803 g11151 i0 100 4 167 0 100 0 1 167 1246620 1246786 Thermotoga neapolitana DSM 4359, complete genome blastn 668 309 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga neapolitana
24025886 24025886 PRJNA380416_P_NODE_4939_length_262_cov_1.915493_g4792_i0 PRJNA380416 4939 262 1.915493 5.01859166 Thermotoga 2335 Bacteria Bacteria 484 1.99e-132   NTclustered gi|147734689|gb|CP000702.1| 390874 g4792 i0 100 12.030534351145 262 0 100 0 1 262 431697 431436 Thermotoga petrophila RKU-1, complete genome blastn 3152 484 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga petrophila
25300332 25300332 PRJNA380416_P_NODE_13440_length_162_cov_0.902655_g13293_i0 PRJNA380416 13440 162 0.902655 1.4623011 Thermotoga 2335 Bacteria Bacteria 298 1.57e-76   NTclustered gi|811641277|gb|CP011108.1| 2336 g13293 i0 100 10.9320987654321 161 0 99 0 2 162 818896 818736 Thermotoga maritima strain Tma100, complete genome blastn 1771 298 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga maritima

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