RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1040136" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1040136 · 3 ✖

analysis 1

  • diamond · 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
1444408 1444408 PRJNA1040136_S_NODE_2762_length_241_cov_0.916667_g2759_i0 PRJNA1040136 2762 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 115 1.29e-30   NR WP_205637565.1 470 g2759 i0 89.1 12.7095435684647 64 7 79.7 0 1 192 89 152 WP_205637565.1 histone H2B family protein, partial [Acinetobacter baumannii] diamond 3063 115 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
26591747 26591747 PRJNA1040136_S_NODE_1621_length_279_cov_1.048544_g1618_i0 PRJNA1040136 1621 279 1.048544 2.92543776 Gallionella sp. 2052161 Bacteria Bacteria 78.2 1.94e-14   NR MFA6972877.1 2052161 g1618 i0 68 0.537634408602151 50 16 53.8 0 278 129 535 584 MFA6972877.1 hypothetical protein [Gallionella sp.] diamond 150 78.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Gallionellaceae Gallionella Gallionella sp.
32121776 32121776 PRJNA1040136_S_NODE_258_length_482_cov_2.823961_g255_i0 PRJNA1040136 258 482 2.823961 13.61149202 Pseudomonadota bacterium 1977087 Bacteria Bacteria 65.1 9.07e-10   NR NBP02836.1 1977087 g255 i0 37.4 0.566390041493776 91 47 53.5 2 8 265 57 142 NBP02836.1 hypothetical protein [Pseudomonadota bacterium] diamond 273 65.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium

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