RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJEB9859" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 6 ✖

bioproject 1

  • PRJEB9859 · 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
999064 999064 PRJEB9859_S_NODE_421_length_209_cov_35.701149_g416_i0 PRJEB9859 421 209 35.701149 74.61540141 Truepera 332248 Bacteria Bacteria 309 9.85e-80   NTclustered gi|2573973991|gb|CP133611.1| 332249 g416 i0 93.301 679.325358851675 209 14 100 0 1 209 762039 762247 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 141979 309 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
17576883 17576883 PRJEB9859_P_NODE_5874_length_239_cov_81.619048_g5839_i0 PRJEB9859 5874 239 81.619048 195.06952472 Truepera 332248 Bacteria Bacteria 159 1.23e-34   NTclustered gi|470486385|ref|NR_076754.1| 332249 g5839 i0 96.842 177.330543933054 95 3 40 0 54 148 853 759 Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence blastn 42382 159 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
17576885 17576885 PRJEB9859_P_NODE_6434_length_223_cov_136.046392_g6399_i0 PRJEB9859 6434 223 136.046392 303.38345416 Deinococcus 1298 Bacteria Bacteria 141 4.11e-29   NTclustered gi|1435316362|gb|CP031158.1| 980427 g6399 i0 96.471 88.8295964125561 85 3 38 0 139 223 1793572 1793656 Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome blastn 19809 141 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus wulumuqiensis
21401105 21401105 PRJEB9859_P_NODE_2117_length_314_cov_1484.361404_g2082_i0 PRJEB9859 2117 314 1484.361404 4660.89480856 Truepera 332248 Bacteria Bacteria 320 7.29e-83   NTclustered gi|2573973991|gb|CP133611.1| 332249 g2082 i0 93.488 466.710191082803 215 14 68 0 19 233 762034 762248 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 146547 320 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
22675891 22675891 PRJEB9859_P_NODE_2158_length_312_cov_1477.300353_g2123_i0 PRJEB9859 2158 312 1477.300353 4609.17710136 Truepera 332248 Bacteria Bacteria 326 1.56e-84   NTclustered gi|2573973991|gb|CP133611.1| 332249 g2123 i0 92.174 487.759615384615 230 18 74 0 82 311 762248 762019 Truepera radiovictrix strain CIP 108686 chromosome, complete genome blastn 152181 326 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae Truepera Truepera radiovictrix
30729438 30729438 PRJEB9859_P_NODE_5074_length_245_cov_1.027778_g5039_i0 PRJEB9859 5074 245 1.027778 2.5180561 Deinococcus deserti 310783 Bacteria Bacteria 71.6 1.25e-12   NR WP_162485424.1 310783 g5039 i0 60.7 2.87755102040816 56 22 68.6 0 22 189 121 176 WP_162485424.1 GGDEF domain-containing protein [Deinococcus deserti] diamond 705 71.6 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus deserti

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