RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJEB49404" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJEB49404 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3930980 3930980 PRJEB49404_P_NODE_38024_length_1137_cov_38.620219_g8099_i3 PRJEB49404 38024 1137 38.620219 439.11189003 Deinococcus gobiensis 502394 Bacteria Bacteria 1951 0   NTclustered gi|379998737|gb|CP002191.1| 745776 g8099 i3 97.709 211.733509234828 1135 25 99 1 1 1134 803177 804311 Deinococcus gobiensis I-0, complete genome blastn 240741 1951 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
9039520 9039520 PRJEB49404_P_NODE_533868_length_173_cov_1.925373_g520067_i0 PRJEB49404 533868 173 1.925373 3.33089529 Deinococcus sp. KNUC1210 2917691 Bacteria Bacteria 178 2.3e-40   NTclustered gi|2197029603|gb|CP092190.1| 2917691 g520067 i0 85.882 81.8612716763006 170 21 98 2 5 173 1426786 1426953 Deinococcus sp. KNUC1210 chromosome, complete genome blastn 14162 178 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. KNUC1210
11583487 11583487 PRJEB49404_P_NODE_386770_length_219_cov_1.911111_g372969_i0 PRJEB49404 386770 219 1.911111 4.18533309 Deinococcus altitudinis 468914 Bacteria Bacteria 158 3.99e-34   NTclustered gi|2865407847|gb|CP129416.1| 468914 g372969 i0 81.313 8.30593607305936 198 33 89 3 24 219 548012 547817 Deinococcus altitudinis strain LMG 24022 plasmid unnamed1, complete sequence blastn 1819 158 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus altitudinis
14132544 14132544 PRJEB49404_P_NODE_365432_length_228_cov_2.798942_g351631_i0 PRJEB49404 365432 228 2.798942 6.38158776 Trueperaceae bacterium 2026798 Bacteria Bacteria 303 5.08e-78   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g351631 i0 94 328.109649122807 200 12 88 0 29 228 3600902 3601101 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 74809 303 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
15019026 15019026 PRJEB49404_P_NODE_647512_length_151_cov_1.053571_g633711_i0 PRJEB49404 647512 151 1.053571 1.59089221 Deinococcus 1298 Bacteria Bacteria 279 5.19e-71   NTclustered gi|470478007|ref|NR_076423.1| 68909 g633711 i0 100 12.046357615894 151 0 100 0 1 151 1446 1596 Deinococcus geothermalis plasmid pDGEO01 strain AG-3a 23S ribosomal RNA gene, complete sequence blastn 1819 279 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus geothermalis
24344273 24344273 PRJEB49404_P_NODE_76300_length_696_cov_19.575342_g63537_i0 PRJEB49404 76300 696 19.575342 136.24438032 Deinococcus soli (ex Cha et al. 2016) 1309411 Bacteria Bacteria 874 0   NTclustered gi|821341785|gb|CP011389.1| 1309411 g63537 i0 89.407 217.229885057471 708 56 100 15 1 696 1637859 1637159 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 151192 874 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)

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