RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB12296" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 7 ✖

bioproject 1

  • PRJEB12296 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
25908945 25908945 PRJEB12296_S_NODE_3860_length_232_cov_12.350254_g3828_i0 PRJEB12296 3860 232 12.350254 28.65258928 Deinococcus gobiensis I- 502394 Bacteria Bacteria 359 1.09e-94   NTclustered gi|379998737|gb|CP002191.1| 745776 g3828 i0 98.522 183.241379310345 203 3 90 0 20 222 109793 109591 Deinococcus gobiensis I-0, complete genome blastn 42512 359 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
25909035 25909035 PRJEB12296_S_NODE_7644_length_185_cov_4.493333_g7612_i0 PRJEB12296 7644 185 4.493333 8.31266605 Deinococcus misasensis 392413 Bacteria Bacteria 313 6.56e-81   NTclustered gi|1407440130|gb|MH504176.1| 392413 g7612 i0 97.283 63.2810810810811 184 5 99 0 2 185 262 79 Deinococcus misasensis strain P49 16S ribosomal RNA gene, partial sequence blastn 11707 313 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus misasensis
26423135 26423135 PRJEB12296_S_NODE_1583_length_319_cov_5.535211_g1551_i0 PRJEB12296 1583 319 5.535211 17.65732309 root 1 Root_unresolved Root_unresolved 534 2.44e-147   NTclustered gi|2264081587|gb|CP094462.1| 1299 g1551 i0 96.865 138 319 10 100 0 1 319 1099997 1100315 Deinococcus radiodurans strain BRD125 chromosome 1, complete sequence blastn 44022 534 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus radiodurans
26423151 26423151 PRJEB12296_S_NODE_2167_length_289_cov_2.196850_g2135_i0 PRJEB12296 2167 289 2.19685 6.3488965 Deinococcus 1298 Bacteria Bacteria 483 7.999999999999997e-132   NTclustered gi|470486828|ref|NR_076782.1| 502394 g2135 i0 96.886 262.567474048443 289 8 100 1 1 289 1778 1491 Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence blastn 75882 483 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus gobiensis
26423159 26423159 PRJEB12296_S_NODE_2679_length_267_cov_14.517241_g2647_i0 PRJEB12296 2679 267 14.517241 38.76103347 Truepera 332248 Bacteria Bacteria 313 1.02e-80   NTclustered gi|2573973991|gb|CP133611.1| 332249 g2647 i0 91.266 561.49063670412 229 20 86 0 29 257 762247 762019 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 149918 313 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
26453346 26453346 PRJEB12296_S_NODE_992_length_366_cov_8.622356_g960_i0 PRJEB12296 992 366 8.622356 31.55782296 Deinococcus soli (ex Cha et al. 2 1309411 Bacteria Bacteria 579 1.2899999999999997e-160   NTclustered gi|821341785|gb|CP011389.1| 1309411 g960 i0 97.353 181.122950819672 340 9 93 0 27 366 1886418 1886079 'Deinococcus soli' Cha et al. 2014 strain N5, complete genome blastn 66291 579 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus soli (ex Cha et al. 2016)
26559240 26559240 PRJEB12296_S_NODE_5976_length_199_cov_4.731707_g5944_i0 PRJEB12296 5976 199 4.731707 9.41609693 Bacteria 2 Bacteria Bacteria 340 3.2899999999999996e-89   NTclustered gi|2866351997|gb|PQ721879.1| 47478 g5944 i0 100 94.7587939698493 184 0 92 0 1 184 533 716 Deinococcus sp. strain L174 16S ribosomal RNA gene, partial sequence blastn 18857 340 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp.

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