RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1073712" and tax_clade = "PVC group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

tax_clade 1

  • PVC group · 3 ✖

bioproject 1

  • PRJNA1073712 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
5290412 5290412 PRJNA1073712_P_NODE_16365_length_242_cov_0.911243_g16282_i0 PRJNA1073712 16365 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 154 1.52e-41   NR HEX2475483.1 2691534 g16282 i0 95 5.93801652892562 80 4 99.2 0 2 241 416 495 HEX2475483.1 excinuclease ABC subunit UvrA [Lacipirellulaceae bacterium] diamond 1437 155 0.993548387096774 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Pirellulales Lacipirellulaceae   Lacipirellulaceae bacterium
27636214 27636214 PRJNA1073712_P_NODE_1684_length_482_cov_1.555012_g1601_i0 PRJNA1073712 1684 482 1.555012 7.49515784 Puniceicoccales bacterium 2478473 Bacteria Bacteria 52.8 1.12e-4   NR MDR1434996.1 2478473 g1601 i0 32.8 1.5746887966805 125 70 73.4 5 369 16 90 207 MDR1434996.1 glycosyltransferase family 8 protein [Puniceicoccales bacterium] diamond 759 52.8 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Opitutia Puniceicoccales     Puniceicoccales bacterium
30722285 30722285 PRJNA1073712_P_NODE_14274_length_245_cov_1.709302_g14191_i0 PRJNA1073712 14274 245 1.709302 4.1877899 Pseudomonadati 3379134 Bacteria Bacteria 146 8.329999999999999e-40   NR NDG63003.1 2026780 g14191 i0 82.7 17.8530612244898 81 14 99.2 0 1 243 221 301 NDG63003.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Planctomycetota bacterium] diamond 4374 147 0.993197278911565 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;