RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1192965", tax_kingdom = "Pseudomonadati" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

  • Pseudomonadati · 3 ✖

bioproject 1

  • PRJNA1192965 · 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
18172116 18172116 PRJNA1192965_P_NODE_2415_length_281_cov_2.918269_g2396_i0 PRJNA1192965 2415 281 2.918269 8.20033589 Geothrix sp. PMB-07 3068640 Bacteria Bacteria 122 1.9499999999999994e-23   NTclustered gi|2563347696|gb|CP132333.1| 3068640 g2396 i0 80.588 9.7864768683274 170 24 58 3 32 195 104014 103848 Geothrix sp. PMB-07 chromosome, complete genome blastn 2750 122 1 Bacteria   Pseudomonadati Acidobacteriota Holophagae Holophagales Holophagaceae Geothrix Geothrix sp. PMB-07
24546563 24546563 PRJNA1192965_P_NODE_4300_length_245_cov_1.697674_g4281_i0 PRJNA1192965 4300 245 1.697674 4.1593013 Pseudomonadati 3379134 Bacteria Bacteria 119 2.32e-31   NR HZD47411.1 1964179 g4281 i0 77.8 10.9102040816327 81 17 99.2 1 243 1 106 185 HZD47411.1 SDR family oxidoreductase [Silvibacterium sp.] diamond 2673 120 0.991666666666667 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae Silvibacterium Silvibacterium sp.
28335630 28335630 PRJNA1192965_P_NODE_2126_length_293_cov_3.477273_g2107_i0 PRJNA1192965 2126 293 3.477273 10.18840989 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 65.5 5.46e-10   NR MDR3737318.1 2052142 g2107 i0 41.9 2.41638225255973 93 51 92.2 2 270 1 200 292 MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 708 65.5 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae 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);;