contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA255848" and tax_clade = "Embryophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1057043 | 1057043 | PRJNA255848_P_NODE_41021_length_164_cov_0.886957_g40703_i0 | PRJNA255848 | 41021 | 164 | 0.886957 | 1.45460948 | Magnoliopsida | 3398 | Plants | Plants | 96.7 | 5.2e-22 | NR | XP_012838598.1 | 4155 | g40703 | i0 | 79.6 | 55.2073170731707 | 54 | 11 | 98.8 | 0 | 163 | 2 | 106 | 159 | XP_012838598.1 PREDICTED: S-adenosylmethionine synthase 3-like [Erythranthe guttata] | diamond | 9054 | 97.4 | 0.992813141683778 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Phrymaceae | Erythranthe | Erythranthe guttata | |
| 26806982 | 26806982 | PRJNA255848_P_NODE_34621_length_168_cov_1.285714_g34303_i0 | PRJNA255848 | 34621 | 168 | 1.285714 | 2.15999952 | Solanum | 4107 | Plants | Plants | 41.2 | 0.0498 | NR | XP_004251482.2 | 4081 | g34303 | i0 | 40 | 1.60714285714286 | 45 | 24 | 80.4 | 1 | 156 | 22 | 181 | 222 | XP_004251482.2 G-type lectin S-receptor-like serine/threonine-protein kinase At4g27290 isoform X2 [Solanum lycopersicum] | diamond | 270 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 28148010 | 28148010 | PRJNA255848_P_NODE_28205_length_187_cov_2.217391_g27887_i0 | PRJNA255848 | 28205 | 187 | 2.217391 | 4.14652117 | Manihot esculenta | 3983 | Plants | Plants | 45.4 | 0.00203 | NR | XP_021627861.1 | 3983 | g27887 | i0 | 47.3 | 0.882352941176471 | 55 | 28 | 86.6 | 1 | 25 | 186 | 563 | 617 | XP_021627861.1 putative disease resistance RPP13-like protein 1 [Manihot esculenta] | diamond | 165 | 45.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Euphorbiaceae | Manihot | Manihot esculenta | |
| 28354978 | 28354978 | PRJNA255848_P_NODE_42046_length_164_cov_0.886957_g41728_i0 | PRJNA255848 | 42046 | 164 | 0.886957 | 1.45460948 | Eukaryota | 2759 | Plants | Plants | 109 | 4.49e-26 | NR | RZC75482.1 | 3469 | g41728 | i0 | 98.1 | 657.823170731707 | 54 | 1 | 98.8 | 0 | 163 | 2 | 245 | 298 | RZC75482.1 hypothetical protein C5167_050971 [Papaver somniferum] | diamond | 107883 | 110 | 0.990909090909091 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 28463756 | 28463756 | PRJNA255848_P_NODE_27666_length_189_cov_1.457143_g27348_i0 | PRJNA255848 | 27666 | 189 | 1.457143 | 2.75400027 | Fraxinus pennsylvanica | 56036 | Plants | Plants | 124 | 1.26e-32 | NR | CAI9777652.1 | 56036 | g27348 | i0 | 95.2 | 0.984126984126984 | 62 | 3 | 98.4 | 0 | 2 | 187 | 253 | 314 | CAI9777652.1 unnamed protein product [Fraxinus pennsylvanica] | diamond | 186 | 124 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Fraxinus | Fraxinus pennsylvanica | |
| 28923258 | 28923258 | PRJNA255848_P_NODE_33008_length_172_cov_2.065041_g32690_i0 | PRJNA255848 | 33008 | 172 | 2.065041 | 3.55187052 | Eukaryota | 2759 | Plants | Plants | 126 | 4.9e-36 | NR | KAG0582699.1 | 3225 | g32690 | i0 | 98.2 | 559.343023255814 | 56 | 1 | 97.7 | 0 | 170 | 3 | 33 | 88 | KAG0582699.1 hypothetical protein KC19_3G078100 [Ceratodon purpureus] | diamond | 96207 | 127 | 0.992125984251969 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 29081333 | 29081333 | PRJNA255848_P_NODE_46468_length_161_cov_1.821429_g46150_i0 | PRJNA255848 | 46468 | 161 | 1.821429 | 2.93250069 | Magnoliopsida | 3398 | Plants | Plants | 45.8 | 9.97e-4 | NR | PPD73807.1 | 3634 | g46150 | i0 | 63.6 | 1.69565217391304 | 33 | 12 | 61.5 | 0 | 156 | 58 | 425 | 457 | PPD73807.1 hypothetical protein GOBAR_DD29264 [Gossypium barbadense] | diamond | 273 | 45.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Gossypium | Gossypium barbadense | |
| 29680827 | 29680827 | PRJNA255848_P_NODE_25350_length_198_cov_1.026846_g25032_i0 | PRJNA255848 | 25350 | 198 | 1.026846 | 2.03315508 | root | 1 | Root_unresolved | Root_unresolved | 120 | 2.28e-33 | NR | XP_021895162.1 | 3649 | g25032 | i0 | 96.9 | 322.015151515152 | 65 | 2 | 98.5 | 0 | 3 | 197 | 37 | 101 | XP_021895162.1 probable histone H2A variant 3 [Carica papaya] | diamond | 63759 | 121 | 0.991735537190083 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Caricaceae | Carica | Carica papaya | |
| 29870618 | 29870618 | PRJNA255848_P_NODE_32491_length_174_cov_1.408000_g32173_i0 | PRJNA255848 | 32491 | 174 | 1.408 | 2.44992 | root | 1 | Root_unresolved | Root_unresolved | 110 | 2.12e-29 | NR | KAH9761975.1 | 2711 | g32173 | i0 | 98.3 | 401 | 58 | 1 | 100 | 0 | 1 | 174 | 38 | 95 | KAH9761975.1 putative histone H2A variant 3 [Citrus sinensis] | diamond | 69774 | 111 | 0.990990990990991 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 29884632 | 29884632 | PRJNA255848_P_NODE_11531_length_302_cov_1.071146_g11213_i0 | PRJNA255848 | 11531 | 302 | 1.071146 | 3.23486092 | Dillenia turbinata | 194707 | Plants | Plants | 43.5 | 0.0374 | NR | KAK6915059.1 | 194707 | g11213 | i0 | 31.3 | 0.635761589403974 | 64 | 41 | 63.6 | 1 | 85 | 276 | 140 | 200 | KAK6915059.1 Fatty acid desaturase domain [Dillenia turbinata] | diamond | 192 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Dilleniales | Dilleniaceae | Dillenia | Dillenia turbinata | |
| 29933973 | 29933973 | PRJNA255848_P_NODE_29931_length_182_cov_1.150376_g29613_i0 | PRJNA255848 | 29931 | 182 | 1.150376 | 2.09368432 | root | 1 | Root_unresolved | Root_unresolved | 52 | 8.8e-6 | NR | KAH9771515.1 | 2711 | g29613 | i0 | 100 | 174.016483516484 | 24 | 0 | 39.6 | 0 | 2 | 73 | 370 | 393 | KAH9771515.1 eukaryotic initiation factor 4A-III [Citrus sinensis] | diamond | 31671 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Sapindales | Rutaceae | Citrus | Citrus sinensis | |
| 29965470 | 29965470 | PRJNA255848_P_NODE_40171_length_165_cov_0.879310_g39853_i0 | PRJNA255848 | 40171 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | Plants | Plants | 87 | 2.58e-19 | NR | KAG0588237.1 | 3225 | g39853 | i0 | 83.6 | 41.9454545454545 | 55 | 9 | 100 | 0 | 1 | 165 | 120 | 174 | KAG0588237.1 hypothetical protein KC19_2G227900 [Ceratodon purpureus] | diamond | 6921 | 87 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Pseudoditrichales | Ditrichaceae | Ceratodon | Ceratodon purpureus | |
| 30281746 | 30281746 | PRJNA255848_P_NODE_47092_length_161_cov_0.910714_g46774_i0 | PRJNA255848 | 47092 | 161 | 0.910714 | 1.46624954 | Eukaryota | 2759 | Plants | Plants | 45.1 | 0.00189 | NR | KAJ3678193.1 | 13579 | g46774 | i0 | 38.5 | 4.28571428571429 | 52 | 32 | 96.9 | 0 | 157 | 2 | 213 | 264 | KAJ3678193.1 hypothetical protein LUZ60_001996 [Juncus effusus] | diamond | 690 | 45.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 31369838 | 31369838 | PRJNA255848_P_NODE_29236_length_184_cov_1.133333_g28918_i0 | PRJNA255848 | 29236 | 184 | 1.133333 | 2.08533272 | Linum trigynum | 586398 | Plants | Plants | 56.2 | 5.27e-8 | NR | CAL1366671.1 | 586398 | g28918 | i0 | 73 | 12.6684782608696 | 37 | 10 | 60.3 | 0 | 182 | 72 | 86 | 122 | CAL1366671.1 unnamed protein product [Linum trigynum] | diamond | 2331 | 56.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Linaceae | Linum | Linum trigynum | |
| 31938818 | 31938818 | PRJNA255848_P_NODE_11197_length_307_cov_1.976744_g10879_i0 | PRJNA255848 | 11197 | 307 | 1.976744 | 6.06860408 | Nicotiana tomentosiformis | 4098 | Plants | Plants | 43.5 | 0.0224 | NR | XP_070057319.1 | 4098 | g10879 | i0 | 35.9 | 0.625407166123778 | 64 | 40 | 62.5 | 1 | 105 | 296 | 104 | 166 | XP_070057319.1 uncharacterized protein [Nicotiana tomentosiformis] | diamond | 192 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Nicotiana | Nicotiana tomentosiformis | |
| 32255757 | 32255757 | PRJNA255848_P_NODE_12298_length_290_cov_1.269710_g11980_i0 | PRJNA255848 | 12298 | 290 | 1.26971 | 3.682159 | Adiantum nelumboides | 2759587 | Plants | Plants | 46.2 | 0.00382 | NR | MCO5602264.1 | 2759587 | g11980 | i0 | 43.6 | 1.70689655172414 | 55 | 28 | 53.8 | 1 | 50 | 205 | 172 | 226 | MCO5602264.1 hypothetical protein [Adiantum nelumboides] | diamond | 495 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Polypodiopsida | Polypodiales | Pteridaceae | Adiantum | Adiantum nelumboides |
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);;