RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Thermomicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Thermomicrobiota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJEB11748 · 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
13874 13874 PRJEB11748_P_NODE_105001_length_407_cov_4.106936_g102829_i0 PRJEB11748 105001 407 4.106936 16.71522952 Thermomicrobium roseum 500 Bacteria Bacteria 339 2.68e-88   NTclustered gi|221157271|gb|CP001276.1| 309801 g102829 i0 83.799 5.46683046683047 358 56 88 2 30 386 181940 182296 Thermomicrobium roseum DSM 5159 plasmid, complete sequence blastn 2225 339 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales Thermomicrobiaceae Thermomicrobium Thermomicrobium roseum
17871684 17871684 PRJEB11748_P_NODE_73115_length_493_cov_4.428241_g70963_i0 PRJEB11748 73115 493 4.428241 21.83122813 Thermomicrobium roseum 500 Bacteria Bacteria 494 6.65e-135   NTclustered gi|221155340|gb|CP001275.1| 309801 g70963 i0 85.593 7.97971602434077 472 66 96 2 2 472 436685 436215 Thermomicrobium roseum DSM 5159, complete genome blastn 3934 494 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales Thermomicrobiaceae Thermomicrobium Thermomicrobium roseum
19145311 19145311 PRJEB11748_P_NODE_64716_length_526_cov_11.490323_g62576_i0 PRJEB11748 64716 526 11.490323 60.43909898 Thermomicrobium roseum 500 Bacteria Bacteria 254 1.32e-62   NTclustered gi|221155340|gb|CP001275.1| 309801 g62576 i0 78.199 17.8916349809886 422 74 79 17 66 479 1625272 1625683 Thermomicrobium roseum DSM 5159, complete genome blastn 9411 254 1 Bacteria   Pseudomonadati Thermomicrobiota Thermomicrobia Thermomicrobiales Thermomicrobiaceae Thermomicrobium Thermomicrobium roseum

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