RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA1016321" and tax_clade = "Embryophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Embryophyta · 3 ✖

bioproject 1

  • PRJNA1016321 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
28921771 28921771 PRJNA1016321_P_NODE_54908_length_242_cov_2.165680_g54677_i0 PRJNA1016321 54908 242 2.16568 5.2409456 Eukaryota 2759 Plants Plants 45.1 6.22e-4   NR MFS7903853.1 73274 g54677 i0 88 1.73553719008264 25 3 31 0 76 2 20 44 MFS7903853.1 hypothetical protein [Helianthus anomalus] diamond 420 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Helianthus Helianthus anomalus
29403316 29403316 PRJNA1016321_P_NODE_24109_length_380_cov_1.328990_g23878_i0 PRJNA1016321 24109 380 1.32899 5.050162 Cryptomeria japonica 3369 Plants Plants 87.8 3.67e-18   NR XP_059068968.1 3369 g23878 i0 50.6 0.655263157894737 83 31 65.5 1 23 271 154 226 XP_059068968.1 uncharacterized protein LOC131859351 [Cryptomeria japonica] diamond 249 87.8 1 Eukaryota Embryophyta Viridiplantae Streptophyta Pinopsida Cupressales Cupressaceae Cryptomeria Cryptomeria japonica
32437922 32437922 PRJNA1016321_P_NODE_22219_length_400_cov_1.853211_g21988_i0 PRJNA1016321 22219 400 1.853211 7.412844 Quercus rubra 3512 Plants Plants 144 1.89e-42   NR KAK4589130.1 3512 g21988 i0 100 0.54 72 0 54 0 265 50 1 72 KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra] diamond 216 144 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fagales Fagaceae Quercus Quercus rubra

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