RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1247234" and tax_phylum = "Deinococcota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Deinococcota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1247234 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
11829859 11829859 PRJNA1247234_P_NODE_10610_length_334_cov_1.195402_g10454_i0 PRJNA1247234 10610 334 1.195402 3.99264268 Deinococcus aetherius 200252 Bacteria Bacteria 363 1.2799999999999999e-95   NTclustered gi|2281894955|dbj|AP026560.1| 200252 g10454 i0 89.42 170.035928143713 293 24 87 7 44 334 822963 822676 Deinococcus aetherius ST0316 DNA, complete genome blastn 56792 363 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus aetherius
11830161 11830161 PRJNA1247234_P_NODE_26830_length_243_cov_0.917647_g26674_i0 PRJNA1247234 26830 243 0.917647 2.22988221 Deinococcus sonorensis 309891 Bacteria Bacteria 222 1.58e-53   NTclustered gi|2745307249|gb|CP158299.1| 694439 g26674 i0 85.514 9.79423868312757 214 29 88 2 7 219 2804603 2804391 Deinococcus sonorensis KR-87 chromosome, complete genome blastn 2380 222 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
19477619 19477619 PRJNA1247234_P_NODE_26936_length_243_cov_0.917647_g26780_i0 PRJNA1247234 26936 243 0.917647 2.22988221 Trueperaceae bacterium 2026798 Bacteria Bacteria 191 4.45e-44   NTclustered gi|2621701816|emb|OY759346.1| 2026798 g26780 i0 82.018 1.44855967078189 228 37 93 4 18 243 536006 535781 MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1 blastn 352 191 1 Bacteria   Thermotogati Deinococcota Deinococci Trueperales Trueperaceae   Trueperaceae bacterium
24577785 24577785 PRJNA1247234_P_NODE_22580_length_250_cov_0.881356_g22424_i0 PRJNA1247234 22580 250 0.881356 2.20339 Deinococcus metallilatus 1211322 Bacteria Bacteria 195 3.55e-45   NTclustered gi|1609451317|gb|CP038512.1| 1211322 g22424 i0 84.615 2.192 195 30 78 0 5 199 2442948 2443142 Deinococcus metallilatus strain MA1002 chromosome blastn 548 195 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus metallilatus

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