RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA512103" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 2 ✖

bioproject 1

  • PRJNA512103 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
486139 486139 PRJNA512103_P_NODE_30001_length_170_cov_1.867769_g29589_i0 PRJNA512103 30001 170 1.867769 3.1752073 Deinococcus sp. KNUC1210 2917691 Bacteria Bacteria 231 1.6999999999999997e-56   NTclustered gi|2197029603|gb|CP092190.1| 2917691 g29589 i0 93.548 180.194117647059 155 10 91 0 5 159 1427420 1427266 Deinococcus sp. KNUC1210 chromosome, complete genome blastn 30633 231 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sp. KNUC1210
4939097 4939097 PRJNA512103_P_NODE_15624_length_256_cov_9.874396_g15212_i0 PRJNA512103 15624 256 9.874396 25.27845376 Deinococcus 1298 Bacteria Bacteria 217 7.8e-52   NTclustered gi|485099143|ref|NR_102538.1| 432329 g15212 i0 83.817 390.7421875 241 25 90 10 13 243 256 20 Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence blastn 100030 217 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus peraridilitoris

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