RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA206070" and tax_clade = "Bacteria candidate phyla"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

  • Bacteria candidate phyla · 4 ✖

bioproject 1

  • PRJNA206070 · 4 ✖

analysis 1

tax_kingdom 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
27390212 27390212 PRJNA206070_S_NODE_10503_length_366_cov_2.598784_g8628_i0 PRJNA206070 10503 366 2.598784 9.51154944 Minisyncoccota bacterium 2053589 Bacteria Bacteria 214 9.410000000000001e-66   NR MDD3663098.1 2053589 g8628 i0 93.9 0.942622950819672 115 7 94.3 0 16 360 126 240 MDD3663098.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 345 214 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
27611165 27611165 PRJNA206070_S_NODE_12084_length_322_cov_2.382456_g10208_i0 PRJNA206070 12084 322 2.382456 7.67150832 Minisyncoccota bacterium 2053589 Bacteria Bacteria 181 7.05e-53   NR MDD3663098.1 2053589 g10208 i0 86.1 0.940993788819876 101 14 94.1 0 3 305 41 141 MDD3663098.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 303 181 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
29505368 29505368 PRJNA206070_S_NODE_12450_length_313_cov_3.550725_g10574_i0 PRJNA206070 12450 313 3.550725 11.11376925 Minisyncoccota bacterium 2053589 Bacteria Bacteria 177 2e-51   NR MDD3663098.1 2053589 g10574 i0 92.6 0.910543130990415 95 7 91.1 0 22 306 249 343 MDD3663098.1 hypothetical protein [Candidatus Paceibacterota bacterium] diamond 285 177 1 Bacteria Bacteria candidate phyla   Minisyncoccota         Minisyncoccota bacterium
30136766 30136766 PRJNA206070_S_NODE_23812_length_180_cov_1.048951_g21936_i0 PRJNA206070 23812 180 1.048951 1.8881118 Patescibacteria group bacterium 2052139 Bacteria Bacteria 60.1 8.43e-9   NR MDE2098066.1 2052139 g21936 i0 63.8 0.783333333333333 47 16 76.7 1 34 171 208 254 MDE2098066.1 hypothetical protein [Patescibacteria group bacterium] diamond 141 60.1 1 Bacteria Bacteria candidate phyla             Patescibacteria group 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);;