RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA330616" 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 · 4 ✖

bioproject 1

  • PRJNA330616 · 4 ✖

analysis 1

  • blastn · 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
6767460 6767460 PRJNA330616_P_NODE_3986_length_429_cov_1.947368_g3578_i0 PRJNA330616 3986 429 1.947368 8.35420872 uncultured delta proteobacterium 34034 Bacteria Bacteria 601 3.28e-167   NTclustered gi|374854163|dbj|AP011765.1| 34034 g3578 i0 92.978 138.552447552448 413 27 96 2 18 429 13322 12911 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 59439 601 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
13143390 13143390 PRJNA330616_P_NODE_4191_length_418_cov_2.899729_g3783_i0 PRJNA330616 4191 418 2.899729 12.12086722 uncultured delta proteobacterium 34034 Bacteria Bacteria 444 5.68e-120   NTclustered gi|374854163|dbj|AP011765.1| 34034 g3783 i0 86.052 269.861244019139 423 47 100 12 1 418 12821 12406 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 112802 444 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
16967263 16967263 PRJNA330616_P_NODE_9214_length_273_cov_2.799107_g8805_i0 PRJNA330616 9214 273 2.799107 7.64156211 uncultured delta proteobacterium 34034 Bacteria Bacteria 270 6.359999999999999e-68   NTclustered gi|374854163|dbj|AP011765.1| 34034 g8805 i0 84.783 291.556776556777 276 35 100 7 1 273 14794 15065 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 79595 270 1 Bacteria delta/epsilon subdivisions     Deltaproteobacteria       uncultured delta proteobacterium
23341433 23341433 PRJNA330616_P_NODE_1259_length_831_cov_4.790281_g922_i0 PRJNA330616 1259 831 4.790281 39.80723511 uncultured delta proteobacterium 34034 Bacteria Bacteria 808 0   NTclustered gi|374854163|dbj|AP011765.1| 34034 g922 i0 84.756 182.064981949458 820 109 98 13 20 831 14053 13242 Uncultured delta proteobacterium DNA, fosmid clone: JFF046_H12 blastn 151296 808 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);;