RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_kingdom = "Thermotogati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Thermotogati · 3 ✖

bioproject 1

  • PRJNA533114 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
504587 504587 PRJNA533114_P_NODE_118981_length_241_cov_1.672619_g118729_i0 PRJNA533114 118981 241 1.672619 4.03101179 Deinococcus sonorensis 309891 Bacteria Bacteria 52.8 0.022   NTclustered gi|2745307249|gb|CP158299.1| 694439 g118729 i0 96.875 0.132780082987552 32 0 13 1 97 128 2506489 2506459 Deinococcus sonorensis KR-87 chromosome, complete genome blastn 32 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
3056479 3056479 PRJNA533114_P_NODE_78483_length_273_cov_4.875000_g78231_i0 PRJNA533114 78483 273 4.875 13.30875 Deinococcus sonorensis 309891 Bacteria Bacteria 52.8 0.025   NTclustered gi|2745307249|gb|CP158299.1| 694439 g78231 i0 96.774 0.113553113553114 31 1 11 0 83 113 2384270 2384300 Deinococcus sonorensis KR-87 chromosome, complete genome blastn 31 52.8 1 Bacteria   Thermotogati Deinococcota Deinococci Deinococcales Deinococcaceae Deinococcus Deinococcus sonorensis
18969114 18969114 PRJNA533114_P_NODE_86475_length_261_cov_1.638298_g86223_i0 PRJNA533114 86475 261 1.638298 4.27595778 Deinococcus 1298 Bacteria Bacteria 477 3.3099999999999986e-130   NTclustered gi|2113031129|gb|OK500351.1| 47478 g86223 i0 99.617 104 261 1 100 0 1 261 491 751 Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence blastn 27144 477 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);;