RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1200128" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1200128 · 5 ✖

analysis 1

  • blastn · 5 ✖
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
327024 327024 PRJNA1200128_S_NODE_26881_length_185_cov_2.295775_g26772_i0 PRJNA1200128 26881 185 2.295775 4.24718375 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 259 8.67e-65   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g26772 i0 91.892 28.2 185 15 100 0 1 185 1600681 1600497 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 5217 259 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
1601862 1601862 PRJNA1200128_S_NODE_5742_length_301_cov_2.775194_g5633_i0 PRJNA1200128 5742 301 2.775194 8.35333394 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 490 5.01e-134   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g5633 i0 96.013 160.568106312292 301 12 100 0 1 301 1600052 1599752 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 48331 490 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
7980466 7980466 PRJNA1200128_S_NODE_14747_length_223_cov_2.788889_g14638_i0 PRJNA1200128 14747 223 2.788889 6.21922247 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 375 1.03e-99   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g14638 i0 97.285 45.6816143497758 221 6 99 0 1 221 1599677 1599457 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 10187 375 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
10530817 10530817 PRJNA1200128_S_NODE_10969_length_245_cov_2.559406_g10860_i0 PRJNA1200128 10969 245 2.559406 6.2705447 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 420 5.26e-113   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g10860 i0 97.551 160.914285714286 245 6 100 0 1 245 1601084 1601328 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 39424 420 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7
10530837 10530837 PRJNA1200128_S_NODE_15229_length_221_cov_1.848315_g15120_i0 PRJNA1200128 15229 221 1.848315 4.08477615 Isosphaeraceae bacterium EP7 3139350 Bacteria Bacteria 381 2.2e-101   NTclustered gi|2719878338|gb|CP151667.1| 3139350 g15120 i0 99.061 298.380090497738 213 1 96 1 10 221 1600081 1600293 Isosphaeraceae bacterium EP7 chromosome, complete genome blastn 65942 381 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Isosphaerales Isosphaeraceae   Isosphaeraceae bacterium EP7

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