RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1199330", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Bacteria · 3 ✖

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJNA1199330 · 3 ✖

analysis 1

tax_phylum 0

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
28398987 28398987 PRJNA1199330_P_NODE_14126_length_546_cov_2.253700_g13439_i0 PRJNA1199330 14126 546 2.2537 12.305202 SAR324 cluster bacterium 2024889 Bacteria Bacteria 69.7 3.2e-10   NR MDG2063940.1 2024889 g13439 i0 32.9 0.785714285714286 143 80 74.2 6 424 20 148 282 MDG2063940.1 LamG domain-containing protein [SAR324 cluster bacterium] diamond 429 69.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
30849719 30849719 PRJNA1199330_P_NODE_99914_length_253_cov_1.733333_g99215_i0 PRJNA1199330 99914 253 1.733333 4.38533249 Chloroflexota 200795 Bacteria Bacteria 44.7 0.00879   NR MCS5551872.1 2024889 g99215 i0 29.2 2.300395256917 65 43 73.5 1 49 234 440 504 MCS5551872.1 hypothetical protein [SAR324 cluster bacterium] diamond 582 44.7 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster bacterium
31273259 31273259 PRJNA1199330_P_NODE_61475_length_289_cov_2.074074_g60776_i0 PRJNA1199330 61475 289 2.074074 5.99407386 Persicimonas caeni 2292766 Bacteria Bacteria 45.4 0.00666   NR WP_141195885.1 2292766 g60776 i0 34 1.00692041522491 97 48 88.2 5 284 30 71 163 WP_141195885.1 hypothetical protein [Persicimonas caeni] diamond 291 45.4 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria Bradymonadales Bradymonadaceae Persicimonas Persicimonas caeni

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