contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA929952" and tax_kingdom = "Viridiplantae"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 909191 | 909191 | PRJNA929952_P_NODE_301_length_1654_cov_3.419077_g181_i1 | PRJNA929952 | 301 | 1654 | 3.419077 | 56.55153358 | Axonopus compressus | 217170 | Plants | Plants | 814 | 4.05e-294 | NR | QJD54296.1 | 217170 | g181 | i1 | 88.6 | 0.845223700120919 | 466 | 33 | 80.9 | 1 | 1563 | 226 | 1 | 466 | QJD54296.1 elongation factor 1-alpha [Axonopus compressus] | diamond | 1398 | 814 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Axonopus | Axonopus compressus | |
| 3460043 | 3460043 | PRJNA929952_P_NODE_2123_length_817_cov_3.953046_g1533_i0 | PRJNA929952 | 2123 | 817 | 3.953046 | 32.29638582 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 249 | 1.19e-78 | NR | BAK00797.1 | 112509 | g1533 | i0 | 51.4 | 0.951040391676867 | 259 | 115 | 92.9 | 5 | 35 | 793 | 8 | 261 | BAK00797.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 777 | 249 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 28169051 | 28169051 | PRJNA929952_P_NODE_20185_length_207_cov_4.786517_g18891_i0 | PRJNA929952 | 20185 | 207 | 4.786517 | 9.90809019 | root | 1 | Root_unresolved | Root_unresolved | 42 | 0.0416 | NR | EOA18611.1 | 81985 | g18891 | i0 | 38.5 | 1.23188405797101 | 39 | 24 | 56.5 | 0 | 2 | 118 | 232 | 270 | EOA18611.1 hypothetical protein CARUB_v10007184mg [Capsella rubella] | diamond | 255 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Capsella | Capsella rubella | |
| 28698935 | 28698935 | PRJNA929952_P_NODE_9327_length_385_cov_15.775281_g8053_i0 | PRJNA929952 | 9327 | 385 | 15.775281 | 60.73483185 | Ceratodon purpureus | 3225 | Plants | Plants | 43.5 | 0.0117 | NR | KAG0504195.1 | 3225 | g8053 | i0 | 56.4 | 0.303896103896104 | 39 | 17 | 30.4 | 0 | 121 | 5 | 38 | 76 | KAG0504195.1 hypothetical protein KC19_N006800 [Ceratodon purpureus] | diamond | 117 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 28919586 | 28919586 | PRJNA929952_P_NODE_14908_length_268_cov_9.602510_g13614_i0 | PRJNA929952 | 14908 | 268 | 9.60251 | 25.7347268 | Prunus brigantina | 151428 | Plants | Plants | 48.9 | 7.86e-5 | NR | CAL8988860.1 | 151428 | g13614 | i0 | 34.8 | 0.996268656716418 | 89 | 39 | 99.6 | 1 | 268 | 2 | 33 | 102 | CAL8988860.1 unnamed protein product, partial [Prunus brigantina] | diamond | 267 | 48.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Prunus | Prunus brigantina | |
| 29551049 | 29551049 | PRJNA929952_P_NODE_22850_length_170_cov_3.113475_g21556_i0 | PRJNA929952 | 22850 | 170 | 3.113475 | 5.2929075 | Capsicum baccatum | 33114 | Plants | Plants | 47.8 | 2.36e-4 | NR | PHT25568.1 | 33114 | g21556 | i0 | 58.8 | 1.2 | 34 | 14 | 60 | 0 | 139 | 38 | 447 | 480 | PHT25568.1 hypothetical protein CQW23_34807 [Capsicum baccatum] | diamond | 204 | 47.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Capsicum | Capsicum baccatum | |
| 32238178 | 32238178 | PRJNA929952_P_NODE_22358_length_176_cov_1.789116_g21064_i0 | PRJNA929952 | 22358 | 176 | 1.789116 | 3.14884416 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 56.2 | 2.64e-7 | NR | BAK02651.1 | 112509 | g21064 | i0 | 61.5 | 0.664772727272727 | 39 | 15 | 66.5 | 0 | 56 | 172 | 565 | 603 | BAK02651.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 117 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare |
Advanced export
JSON shape: default, array, newline-delimited
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);;