contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1249042" and tax_phylum = "Streptophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14383446 | 14383446 | PRJNA1249042_S_NODE_24772_length_252_cov_2.923445_g24558_i0 | PRJNA1249042 | 24772 | 252 | 2.923445 | 7.3670814 | Eukaryota | 2759 | Plants | Plants | 156 | 2.52e-46 | NR | KAJ8606111.1 | 3435 | g24558 | i0 | 88 | 9.86904761904762 | 83 | 10 | 98.8 | 0 | 2 | 250 | 104 | 186 | KAJ8606111.1 hypothetical protein MRB53_041187 [Persea americana] | diamond | 2487 | 157 | 0.993630573248408 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Persea | Persea americana | |
| 27344780 | 27344780 | PRJNA1249042_S_NODE_105803_length_157_cov_2.052632_g105589_i0 | PRJNA1249042 | 105803 | 157 | 2.052632 | 3.22263224 | Magnoliopsida | 3398 | Plants | Plants | 41.6 | 0.0307 | NR | XP_026413298.1 | 3469 | g105589 | i0 | 48.7 | 2.23566878980892 | 39 | 19 | 74.5 | 1 | 19 | 135 | 439 | 476 | XP_026413298.1 ferredoxin-dependent glutamate synthase, chloroplastic-like [Papaver somniferum] | diamond | 351 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver somniferum | |
| 27547591 | 27547591 | PRJNA1249042_S_NODE_8784_length_319_cov_3.065217_g8570_i0 | PRJNA1249042 | 8784 | 319 | 3.065217 | 9.77804223 | Ensete ventricosum | 4639 | Plants | Plants | 43.1 | 0.0148 | NR | RZR78371.1 | 4639 | g8570 | i0 | 47.7 | 0.413793103448276 | 44 | 23 | 41.4 | 0 | 165 | 296 | 6 | 49 | RZR78371.1 hypothetical protein BHM03_00003660 [Ensete ventricosum] | diamond | 132 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Ensete | Ensete ventricosum | |
| 27674079 | 27674079 | PRJNA1249042_S_NODE_68344_length_189_cov_1.931507_g68130_i0 | PRJNA1249042 | 68344 | 189 | 1.931507 | 3.65054823 | Canavalia gladiata | 3824 | Plants | Plants | 40.8 | 0.0174 | NR | KAK7339161.1 | 3824 | g68130 | i0 | 45 | 0.634920634920635 | 40 | 18 | 57.1 | 1 | 39 | 146 | 33 | 72 | KAK7339161.1 hypothetical protein VNO77_19812 [Canavalia gladiata] | diamond | 120 | 40.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Canavalia | Canavalia gladiata | |
| 28242043 | 28242043 | PRJNA1249042_S_NODE_31226_length_239_cov_1.821429_g31012_i0 | PRJNA1249042 | 31226 | 239 | 1.821429 | 4.35321531 | Forsythia ovata | 205694 | Plants | Plants | 42 | 0.0397 | NR | KAL2548042.1 | 205694 | g31012 | i0 | 48.9 | 0.564853556485356 | 45 | 14 | 54 | 2 | 2 | 130 | 29 | 66 | KAL2548042.1 Rapid ALkalinization Factor [Forsythia ovata] | diamond | 135 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Forsythia | Forsythia ovata | |
| 28526585 | 28526585 | PRJNA1249042_S_NODE_45427_length_216_cov_2.173410_g45213_i0 | PRJNA1249042 | 45427 | 216 | 2.17341 | 4.6945656 | Sesamum indicum | 4182 | Plants | Plants | 42 | 0.0483 | NR | XP_011078350.1 | 4182 | g45213 | i0 | 39.1 | 1.11111111111111 | 46 | 28 | 63.9 | 0 | 34 | 171 | 49 | 94 | XP_011078350.1 trihelix transcription factor ASIL2 [Sesamum indicum] | diamond | 240 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Pedaliaceae | Sesamum | Sesamum indicum | |
| 28810201 | 28810201 | PRJNA1249042_S_NODE_110668_length_154_cov_1.297297_g110454_i0 | PRJNA1249042 | 110668 | 154 | 1.297297 | 1.99783738 | Paulownia fortunei | 586722 | Plants | Plants | 47.8 | 1.45e-5 | NR | KAI3444993.1 | 586722 | g110454 | i0 | 84 | 0.487012987012987 | 25 | 4 | 48.7 | 0 | 144 | 70 | 38 | 62 | KAI3444993.1 hypothetical protein Pfo_001658 [Paulownia fortunei] | diamond | 75 | 47.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Paulowniaceae | Paulownia | Paulownia fortunei | |
| 29189610 | 29189610 | PRJNA1249042_S_NODE_59449_length_199_cov_0.903846_g59235_i0 | PRJNA1249042 | 59449 | 199 | 0.903846 | 1.79865354 | Oryza sativa | 4530 | Plants | Plants | 41.2 | 0.0181 | NR | KAB8110131.1 | 4530 | g59235 | i0 | 31.6 | 0.85929648241206 | 57 | 39 | 85.9 | 0 | 180 | 10 | 1 | 57 | KAB8110131.1 hypothetical protein EE612_047063, partial [Oryza sativa] | diamond | 171 | 41.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 29410354 | 29410354 | PRJNA1249042_S_NODE_13889_length_286_cov_3.238683_g13675_i0 | PRJNA1249042 | 13889 | 286 | 3.238683 | 9.26263338 | Solanum lycopersicum | 4081 | Plants | Plants | 47.4 | 3.31e-4 | NR | AYE66860.1 | 4081 | g13675 | i0 | 52 | 0.524475524475524 | 50 | 24 | 52.4 | 0 | 123 | 272 | 27 | 76 | AYE66860.1 hypothetical protein, partial [Solanum lycopersicum] | diamond | 150 | 47.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum lycopersicum | |
| 29505087 | 29505087 | PRJNA1249042_S_NODE_61690_length_196_cov_2.150327_g61476_i0 | PRJNA1249042 | 61690 | 196 | 2.150327 | 4.21464092 | Iris pallida | 29817 | Plants | Plants | 42.4 | 0.00559 | NR | KAJ6839550.1 | 29817 | g61476 | i0 | 36.8 | 0.872448979591837 | 57 | 36 | 87.2 | 0 | 20 | 190 | 9 | 65 | KAJ6839550.1 DEAD-box ATP-dependent RNA helicase 50 [Iris pallida] | diamond | 171 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asparagales | Iridaceae | Iris | Iris pallida | |
| 29568246 | 29568246 | PRJNA1249042_S_NODE_19090_length_267_cov_2.098214_g18876_i0 | PRJNA1249042 | 19090 | 267 | 2.098214 | 5.60223138 | Olax retusa | 3049601 | Plants | Plants | 45.1 | 0.00632 | NR | WHU54996.1 | 3049601 | g18876 | i0 | 31.6 | 0.853932584269663 | 76 | 46 | 79.8 | 2 | 17 | 229 | 26 | 100 | WHU54996.1 maturase K, partial [Olax retusa] | diamond | 228 | 45.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Santalales | Olacaceae | Olax | Olax retusa | |
| 29631174 | 29631174 | PRJNA1249042_S_NODE_11790_length_297_cov_1.846457_g11576_i0 | PRJNA1249042 | 11790 | 297 | 1.846457 | 5.48397729 | Brassica oleracea | 3712 | Plants | Plants | 46.2 | 0.0015 | NR | VDD33108.1 | 3712 | g11576 | i0 | 28.4 | 0.676767676767677 | 67 | 47 | 66.7 | 1 | 233 | 36 | 65 | 131 | VDD33108.1 unnamed protein product [Brassica oleracea] | diamond | 201 | 46.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Brassica | Brassica oleracea | |
| 29662665 | 29662665 | PRJNA1249042_S_NODE_77290_length_180_cov_2.970803_g77076_i0 | PRJNA1249042 | 77290 | 180 | 2.970803 | 5.3474454 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 41.6 | 0.0416 | NR | GEY37002.1 | 118510 | g77076 | i0 | 38.8 | 0.816666666666667 | 49 | 30 | 81.7 | 0 | 155 | 9 | 1299 | 1347 | GEY37002.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 147 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 29978876 | 29978876 | PRJNA1249042_S_NODE_37171_length_228_cov_3.378378_g36957_i0 | PRJNA1249042 | 37171 | 228 | 3.378378 | 7.70270184 | Vicia villosa | 3911 | Plants | Plants | 43.9 | 0.0116 | NR | XP_058777183.1 | 3911 | g36957 | i0 | 35.8 | 2.11842105263158 | 53 | 27 | 69.7 | 2 | 62 | 220 | 351 | 396 | XP_058777183.1 uncharacterized protein LOC131651517 [Vicia villosa] | diamond | 483 | 43.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vicia | Vicia villosa | |
| 30295222 | 30295222 | PRJNA1249042_S_NODE_22192_length_258_cov_3.279070_g21978_i0 | PRJNA1249042 | 22192 | 258 | 3.27907 | 8.4600006 | Papaver nudicaule | 74823 | Plants | Plants | 43.5 | 0.0241 | NR | MCL7045203.1 | 74823 | g21978 | i0 | 59.3 | 0.313953488372093 | 27 | 11 | 31.4 | 0 | 111 | 31 | 351 | 377 | MCL7045203.1 hypothetical protein [Papaver nudicaule] | diamond | 81 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ranunculales | Papaveraceae | Papaver | Papaver nudicaule | |
| 30642222 | 30642222 | PRJNA1249042_S_NODE_57433_length_201_cov_1.784810_g57219_i0 | PRJNA1249042 | 57433 | 201 | 1.78481 | 3.5874681 | Amborella trichopoda | 13333 | Plants | Plants | 41.6 | 0.016 | NR | KAL4193179.1 | 13333 | g57219 | i0 | 40 | 0.597014925373134 | 40 | 24 | 59.7 | 0 | 125 | 6 | 29 | 68 | KAL4193179.1 hypothetical protein AMTRI_Chr06g175640 [Amborella trichopoda] | diamond | 120 | 41.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Amborellales | Amborellaceae | Amborella | Amborella trichopoda | |
| 30863473 | 30863473 | PRJNA1249042_S_NODE_71254_length_186_cov_1.979021_g71040_i0 | PRJNA1249042 | 71254 | 186 | 1.979021 | 3.68097906 | Buddleja alternifolia | 168488 | Plants | Plants | 40 | 0.0439 | NR | KAG8389312.1 | 168488 | g71040 | i0 | 72.7 | 0.354838709677419 | 22 | 6 | 35.5 | 0 | 184 | 119 | 72 | 93 | KAG8389312.1 hypothetical protein BUALT_Bualt02G0216300 [Buddleja alternifolia] | diamond | 66 | 40 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Scrophulariaceae | Buddleja | Buddleja alternifolia | |
| 31116058 | 31116058 | PRJNA1249042_S_NODE_51075_length_208_cov_4.563636_g50861_i0 | PRJNA1249042 | 51075 | 208 | 4.563636 | 9.49236288 | Carnegiea gigantea | 171969 | Plants | Plants | 92.8 | 2.0200000000000003e-21 | NR | KAJ8449012.1 | 171969 | g50861 | i0 | 65.2 | 7.58653846153846 | 66 | 23 | 95.2 | 0 | 206 | 9 | 130 | 195 | KAJ8449012.1 hypothetical protein Cgig2_004067 [Carnegiea gigantea] | diamond | 1578 | 92.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Cactaceae | Carnegiea | Carnegiea gigantea | |
| 31369476 | 31369476 | PRJNA1249042_S_NODE_77936_length_180_cov_1.372263_g77722_i0 | PRJNA1249042 | 77936 | 180 | 1.372263 | 2.4700734 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 40.8 | 0.0372 | NR | GFB84751.1 | 118510 | g77722 | i0 | 45.7 | 0.583333333333333 | 35 | 19 | 58.3 | 0 | 151 | 47 | 6 | 40 | GFB84751.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 105 | 40.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 32286971 | 32286971 | PRJNA1249042_S_NODE_37639_length_228_cov_1.010811_g37425_i0 | PRJNA1249042 | 37639 | 228 | 1.010811 | 2.30464908 | Rhynchospora pubera | 906938 | Plants | Plants | 44.3 | 0.00904 | NR | KAJ4768641.1 | 906938 | g37425 | i0 | 41.2 | 0.671052631578947 | 51 | 30 | 67.1 | 0 | 189 | 37 | 81 | 131 | KAJ4768641.1 Heat shock 70 kDa protein [Rhynchospora pubera] | diamond | 153 | 44.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Cyperaceae | Rhynchospora | Rhynchospora pubera | |
| 32318606 | 32318606 | PRJNA1249042_S_NODE_42619_length_220_cov_1.971751_g42405_i0 | PRJNA1249042 | 42619 | 220 | 1.971751 | 4.3378522 | Parasponia andersonii | 3476 | Plants | Plants | 60.5 | 3.24e-9 | NR | PON41366.1 | 3476 | g42405 | i0 | 90 | 0.409090909090909 | 30 | 3 | 40.9 | 0 | 1 | 90 | 137 | 166 | PON41366.1 Pollen allergen Ole e 1 family [Parasponia andersonii] | diamond | 90 | 60.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Parasponia | Parasponia andersonii | |
| 32413330 | 32413330 | PRJNA1249042_S_NODE_34439_length_233_cov_2.226316_g34225_i0 | PRJNA1249042 | 34439 | 233 | 2.226316 | 5.18731628 | Bienertia sinuspersici | 338654 | Plants | Plants | 42 | 0.0208 | NR | KAL2930801.1 | 338654 | g34225 | i0 | 40.4 | 1.46781115879828 | 57 | 34 | 73.4 | 0 | 16 | 186 | 13 | 69 | KAL2930801.1 polyprotein [Bienertia sinuspersici] | diamond | 342 | 42 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Chenopodiaceae | Bienertia | Bienertia sinuspersici | |
| 32413339 | 32413339 | PRJNA1249042_S_NODE_83899_length_174_cov_2.564885_g83685_i0 | PRJNA1249042 | 83899 | 174 | 2.564885 | 4.4628999 | Fraxinus pennsylvanica | 56036 | Plants | Plants | 74.7 | 6.85e-14 | NR | CAI9781093.1 | 56036 | g83685 | i0 | 100 | 0.551724137931034 | 32 | 0 | 55.2 | 0 | 172 | 77 | 374 | 405 | CAI9781093.1 unnamed protein product [Fraxinus pennsylvanica] | diamond | 96 | 74.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Lamiales | Oleaceae | Fraxinus | Fraxinus pennsylvanica | |
| 32445096 | 32445096 | PRJNA1249042_S_NODE_62579_length_195_cov_2.164474_g62365_i0 | PRJNA1249042 | 62579 | 195 | 2.164474 | 4.2207243 | Cryptomeria japonica | 3369 | Plants | Plants | 47 | 6.27e-4 | NR | XP_059070522.1 | 3369 | g62365 | i0 | 55.8 | 0.661538461538462 | 43 | 19 | 66.2 | 0 | 63 | 191 | 815 | 857 | XP_059070522.1 uncharacterized protein LOC131040138 [Cryptomeria japonica] | diamond | 129 | 47 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica |
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);;