RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA1111448" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA1111448 · 4 ✖

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
15520600 15520600 PRJNA1111448_S_NODE_3913_length_801_cov_4.135989_g3323_i0 PRJNA1111448 3913 801 4.135989 33.12927189 uncultured delta proteobacterium HF0070_10I02 710824 Bacteria Bacteria 619 1.76e-172   NTclustered gi|297181000|gb|GU474857.1| 710824 g3323 i0 81.273 195.746566791511 801 119 99 26 1 789 7297 8078 Uncultured delta proteobacterium HF0070_10I02 genomic sequence blastn 156793 619 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium HF0070_10I02
24444596 24444596 PRJNA1111448_S_NODE_98580_length_273_cov_1.540000_g97757_i0 PRJNA1111448 98580 273 1.54 4.2042 uncultured delta proteobacterium 34034 Bacteria Bacteria 191 5.09e-44   NTclustered gi|374854163|dbj|AP011765.1| 34034 g97757 i0 80.952 53.032967032967 252 39 91 4 3 251 13891 13646 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 14478 191 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
25248952 25248952 PRJNA1111448_S_NODE_138060_length_241_cov_2.053571_g137237_i0 PRJNA1111448 138060 241 2.053571 4.94910611 Bacteria 2 Bacteria Bacteria 374 4.079999999999998e-99   NTclustered gi|146430603|gb|EF221419.1| 34034 g137237 i0 94.606 99.7966804979253 241 13 100 0 1 241 425 665 Uncultured delta proteobacterium clone SI-2F_H09 16S ribosomal RNA gene, partial sequence blastn 24051 374 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
32817453 32817453 PRJNA1111448_S_NODE_117220_length_254_cov_1.276243_g116397_i0 PRJNA1111448 117220 254 1.276243 3.24165722 Deltaproteobacteria bacterium ADurb.Bin2 2026735 Bacteria Bacteria 48.9 2.81e-4   NR OQB07698.1 1852869 g116397 i0 36.4 0.519685039370079 44 28 52 0 42 173 340 383 OQB07698.1 MAG: hypothetical protein BWY17_05226 [Deltaproteobacteria bacterium ADurb.Bin207] diamond 132 48.9 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium ADurb.Bin207

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