RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA356682" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_kingdom 1

  • Thermotogati · 10 ✖

bioproject 1

  • PRJNA356682 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
397798 397798 PRJNA356682_P_NODE_36781_length_250_cov_0.870056_g36090_i0 PRJNA356682 36781 250 0.870056 2.17514 Deinococcus aquaticus 328692 Bacteria Bacteria 368 1.98e-97   NTclustered gi|2444120906|gb|CP115165.1| 328692 g36090 i0 93.2 1 250 17 100 0 1 250 1987018 1987267 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 250 368 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
2948590 2948590 PRJNA356682_P_NODE_47443_length_206_cov_7.872180_g46752_i0 PRJNA356682 47443 206 7.87218 16.2166908 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 370 4.38e-98   NTclustered gi|821341785|gb|CP011389.1| 1309411 g46752 i0 99.029 11.3252427184466 206 2 100 0 1 206 2238422 2238627 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 2333 370 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
5501461 5501461 PRJNA356682_P_NODE_40925_length_245_cov_0.895349_g40234_i0 PRJNA356682 40925 245 0.895349 2.19360505 Deinococcus aquaticus 328692 Bacteria Bacteria 409 1.1399999999999998e-109   NTclustered gi|2444120906|gb|CP115165.1| 328692 g40234 i0 97.107 13.3387755102041 242 7 99 0 3 244 1300196 1299955 Deinococcus aquaticus strain PB-314 chromosome, complete genome blastn 3268 409 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aquaticus
5501517 5501517 PRJNA356682_P_NODE_43685_length_242_cov_0.911243_g42994_i0 PRJNA356682 43685 242 0.911243 2.20520806 Synergistota bacterium 2268202 Bacteria Bacteria 230 9.38e-56   NTclustered gi|2041259188|gb|CP074691.1| 2268202 g42994 i0 84.322 8.25206611570248 236 35 97 2 5 239 682654 682420 Synergistota bacterium strain L-13 chromosome, complete genome blastn 1997 230 1 Bacteria   Thermotogati Synergistota         Synergistota bacterium
8050980 8050980 PRJNA356682_P_NODE_34787_length_254_cov_1.872928_g34096_i0 PRJNA356682 34787 254 1.872928 4.75723712 Trueperaceae bacterium 2026798 Bacteria Bacteria 364 2.6099999999999993e-96   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g34096 i0 92.52 546.566929133858 254 19 100 0 1 254 3600873 3600620 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 138828 364 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
9325384 9325384 PRJNA356682_P_NODE_18628_length_332_cov_10.409266_g17937_i0 PRJNA356682 18628 332 10.409266 34.55876312 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 614 3.1799999999999995e-171   NTclustered gi|821341785|gb|CP011389.1| 1309411 g17937 i0 100 174.397590361446 332 0 100 0 1 332 1636078 1636409 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 57900 614 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
9325509 9325509 PRJNA356682_P_NODE_24148_length_297_cov_3.031250_g23457_i0 PRJNA356682 24148 297 3.03125 9.0028125 Deinococcus actinosclerus 1768108 Bacteria Bacteria 510 3.79e-140   NTclustered gi|972944657|gb|CP013910.1| 1768108 g23457 i0 97.659 262.969696969697 299 3 100 4 1 297 74700 74996 Deinococcus actinosclerus strain BM2 chromosome, complete genome blastn 78102 510 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus actinosclerus
10601147 10601147 PRJNA356682_P_NODE_20689_length_318_cov_1.546939_g19998_i0 PRJNA356682 20689 318 1.546939 4.91926602 Fretibacterium fastidiosum 651822 Bacteria Bacteria 303 7.45e-78   NTclustered gi|2869663113|emb|OZ209244.1| 651822 g19998 i0 85.473 107.962264150943 296 37 93 6 14 306 69044 69336 Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3 blastn 34332 303 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Aminobacteriaceae Fretibacterium Fretibacterium fastidiosum
13825466 13825466 PRJNA356682_P_NODE_12151_length_403_cov_1.942424_g11461_i0 PRJNA356682 12151 403 1.942424 7.82796872 Deinococcus 1298 Bacteria Bacteria 706 0   NTclustered gi|1751871007|dbj|AP021849.1| 57498 g11461 i0 98.267 57.7245657568238 404 6 100 1 1 403 1057639 1057236 Deinococcus grandis ATCC 43672 DNA, complete genome blastn 23263 706 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus grandis
20799247 20799247 PRJNA356682_P_NODE_37197_length_250_cov_0.870056_g36506_i0 PRJNA356682 37197 250 0.870056 2.17514 Deinococcus sp. AJ005 2652443 Bacteria Bacteria 189 1.6499999999999999e-43   NTclustered gi|1761809830|gb|CP044990.1| 2652443 g36506 i0 85.556 2.472 180 26 72 0 17 196 2474448 2474627 Deinococcus sp. AJ005 chromosome, complete genome blastn 618 189 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. AJ005

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