RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax_phylum = "Bacillota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA561138 · 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
13884463 13884463 PRJNA561138_P_NODE_15291_length_335_cov_34.721374_g15096_i0 PRJNA561138 15291 335 34.721374 116.3166029 Bacillales 1385 Bacteria Bacteria 278 4.79e-70   NTclustered gi|1348914887|gb|MG983975.1| 1409 g15096 i0 100 104.331343283582 150 0 90 0 1 150 295 444 Bacillus sp. (in: Bacteria) strain B7 16S ribosomal RNA gene, partial sequence blastn 34951 278 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus sp. (in: firmicutes)
15158650 15158650 PRJNA561138_P_NODE_15112_length_337_cov_1.477273_g14917_i0 PRJNA561138 15112 337 1.477273 4.97841001 Streptococcus 1301 Bacteria Bacteria 606 5.409999999999998e-169   NTclustered gi|1948603152|gb|CP066021.1| 1303 g14917 i0 99.11 339.00296735905 337 3 100 0 1 337 673574 673238 Streptococcus oralis strain FDAARGOS_1020 chromosome, complete genome blastn 114244 612 0.990196078431373 Bacteria   Bacillati Bacillota Bacilli Lactobacillales Streptococcaceae Streptococcus Streptococcus oralis
15847947 15847947 PRJNA561138_P_NODE_25093_length_250_cov_0.870056_g24898_i0 PRJNA561138 25093 250 0.870056 2.17514 Veillonella rogosae 423477 Bacteria Bacteria 429 8.949999999999998e-116   NTclustered gi|2446175566|gb|CP117967.1| 423477 g24898 i0 97.6 4.784 250 6 100 0 1 250 942366 942117 Veillonella rogosae strain AC2811 AN NA 2 chromosome, complete genome blastn 1196 429 1 Bacteria   Bacillati Bacillota Negativicutes Veillonellales Veillonellaceae Veillonella Veillonella rogosae
16433306 16433306 PRJNA561138_P_NODE_15293_length_335_cov_6.480916_g15098_i0 PRJNA561138 15293 335 6.480916 21.7110686 root 1 Root_unresolved Root_unresolved 278 4.79e-70   NTclustered gi|1002357967|gb|KU738862.1| 1390 g15098 i0 100 98.1970149253731 150 0 80 0 186 335 656 805 Bacillus amyloliquefaciens strain AZB42 16S ribosomal RNA gene, partial sequence blastn 32896 278 1 Bacteria   Bacillati Bacillota Bacilli Bacillales Bacillaceae Bacillus Bacillus amyloliquefaciens

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