RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

bioproject 1

  • PRJNA720429 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
25420112 25420112 PRJNA720429_P_NODE_3320_length_251_cov_0.865169_g3263_i0 PRJNA720429 3320 251 0.865169 2.17157419 Streptophyta 35493 Plants Plants 119 1.33e-29   NR KAH0638085.1 4113 g3263 i0 73.2 17.5577689243028 82 22 98 0 5 250 13 94 KAH0638085.1 hypothetical protein KY289_038000 [Solanum tuberosum] diamond 4407 119 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Solanales Solanaceae Solanum Solanum tuberosum
27968012 27968012 PRJNA720429_P_NODE_3445_length_250_cov_0.870056_g3388_i0 PRJNA720429 3445 250 0.870056 2.17514 Chenopodium quinoa 63459 Plants Plants 160 5.0599999999999997e-48   NR XP_021734605.1 63459 g3388 i0 83.1 0.996 83 14 99.6 0 1 249 72 154 XP_021734605.1 small heat shock protein, chloroplastic-like [Chenopodium quinoa] diamond 249 160 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Chenopodium Chenopodium quinoa
29672715 29672715 PRJNA720429_P_NODE_4570_length_244_cov_0.900585_g4513_i0 PRJNA720429 4570 244 0.900585 2.1974274 Bienertia sinuspersici 338654 Plants Plants 114 1.6e-30   NR KAL2894182.1 338654 g4513 i0 82 0.75 61 11 75 0 60 242 1 61 KAL2894182.1 Basic blue protein [Bienertia sinuspersici] diamond 183 114 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Caryophyllales Chenopodiaceae Bienertia Bienertia sinuspersici
30115158 30115158 PRJNA720429_P_NODE_4952_length_242_cov_0.911243_g4895_i0 PRJNA720429 4952 242 0.911243 2.20520806 Citrus sinensis 2711 Plants Plants 156 1.56e-42   NR KAH9698093.1 2711 g4895 i0 100 0.991735537190083 80 0 99.2 0 2 241 123 202 KAH9698093.1 hypothetical protein KPL71_023880 [Citrus sinensis] diamond 240 156 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Sapindales Rutaceae Citrus Citrus sinensis
30873532 30873532 PRJNA720429_P_NODE_4174_length_246_cov_0.890173_g4117_i0 PRJNA720429 4174 246 0.890173 2.18982558 Camellia sinensis var. sinensis 542762 Plants Plants 78.2 7.73e-15   NR GMP68312.1 542762 g4117 i0 65.1 0.768292682926829 63 21 75.6 1 7 192 37 99 GMP68312.1 hypothetical protein CsSME_00027961 [Camellia sinensis var. sinensis] diamond 189 78.2 1 Eukaryota Embryophyta Viridiplantae Streptophyta Magnoliopsida Ericales Theaceae Camellia Camellia sinensis

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