RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA492280", tax_clade = "delta/epsilon subdivisions" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 4 ✖

tax_clade 1

  • delta/epsilon subdivisions · 4 ✖

bioproject 1

  • PRJNA492280 · 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
4279065 4279065 PRJNA492280_P_NODE_2764_length_285_cov_5.866935_g2657_i0 PRJNA492280 2764 285 5.866935 16.72076475 uncultured delta proteobacterium 34034 Bacteria Bacteria 296 1.0999999999999999e-75   NTclustered gi|82523912|emb|AJ937768.1| 34034 g2657 i0 86.477 172.498245614035 281 24 99 1 2 282 537 271 Uncultured delta proteobacterium fosmid clone b1bf1.1.d04 blastn 49162 296 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
6202016 6202016 PRJNA492280_P_NODE_18985_length_164_cov_3.503937_g18878_i0 PRJNA492280 18985 164 3.503937 5.74645668 Pseudomonadati 3379134 Bacteria Bacteria 122 1.03e-23   NTclustered gi|511202453|gb|KC994684.1| 34034 g18878 i0 97.222 43.9024390243902 72 2 44 0 91 162 99 28 Uncultured delta proteobacterium clone BF 004 16S ribosomal RNA gene, partial sequence blastn 7200 122 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
24050930 24050930 PRJNA492280_P_NODE_3359_length_265_cov_8.635965_g3252_i0 PRJNA492280 3359 265 8.635965 22.88530725 delta/epsilon subdivisions 68525 Bacteria Bacteria 161 3.86e-35   NTclustered gi|2259134431|emb|OW921521.1| 34034 g3252 i0 100 32.8301886792453 87 0 33 0 93 179 249 335 uncultured delta proteobacterium DNA containing 16S-23S intergenic spacer region, clone 43 blastn 8700 161 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
27013078 27013078 PRJNA492280_P_NODE_33082_length_150_cov_4.460177_g32975_i0 PRJNA492280 33082 150 4.460177 6.6902655 SAR324 cluster bacterium 2024889 Bacteria Bacteria 55.1 4.49e-7   NR MBF0353446.1 2024889 g32975 i0 54.2 2 48 17 86 1 17 145 265 312 MBF0353446.1 glycosyltransferase family 4 protein [SAR324 cluster bacterium] diamond 300 55.1 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       SAR324 cluster 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);;