RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA631796" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA631796 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
28577797 28577797 PRJNA631796_P_NODE_10187_length_216_cov_1.419355_g9909_i0 PRJNA631796 10187 216 1.419355 3.0658068 Marchantiales 28908 Plants Plants 80.9 9.67e-16   NR KAL2644248.1 41844 g9909 i0 61.7 6.38888888888889 60 23 83.3 0 1 180 420 479 KAL2644248.1 hypothetical protein R1flu_011835 [Riccia fluitans] diamond 1380 80.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Marchantiopsida Marchantiales Ricciaceae Riccia Riccia fluitans
31408224 31408224 PRJNA631796_P_NODE_11496_length_207_cov_0.958904_g11218_i0 PRJNA631796 11496 207 0.958904 1.98493128 Zingiber officinale 94328 Plants Plants 92.4 7.53e-20   NR XP_042400896.1 94328 g11218 i0 68.7 1.94202898550725 67 21 97.1 0 1 201 476 542 XP_042400896.1 uncharacterized protein LOC121990913, partial [Zingiber officinale] diamond 402 92.4 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Zingiberales Zingiberaceae Zingiber Zingiber officinale
31705343 31705343 PRJNA631796_P_NODE_13517_length_196_cov_2.392593_g13239_i0 PRJNA631796 13517 196 2.392593 4.68948228 Magnoliopsida 3398 Plants Plants 83.2 2.96e-18   NR KAK3229557.1 43782 g13239 i0 59.4 19.6683673469388 64 26 98 0 5 196 10 73 KAK3229557.1 hypothetical protein Dsin_001438 [Dipteronia sinensis] diamond 3855 83.6 0.995215311004785 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Sapindaceae Dipteronia Dipteronia sinensis
32243546 32243546 PRJNA631796_P_NODE_12758_length_202_cov_1.815603_g12480_i0 PRJNA631796 12758 202 1.815603 3.66751806 Solanum 4107 Plants Plants 117 1.1000000000000002e-28   NR XP_015160449.1 4113 g12480 i0 79.7 9.5049504950495 64 13 95 0 197 6 302 365 XP_015160449.1 PREDICTED: uncharacterized protein LOC107058800 [Solanum tuberosum] diamond 1920 118 0.991525423728814 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum tuberosum

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