RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJEB75017", 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 · 3 ✖

tax_clade 1

  • delta/epsilon subdivisions · 3 ✖

bioproject 1

  • PRJEB75017 · 3 ✖

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
5237962 5237962 PRJEB75017_P_NODE_6445_length_349_cov_1.717391_g6316_i0 PRJEB75017 6445 349 1.717391 5.99369459 Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_ 2026735 Bacteria Bacteria 91.3 1.27e-18   NR PIR22470.1 1973974 g6316 i0 45.1 4.63323782234957 91 50 78.2 0 16 288 63 153 PIR22470.1 MAG: hypothetical protein COV44_07845 [Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16] diamond 1617 91.3 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium CG11_big_fil_rev_8_21_14_0_20_45_16
9923603 9923603 PRJEB75017_P_NODE_4588_length_408_cov_5.492537_g4459_i0 PRJEB75017 4588 408 5.492537 22.40955096 Bacteria 2 Bacteria Bacteria 65.8 5.03e-6   NTclustered gi|618731234|emb|HE803860.1| 34034 g4459 i0 91.489 0.230392156862745 47 4 12 0 197 243 1300 1346 Uncultured delta proteobacterium partial 16S rRNA gene, isolate 1.2, clone 2 blastn 94 65.8 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
27381953 27381953 PRJEB75017_P_NODE_17403_length_244_cov_1.368421_g17274_i0 PRJEB75017 17403 244 1.368421 3.33894724 Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14 2013741 Bacteria Bacteria 48.9 2.46e-4   NR PKN57075.1 2013741 g17274 i0 55.3 0.467213114754098 38 15 44.3 1 239 132 428 465 PKN57075.1 MAG: hypothetical protein CVU56_12860 [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14] diamond 114 48.9 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14

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