RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA1123436", tax_kingdom = "Thermotogati" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 17 ✖

tax_kingdom 1

  • Thermotogati · 17 ✖

bioproject 1

  • PRJNA1123436 · 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
5382930 5382930 PRJNA1123436_P_NODE_45265_length_373_cov_1.390000_g44051_i0 PRJNA1123436 45265 373 1.39 5.1847 Fretibacterium fastidiosum 651822 Bacteria Bacteria 435 3.02e-117   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g44051 i0 87.733 80.1072386058981 375 43 100 3 1 373 69408 69781 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 29880 435 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
13032627 13032627 PRJNA1123436_P_NODE_113771_length_245_cov_0.895349_g112557_i0 PRJNA1123436 113771 245 0.895349 2.19360505 Cloacibacillus evryensis 508460 Bacteria Bacteria 442 1.1199999999999994e-119   NTclustered gi|2831313556|gb|CP171104.1| 508460 g112557 i0 99.184 5.08571428571429 245 2 100 0 1 245 191990 191746 Cloacibacillus evryensis strain WGS1925 chromosome, complete genome blastn 1246 442 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Cloacibacillus Cloacibacillus evryensis
13034325 13034325 PRJNA1123436_P_NODE_88011_length_263_cov_1.242105_g86797_i0 PRJNA1123436 88011 263 1.242105 3.26673615 Fretibacterium fastidiosum 651822 Bacteria Bacteria 459 1.21e-124   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g86797 i0 98.099 74.0836501901141 263 5 100 0 1 263 1174822 1174560 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 19484 459 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
14307614 14307614 PRJNA1123436_P_NODE_101152_length_249_cov_0.875000_g99938_i0 PRJNA1123436 101152 249 0.875 2.17875 Bacteria 2 Bacteria Bacteria 124 1.1000000000000001e-30   NR WP_050724178.1 274 g99938 i0 74.7 5.34939759036145 79 19 95.2 1 5 241 335 412 WP_050724178.1 Eco57I restriction-modification methylase domain-containing protein [Thermus thermophilus] diamond 1332 125 0.992 Bacteria   Thermotogati Deinococcota Deinococci Thermales Thermaceae Thermus Thermus thermophilus
15583652 15583652 PRJNA1123436_P_NODE_95233_length_251_cov_0.865169_g94019_i0 PRJNA1123436 95233 251 0.865169 2.17157419 Bacteria 2 Bacteria Bacteria 94.4 2.86e-20   NR OPZ38854.1 1852916 g94019 i0 62.5 1.61354581673307 64 24 76.5 0 193 2 31 94 OPZ38854.1 MAG: hypothetical protein BWY99_01527 [Synergistetes bacterium ADurb.BinA166] diamond 405 94.4 1 Bacteria   Thermotogati Synergistota         Synergistetes bacterium ADurb.BinA166
18880989 18880989 PRJNA1123436_P_NODE_29015_length_478_cov_6.348148_g27806_i0 PRJNA1123436 29015 478 6.348148 30.34414744 Deinococcus 1298 Bacteria Bacteria 793 0   NTclustered gi|1488149667|gb|MK036535.1| 47478 g27806 i0 97.408 96.663179916318 463 6 97 2 14 476 721 265 Deinococcus sp. strain 16081601 16S ribosomal RNA gene, partial sequence blastn 46205 798 0.993734335839599 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.
18881464 18881464 PRJNA1123436_P_NODE_81075_length_276_cov_1.364532_g79861_i0 PRJNA1123436 81075 276 1.364532 3.76610832 Deinococcus 1298 Bacteria Bacteria 425 1.3e-114   NTclustered gi|470486828|ref|NR_076782.1| 502394 g79861 i0 95.506 200.822463768116 267 11 96 1 1 266 626 892 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 55427 425 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
21955971 21955971 PRJNA1123436_P_NODE_126118_length_241_cov_0.916667_g124904_i0 PRJNA1123436 126118 241 0.916667 2.20916747 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 82.4 2.77e-11   NTclustered gi|821341785|gb|CP011389.1| 1309411 g124904 i0 94.34 2.11203319502075 53 3 22 0 1 53 2249190 2249242 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 509 82.4 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
28301925 28301925 PRJNA1123436_P_NODE_64446_length_311_cov_0.945378_g63232_i0 PRJNA1123436 64446 311 0.945378 2.94012558 uncultured Deinococcus sp. 158789 Bacteria Bacteria 66.2 1.29e-11   NR WP_295819215.1 158789 g63232 i0 46.8 0.742765273311897 77 30 74.3 2 310 80 33 98 WP_295819215.1 hypothetical protein [uncultured Deinococcus sp.] diamond 231 66.2 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus uncultured Deinococcus sp.
28838627 28838627 PRJNA1123436_P_NODE_116548_length_244_cov_0.900585_g115334_i0 PRJNA1123436 116548 244 0.900585 2.1974274 Kosmotogaceae bacterium 2053567 Bacteria Bacteria 98.6 2.4299999999999998e-23   NR MFO7881326.1 2053567 g115334 i0 51.9 0.995901639344262 81 39 99.6 0 1 243 29 109 MFO7881326.1 site-specific DNA-methyltransferase [Kosmotogaceae bacterium] diamond 243 98.6 1 Bacteria   Thermotogati Thermotogota Thermotogae Kosmotogales Kosmotogaceae   Kosmotogaceae bacterium
29280568 29280568 PRJNA1123436_P_NODE_101489_length_249_cov_0.875000_g100275_i0 PRJNA1123436 101489 249 0.875 2.17875 Thermotogaceae bacterium 2268206 Bacteria Bacteria 66.2 9.32e-12   NR NLI08125.1 2268206 g100275 i0 55.4 0.674698795180723 56 25 67.5 0 249 82 57 112 NLI08125.1 hypothetical protein [Thermotogaceae bacterium] diamond 168 66.2 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae   Thermotogaceae bacterium
29596159 29596159 PRJNA1123436_P_NODE_95690_length_251_cov_0.865169_g94476_i0 PRJNA1123436 95690 251 0.865169 2.17157419 Synergistaceae bacterium 2053624 Bacteria Bacteria 52.8 9.12e-6   NR MFA7219429.1 2053624 g94476 i0 44.3 0.944223107569721 79 41 94.4 2 237 1 162 237 MFA7219429.1 hypothetical protein [Synergistaceae bacterium] diamond 237 52.8 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae   Synergistaceae bacterium
30101706 30101706 PRJNA1123436_P_NODE_95032_length_251_cov_0.865169_g93818_i0 PRJNA1123436 95032 251 0.865169 2.17157419 Synergistales bacterium 2268201 Bacteria Bacteria 76.3 5.01e-14   NR MBC7076858.1 2268201 g93818 i0 48.2 0.99203187250996006 83 41 99.2 2 2 250 153 233 MBC7076858.1 hypothetical protein [Synergistales bacterium] diamond 249 76.3 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales     Synergistales bacterium
30249218 30249218 PRJNA1123436_P_NODE_60752_length_320_cov_2.190283_g59538_i0 PRJNA1123436 60752 320 2.190283 7.0089056 Thermotogaceae 188709 Bacteria Bacteria 82.8 2.47e-17   NR WP_038066519.1 2337 g59538 i0 72.9 1.359375 48 13 45 0 315 172 25 72 WP_038066519.1 nitroreductase family protein [Thermotoga neapolitana] diamond 435 82.8 1 Bacteria   Thermotogati Thermotogota Thermotogae Thermotogales Thermotogaceae Thermotoga Thermotoga neapolitana
30607270 30607270 PRJNA1123436_P_NODE_93873_length_252_cov_1.513966_g92659_i0 PRJNA1123436 93873 252 1.513966 3.81519432 Thermovirga lienii DSM 17291 580340 Bacteria Bacteria 137 8.37e-36   NR AER66200.1 580340 g92659 i0 81.9 1.98809523809524 83 15 98.8 0 4 252 160 242 AER66200.1 AAA ATPase [Thermovirga lienii DSM 17291] diamond 501 137 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Thermovirgaceae Thermovirga Thermovirga lienii
31935038 31935038 PRJNA1123436_P_NODE_127537_length_241_cov_0.916667_g126323_i0 PRJNA1123436 127537 241 0.916667 2.20916747 Trueperaceae bacterium 2026798 Bacteria Bacteria 42.7 0.0374   NR HET9026311.1 2026798 g126323 i0 37 0.908713692946058 73 37 84.6 4 240 37 429 497 HET9026311.1 type I DNA topoisomerase [Trueperaceae bacterium] diamond 219 42.7 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
32156816 32156816 PRJNA1123436_P_NODE_116678_length_244_cov_0.900585_g115464_i0 PRJNA1123436 116678 244 0.900585 2.1974274 Deinococcus misasensis 392413 Bacteria Bacteria 54.7 9.3e-7   NR WP_034340670.1 392413 g115464 i0 44.6 1.02049180327869 83 34 94.7 4 3 233 109 185 WP_034340670.1 hypothetical protein [Deinococcus misasensis] diamond 249 54.7 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis

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