RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA415636" 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 · 6 ✖

bioproject 1

  • PRJNA415636 · 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
6796859 6796859 PRJNA415636_S_NODE_3026_length_277_cov_2.004348_g2979_i0 PRJNA415636 3026 277 2.004348 5.55204396 Eukaryota 2759 Plants Plants 95.1 1.81e-20   NR PPR88358.1 3634 g2979 i0 63.9 21.0541516245487 72 26 78 0 277 62 424 495 PPR88358.1 hypothetical protein GOBAR_AA32326 [Gossypium barbadense] diamond 5832 95.9 0.991657977059437 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Malvales Malvaceae Gossypium Gossypium barbadense
18270724 18270724 PRJNA415636_S_NODE_1275_length_379_cov_3.162651_g1228_i0 PRJNA415636 1275 379 3.162651 11.98644729 Lotus japonicus 34305 Plants Plants 66.2 7.67e-11   NR AFK38515.1 34305 g1228 i0 50.5 0.720316622691293 91 42 72 2 372 100 41 128 AFK38515.1 unknown [Lotus japonicus] diamond 273 66.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Fabales Fabaceae Lotus Lotus japonicus
27345262 27345262 PRJNA415636_S_NODE_2583_length_294_cov_2.773279_g2536_i0 PRJNA415636 2583 294 2.773279 8.15344026 Magnoliopsida 3398 Plants Plants 75.9 7.72e-15   NR XP_012843457.1 4155 g2536 i0 64.9 5.37755102040816 57 19 58.2 1 3 173 105 160 XP_012843457.1 PREDICTED: 40S ribosomal protein S11-2 [Erythranthe guttata] diamond 1581 76.6 0.990861618798956 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Phrymaceae Erythranthe Erythranthe guttata
27408507 27408507 PRJNA415636_S_NODE_1843_length_333_cov_4.339161_g1796_i0 PRJNA415636 1843 333 4.339161 14.44940613 Magnoliopsida 3398 Plants Plants 44.3 0.0271   NR XP_012834334.1 4155 g1796 i0 42.6 1.87387387387387 47 27 42.3 0 330 190 177 223 XP_012834334.1 PREDICTED: polygalacturonase inhibitor-like [Erythranthe guttata] diamond 624 44.3 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Lamiales Phrymaceae Erythranthe Erythranthe guttata
28402000 28402000 PRJNA415636_S_NODE_3706_length_256_cov_3.186603_g3659_i0 PRJNA415636 3706 256 3.186603 8.15770368 Arabidopsis arenosa 38785 Plants Plants 47 0.00135   NR CAE5958279.1 38785 g3659 i0 54.8 0.78515625 42 19 49.2 0 256 131 127 168 CAE5958279.1 unnamed protein product [Arabidopsis arenosa] diamond 201 47 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Brassicales Brassicaceae Arabidopsis Arabidopsis arenosa
29160009 29160009 PRJNA415636_S_NODE_5989_length_212_cov_0.963636_g5942_i0 PRJNA415636 5989 212 0.963636 2.04290832 Anisodus tanguticus 243964 Plants Plants 45.1 0.00245   NR KAK4378931.1 243964 g5942 i0 61.3 0.438679245283019 31 12 43.9 0 203 111 12 42 KAK4378931.1 hypothetical protein RND71_000793 [Anisodus tanguticus] diamond 93 45.1 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Anisodus Anisodus tanguticus

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