RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB6054" and tax_phylum = "Streptophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Streptophyta · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB6054 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
25523022 25523022 PRJEB6054_S_NODE_1705_length_321_cov_4.286713_g1616_i0 PRJEB6054 1705 321 4.286713 13.76034873 Eukaryota 2759 Plants Plants 95.5 1.2e-22   NR NP_001365255.1 3218 g1616 i0 62.5 9.05607476635514 88 31 82.2 1 319 56 50 135 NP_001365255.1 40S ribosomal protein S24-1 [Physcomitrium patens] diamond 2907 95.9 0.995828988529718 Eukaryota Embryophyta Viridiplantae Streptophyta Bryopsida Funariales Funariaceae Physcomitrium Physcomitrium patens
33008463 33008463 PRJEB6054_S_NODE_5155_length_222_cov_7.165775_g5066_i0 PRJEB6054 5155 222 7.165775 15.9080205 Eukaryota 2759 Plants Plants 41.2 0.0259   NR CAK8537586.1 3860 g5066 i0 72.7 0.594594594594595 22 6 29.7 0 109 174 70 91 CAK8537586.1 unnamed protein product [Lathyrus sativus] diamond 132 41.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lathyrus Lathyrus sativus
33025687 33025687 PRJEB6054_S_NODE_11428_length_168_cov_2.293233_g11339_i0 PRJEB6054 11428 168 2.293233 3.85263144 root 1 Root_unresolved Root_unresolved 107 3.1699999999999997e-25   NR GEU28118.1 118510 g11339 i0 96.4 38 56 2 100 0 168 1 43 98 GEU28118.1 succinate--CoA ligase [ADP-forming] subunit beta, mitochondrial [Tanacetum cinerariifolium] diamond 6384 108 0.990740740740741 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Asterales Asteraceae Tanacetum Tanacetum cinerariifolium
33031380 33031380 PRJEB6054_S_NODE_4908_length_226_cov_1.638743_g4819_i0 PRJEB6054 4908 226 1.638743 3.70355918 Herrania umbratica 108875 Plants Plants 70.9 1.72e-13   NR XP_021298165.1 108875 g4819 i0 68 0.663716814159292 50 16 66.4 0 224 75 87 136 XP_021298165.1 40S ribosomal protein S12 [Herrania umbratica] diamond 150 70.9 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Herrania Herrania umbratica
33110811 33110811 PRJEB6054_S_NODE_14526_length_155_cov_1.000000_g14437_i0 PRJEB6054 14526 155 1 1.55 Eukaryota 2759 Plants Plants 47.4 2.62e-4   NR KAH9627494.1 39905 g14437 i0 57.8 3.65806451612903 45 17 83.2 1 3 131 265 309 KAH9627494.1 hypothetical protein KSS87_006185 [Heliosperma pusillum] diamond 567 47.8 0.99163179916318 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Heliosperma Heliosperma pusillum
33161970 33161970 PRJEB6054_S_NODE_11776_length_166_cov_1.557252_g11687_i0 PRJEB6054 11776 166 1.557252 2.58503832 Caryophyllaceae 3568 Plants Plants 53.5 1.5e-6   NR KAK9698499.1 3572 g11687 i0 58.7 6.75903614457831 46 19 83.1 0 160 23 5 50 KAK9698499.1 hypothetical protein RND81_08G109000 [Saponaria officinalis] diamond 1122 53.9 0.992578849721707 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Caryophyllaceae Saponaria Saponaria officinalis

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