RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1237347" and tax_phylum = "Thermotogota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Thermotogota · 17 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1237347 · 17 ✖

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
9271012 9271012 PRJNA1237347_P_NODE_421248_length_271_cov_1.166667_g414675_i0 PRJNA1237347 421248 271 1.166667 3.16166757 Kosmotoga olearia 651457 Bacteria Bacteria 52.8 0.025   NTclustered gi|239505242|gb|CP001634.1| 521045 g414675 i0 100 0.103321033210332 28 0 10 0 220 247 982054 982081 Kosmotoga olearia TBF 19.5.1, complete genome blastn 28 52.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae Kosmotoga Kosmotoga olearia
16914199 16914199 PRJNA1237347_P_NODE_136514_length_556_cov_17.778468_g129980_i0 PRJNA1237347 136514 556 17.778468 98.84828208 Thermotogaceae bacterium 2268206 Bacteria Bacteria 119 3.88e-31   NR MCD6449333.1 2268206 g129980 i0 46.7 4.00359712230216 120 60 63.1 3 76 426 2 120 MCD6449333.1 glycine cleavage system protein GcvH [Thermotogaceae bacterium] diamond 2226 119 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
26724634 26724634 PRJNA1237347_P_NODE_464801_length_253_cov_2.211111_g458228_i0 PRJNA1237347 464801 253 2.211111 5.59411083 Thermotogota bacterium 2053689 Bacteria Bacteria 72 3.19e-13   NR HOO31715.1 2053689 g458228 i0 38.1 1.99209486166008 84 52 99.6 0 1 252 19 102 HOO31715.1 uridine kinase [Thermotogota bacterium] diamond 504 72 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
26978299 26978299 PRJNA1237347_P_NODE_467042_length_252_cov_3.357542_g460469_i0 PRJNA1237347 467042 252 3.357542 8.46100584 Thermotogota bacterium 2053689 Bacteria Bacteria 64.7 7.37e-10   NR HPE41481.1 2053689 g460469 i0 42.7 3.55952380952381 75 42 89.3 1 226 2 325 398 HPE41481.1 right-handed parallel beta-helix repeat-containing protein [Thermotogota bacterium] diamond 897 64.7 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
27167769 27167769 PRJNA1237347_P_NODE_389882_length_284_cov_1.293839_g383309_i0 PRJNA1237347 389882 284 1.293839 3.67450276 Thermotogota bacterium 2053689 Bacteria Bacteria 53.5 3.42e-6   NR MEN6368650.1 2053689 g383309 i0 32.2 0.919014084507042 87 55 87.7 1 283 35 86 172 MEN6368650.1 hypothetical protein [Thermotogota bacterium] diamond 261 53.5 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
27533866 27533866 PRJNA1237347_P_NODE_117723_length_613_cov_14.768519_g111223_i0 PRJNA1237347 117723 613 14.768519 90.53102147 Bacteria 2 Bacteria Bacteria 138 1.21e-37   NR WP_109605797.1 1255275 g111223 i0 45.3 4.25774877650897 172 87 83.7 3 70 582 1 166 WP_109605797.1 MULTISPECIES: hypoxanthine phosphoribosyltransferase [Oceanotoga] diamond 2610 138 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Oceanotoga  
27642316 27642316 PRJNA1237347_P_NODE_93064_length_713_cov_6.812500_g86764_i0 PRJNA1237347 93064 713 6.8125 48.573125 Thermotogota bacterium 2053689 Bacteria Bacteria 175 2.33e-51   NR RKX46488.1 2053689 g86764 i0 55.2 2.44039270687237 174 75 73.2 2 78 599 11 181 RKX46488.1 MAG: macro domain-containing protein [Thermotogota bacterium] diamond 1740 175 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
27737044 27737044 PRJNA1237347_P_NODE_545264_length_242_cov_0.911243_g538691_i0 PRJNA1237347 545264 242 0.911243 2.20520806 Kosmotogales bacterium 3030606 Bacteria Bacteria 44.3 0.00943   NR MDK2951932.1 3030606 g538691 i0 31.7 0.743801652892562 60 41 74.4 0 54 233 177 236 MDK2951932.1 hypothetical protein [Kosmotogales bacterium] diamond 180 44.3 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales     Kosmotogales bacterium
27830994 27830994 PRJNA1237347_P_NODE_223104_length_403_cov_2.245455_g216532_i0 PRJNA1237347 223104 403 2.245455 9.04918365 Thermosipho sp. (in: thermotogales) 1968895 Bacteria Bacteria 52.4 4.49e-5   NR MDK2886256.1 1968895 g216532 i0 32.8 0.952853598014888 128 66 93.1 6 14 388 78 188 MDK2886256.1 hypothetical protein [Thermosipho sp. (in: thermotogales)] diamond 384 52.4 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)
28575886 28575886 PRJNA1237347_P_NODE_529947_length_244_cov_0.900585_g523374_i0 PRJNA1237347 529947 244 0.900585 2.1974274 Thermotogaceae 188709 Bacteria Bacteria 135 1.61e-36   NR WP_041083526.1 1508420 g523374 i0 81.3 2.93852459016393 80 15 98.4 0 5 244 260 339 WP_041083526.1 L-Ala-D/L-Glu epimerase [Thermotoga profunda] diamond 717 136 0.992647058823529 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga profunda
28620451 28620451 PRJNA1237347_P_NODE_13267_length_2182_cov_5.058321_g11465_i0 PRJNA1237347 13267 2182 5.058321 110.37256422 Tepiditoga spiralis 2108365 Bacteria Bacteria 247 1.79e-69   NR WP_190614528.1 2108365 g11465 i0 34.1 1.35288725939505 516 316 69.2 9 1523 15 15 519 WP_190614528.1 hypothetical protein [Tepiditoga spiralis] diamond 2952 247 1 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Tepiditoga Tepiditoga spiralis
28715322 28715322 PRJNA1237347_P_NODE_315287_length_324_cov_1.067729_g308714_i0 PRJNA1237347 315287 324 1.067729 3.45944196 Thermotogaceae bacterium 2268206 Bacteria Bacteria 45.1 0.0065   NR MDI3471901.1 2268206 g308714 i0 39.3 0.518518518518518 56 33 51.9 1 145 312 4 58 MDI3471901.1 uncharacterized protein [Thermotogaceae bacterium] diamond 168 45.1 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
29630581 29630581 PRJNA1237347_P_NODE_331390_length_314_cov_1.219917_g324817_i0 PRJNA1237347 331390 314 1.219917 3.83053938 Thermotogaceae bacterium 2268206 Bacteria Bacteria 45.4 0.00945   NR MDN5359247.1 2268206 g324817 i0 30.7 0.964968152866242 101 67 96.5 2 313 11 131 228 MDN5359247.1 Ca-activated chloride channel [Thermotogaceae bacterium] diamond 303 45.4 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
29807098 29807098 PRJNA1237347_P_NODE_128351_length_579_cov_14.723320_g121825_i0 PRJNA1237347 128351 579 14.72332 85.2480228 Petrotogaceae 1643949 Bacteria Bacteria 135 9.56e-37   NR WP_109605797.1 1255275 g121825 i0 44.7 5.33678756476684 170 87 87.6 3 70 576 1 164 WP_109605797.1 MULTISPECIES: hypoxanthine phosphoribosyltransferase [Oceanotoga] diamond 3090 136 0.992647058823529 Bacteria   Thermotogati Thermotogota Thermotogae Petrotogales Petrotogaceae Oceanotoga  
30673596 30673596 PRJNA1237347_P_NODE_81193_length_779_cov_2.266289_g75083_i0 PRJNA1237347 81193 779 2.266289 17.65439131 Thermosipho africanus 2421 Bacteria Bacteria 106 5.45e-22   NR WP_004102192.1 2421 g75083 i0 44.3 0.504492939666239 131 67 48.9 3 398 18 777 905 WP_004102192.1 fibronectin type III domain-containing protein [Thermosipho africanus] diamond 393 106 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho africanus
31242353 31242353 PRJNA1237347_P_NODE_73455_length_830_cov_3.747688_g67549_i0 PRJNA1237347 73455 830 3.747688 31.1058104 Thermotogota bacterium 2053689 Bacteria Bacteria 58.5 1.07e-5   NR MCD6462075.1 2053689 g67549 i0 40.3 0.278313253012048 77 44 27.8 1 242 12 14 88 MCD6462075.1 tetratricopeptide repeat protein [Thermotogota bacterium] diamond 231 58.5 1 Bacteria   Thermotogati Thermotogota         Thermotogota bacterium
31653362 31653362 PRJNA1237347_P_NODE_504057_length_247_cov_0.885057_g497484_i0 PRJNA1237347 504057 247 0.885057 2.18609079 Thermosipho sp. (in: thermotogales) 1968895 Bacteria Bacteria 119 2.98e-29   NR MBO8161144.1 1968895 g497484 i0 67.1 0.995951417004049 82 27 99.6 0 247 2 205 286 MBO8161144.1 phage portal protein [Thermosipho sp. (in: thermotogales)] diamond 246 119 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Fervidobacteriaceae Thermosipho Thermosipho sp. (in: thermotogales)

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