RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA1108487" and tax_clade = "delta/epsilon subdivisions"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • delta/epsilon subdivisions · 2 ✖

bioproject 1

  • PRJNA1108487 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
2296043 2296043 PRJNA1108487_P_NODE_7402_length_266_cov_2.419689_g7336_i0 PRJNA1108487 7402 266 2.419689 6.43637274 Bdellovibrionota 3018035 Bacteria Bacteria 492 1.2099999999999999e-134   NTclustered gi|343206979|gb|JN371756.1| 34034 g7336 i0 100 98.0451127819549 266 0 100 0 1 266 440 175 Uncultured delta proteobacterium clone B12-54 16S ribosomal RNA gene, partial sequence blastn 26080 492 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
16790555 16790555 PRJNA1108487_P_NODE_254_length_1177_cov_3.440217_g215_i0 PRJNA1108487 254 1177 3.440217 40.49135409 uncultured delta proteobacterium 34034 Bacteria Bacteria 1260 0   NTclustered gi|374854163|dbj|AP011765.1| 34034 g215 i0 87.088 167.185216652506 1123 134 95 10 60 1177 13900 12784 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 196777 1260 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium

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