RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA743294" 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

  • PRJNA743294 · 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
3750063 3750063 PRJNA743294_P_NODE_41103_length_266_cov_1.000000_g40647_i0 PRJNA743294 41103 266 1 2.66 Bacteria 2 Bacteria Bacteria 268 2.22e-67   NTclustered gi|95115285|gb|DQ501327.1| 34034 g40647 i0 84.906 74.7669172932331 265 40 99 0 2 266 1192 1456 Uncultured delta proteobacterium clone ST11-13 16S ribosomal RNA gene, partial sequence blastn 19888 268 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
16024676 16024676 PRJNA743294_P_NODE_39633_length_270_cov_1.350254_g39177_i0 PRJNA743294 39633 270 1.350254 3.6456858 uncultured delta proteobacterium 34034 Bacteria Bacteria 248 2.94e-61   NTclustered gi|374854163|dbj|AP011765.1| 34034 g39177 i0 85.02 674.811111111111 247 34 91 3 26 270 12468 12713 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 182199 248 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);;