contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA1200128" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16904104 | 16904104 | PRJNA1200128_S_NODE_13474_length_230_cov_1.475936_g13365_i0 | PRJNA1200128 | 13474 | 230 | 1.475936 | 3.3946528 | Salix dunnii | 1413687 | Plants | Plants | 90.1 | 2.6500000000000003e-21 | NR | KAF9683045.1 | 1413687 | g13365 | i0 | 93.3 | 1.18695652173913 | 45 | 3 | 58.7 | 0 | 229 | 95 | 68 | 112 | KAF9683045.1 hypothetical protein SADUNF_Sadunf05G0171300 [Salix dunnii] | diamond | 273 | 90.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malpighiales | Salicaceae | Salix | Salix dunnii | |
| 16904235 | 16904235 | PRJNA1200128_S_NODE_43434_length_157_cov_1.649123_g43325_i0 | PRJNA1200128 | 43434 | 157 | 1.649123 | 2.58912311 | Quercus rubra | 3512 | Plants | Plants | 100 | 2.62e-25 | NR | KAK4595688.1 | 3512 | g43325 | i0 | 100 | 0.993630573248408 | 52 | 0 | 99.4 | 0 | 157 | 2 | 117 | 168 | KAK4595688.1 hypothetical protein RGQ29_013965 [Quercus rubra] | diamond | 156 | 100 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 26597437 | 26597437 | PRJNA1200128_S_NODE_4601_length_326_cov_1.381625_g4492_i0 | PRJNA1200128 | 4601 | 326 | 1.381625 | 4.5040975 | Tanacetum cinerariifolium | 118510 | Plants | Plants | 43.1 | 0.0357 | NR | GEZ90847.1 | 118510 | g4492 | i0 | 34.8 | 0.819018404907976 | 89 | 47 | 73.6 | 2 | 65 | 304 | 14 | 100 | GEZ90847.1 hypothetical protein [Tanacetum cinerariifolium] | diamond | 267 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Tanacetum | Tanacetum cinerariifolium | |
| 26882895 | 26882895 | PRJNA1200128_S_NODE_12561_length_235_cov_1.468750_g12452_i0 | PRJNA1200128 | 12561 | 235 | 1.46875 | 3.4515625 | Castanea mollissima | 60419 | Plants | Plants | 65.9 | 3.71e-12 | NR | KAF3949630.1 | 60419 | g12452 | i0 | 100 | 0.382978723404255 | 30 | 0 | 38.3 | 0 | 233 | 144 | 44 | 73 | KAF3949630.1 hypothetical protein CMV_024525 [Castanea mollissima] | diamond | 90 | 65.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Castanea | Castanea mollissima | |
| 26882897 | 26882897 | PRJNA1200128_S_NODE_49721_length_150_cov_1.757009_g49612_i0 | PRJNA1200128 | 49721 | 150 | 1.757009 | 2.6355135 | Taxus chinensis | 29808 | Plants | Plants | 43.5 | 0.00554 | NR | KAH9322403.1 | 29808 | g49612 | i0 | 58 | 1 | 50 | 11 | 98 | 2 | 148 | 2 | 3 | 43 | KAH9322403.1 hypothetical protein KI387_017042 [Taxus chinensis] | diamond | 150 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Taxaceae | Taxus | Taxus chinensis | |
| 27135358 | 27135358 | PRJNA1200128_S_NODE_8922_length_262_cov_2.374429_g8813_i0 | PRJNA1200128 | 8922 | 262 | 2.374429 | 6.22100398 | Quercus rubra | 3512 | Plants | Plants | 109 | 2.32e-29 | NR | KAK4589130.1 | 3512 | g8813 | i0 | 100 | 0.618320610687023 | 54 | 0 | 61.8 | 0 | 262 | 101 | 19 | 72 | KAK4589130.1 hypothetical protein RGQ29_019925 [Quercus rubra] | diamond | 162 | 109 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 28462403 | 28462403 | PRJNA1200128_S_NODE_19206_length_206_cov_1.478528_g19097_i0 | PRJNA1200128 | 19206 | 206 | 1.478528 | 3.04576768 | Cryptomeria japonica | 3369 | Plants | Plants | 64.3 | 7.81e-11 | NR | GLJ22179.1 | 3369 | g19097 | i0 | 83.3 | 1.03398058252427 | 36 | 6 | 52.4 | 0 | 206 | 99 | 125 | 160 | GLJ22179.1 hypothetical protein SUGI_0416730 [Cryptomeria japonica] | diamond | 213 | 64.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Pinopsida | Cupressales | Cupressaceae | Cryptomeria | Cryptomeria japonica | |
| 28557030 | 28557030 | PRJNA1200128_S_NODE_37947_length_165_cov_1.155738_g37838_i0 | PRJNA1200128 | 37947 | 165 | 1.155738 | 1.9069677 | Setaria italica | 4555 | Plants | Plants | 42.4 | 0.0184 | NR | RCV45198.1 | 4555 | g37838 | i0 | 46.5 | 0.781818181818182 | 43 | 23 | 78.2 | 0 | 28 | 156 | 137 | 179 | RCV45198.1 hypothetical protein SETIT_9G434200v2 [Setaria italica] | diamond | 129 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Setaria | Setaria italica | |
| 28967499 | 28967499 | PRJNA1200128_S_NODE_28488_length_182_cov_1.014388_g28379_i0 | PRJNA1200128 | 28488 | 182 | 1.014388 | 1.84618616 | Quercus rubra | 3512 | Plants | Plants | 81.6 | 2.51e-17 | NR | KAK4607538.1 | 3512 | g28379 | i0 | 100 | 0.626373626373626 | 38 | 0 | 62.6 | 0 | 21 | 134 | 165 | 202 | KAK4607538.1 hypothetical protein RGQ29_001401 [Quercus rubra] | diamond | 114 | 81.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 29093807 | 29093807 | PRJNA1200128_S_NODE_16928_length_214_cov_1.923977_g16819_i0 | PRJNA1200128 | 16928 | 214 | 1.923977 | 4.11731078 | Lithocarpus litseifolius | 425828 | Plants | Plants | 90.1 | 1.57e-20 | NR | KAK9987412.1 | 425828 | g16819 | i0 | 87.5 | 0.672897196261682 | 48 | 6 | 67.3 | 0 | 145 | 2 | 10 | 57 | KAK9987412.1 hypothetical protein SO802_032363 [Lithocarpus litseifolius] | diamond | 144 | 90.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Lithocarpus | Lithocarpus litseifolius | |
| 29851567 | 29851567 | PRJNA1200128_S_NODE_19591_length_205_cov_1.160494_g19482_i0 | PRJNA1200128 | 19591 | 205 | 1.160494 | 2.3790127 | Quercus rubra | 3512 | Plants | Plants | 49.7 | 6.76e-6 | NR | KAK4598255.1 | 3512 | g19482 | i0 | 100 | 0.292682926829268 | 20 | 0 | 29.3 | 0 | 205 | 146 | 57 | 76 | KAK4598255.1 hypothetical protein RGQ29_015648 [Quercus rubra] | diamond | 60 | 49.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 29977731 | 29977731 | PRJNA1200128_S_NODE_36051_length_168_cov_1.128000_g35942_i0 | PRJNA1200128 | 36051 | 168 | 1.128 | 1.89504 | Cornus florida | 4283 | Plants | Plants | 91.3 | 8.73e-22 | NR | XP_059664433.1 | 4283 | g35942 | i0 | 72.7 | 15.3571428571429 | 55 | 15 | 98.2 | 0 | 2 | 166 | 83 | 137 | XP_059664433.1 uncharacterized protein LOC132310260 [Cornus florida] | diamond | 2580 | 91.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Cornaceae | Cornus | Cornus florida | |
| 30420474 | 30420474 | PRJNA1200128_S_NODE_17353_length_212_cov_12.284024_g17244_i0 | PRJNA1200128 | 17353 | 212 | 12.284024 | 26.04213088 | Smallanthus sonchifolius | 185202 | Plants | Plants | 42.4 | 0.0343 | NR | KAI3821849.1 | 185202 | g17244 | i0 | 38.9 | 0.764150943396226 | 54 | 31 | 73.6 | 1 | 4 | 159 | 130 | 183 | KAI3821849.1 hypothetical protein L1987_09423 [Smallanthus sonchifolius] | diamond | 162 | 42.4 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Smallanthus | Smallanthus sonchifolius | |
| 30849721 | 30849721 | PRJNA1200128_S_NODE_10314_length_250_cov_1.816425_g10205_i0 | PRJNA1200128 | 10314 | 250 | 1.816425 | 4.5410625 | Musaceae | 4637 | Plants | Plants | 49.3 | 1.83e-4 | NR | RRT35435.1 | 4639 | g10205 | i0 | 54.3 | 2.076 | 46 | 19 | 52.8 | 1 | 234 | 103 | 38 | 83 | RRT35435.1 hypothetical protein B296_00059037 [Ensete ventricosum] | diamond | 519 | 49.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Zingiberales | Musaceae | Ensete | Ensete ventricosum | |
| 31431391 | 31431391 | PRJNA1200128_S_NODE_23216_length_194_cov_23.549669_g23107_i0 | PRJNA1200128 | 23216 | 194 | 23.549669 | 45.68635786 | Rhododendron molle | 49168 | Plants | Plants | 43.1 | 0.0145 | NR | KAI8537824.1 | 49168 | g23107 | i0 | 42.6 | 0.72680412371134 | 47 | 25 | 69.6 | 1 | 48 | 182 | 748 | 794 | KAI8537824.1 hypothetical protein RHMOL_Rhmol09G0053700 [Rhododendron molle] | diamond | 141 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Ericaceae | Rhododendron | Rhododendron molle | |
| 31747629 | 31747629 | PRJNA1200128_S_NODE_15497_length_220_cov_1.327684_g15388_i0 | PRJNA1200128 | 15497 | 220 | 1.327684 | 2.9209048 | Quercus rubra | 3512 | Plants | Plants | 101 | 2.3599999999999997e-25 | NR | KAK4594628.1 | 3512 | g15388 | i0 | 100 | 0.654545454545455 | 48 | 0 | 65.5 | 0 | 2 | 145 | 112 | 159 | KAK4594628.1 hypothetical protein RGQ29_018349 [Quercus rubra] | diamond | 144 | 101 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 31811008 | 31811008 | PRJNA1200128_S_NODE_38637_length_164_cov_1.165289_g38528_i0 | PRJNA1200128 | 38637 | 164 | 1.165289 | 1.91107396 | Quercus rubra | 3512 | Plants | Plants | 56.6 | 3.89e-9 | NR | KAK4581221.1 | 3512 | g38528 | i0 | 75 | 0.658536585365854 | 36 | 8 | 65.9 | 1 | 2 | 109 | 10 | 44 | KAK4581221.1 hypothetical protein RGQ29_024765 [Quercus rubra] | diamond | 108 | 56.6 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 31811009 | 31811009 | PRJNA1200128_S_NODE_43397_length_157_cov_1.736842_g43288_i0 | PRJNA1200128 | 43397 | 157 | 1.736842 | 2.72684194 | Actinidia rufa | 165716 | Plants | Plants | 40 | 0.0232 | NR | GFS41052.1 | 165716 | g43288 | i0 | 41.2 | 0.64968152866242 | 34 | 20 | 65 | 0 | 109 | 8 | 36 | 69 | GFS41052.1 hypothetical protein Acr_00g0071950 [Actinidia rufa] | diamond | 102 | 40 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Ericales | Actinidiaceae | Actinidia | Actinidia rufa | |
| 31874182 | 31874182 | PRJNA1200128_S_NODE_2397_length_426_cov_3.744125_g2289_i0 | PRJNA1200128 | 2397 | 426 | 3.744125 | 15.9499725 | Quercus rubra | 3512 | Plants | Plants | 178 | 3.879999999999999e-55 | NR | KAK4591631.1 | 3512 | g2289 | i0 | 100 | 1.02816901408451 | 73 | 0 | 51.4 | 0 | 2 | 220 | 33 | 105 | KAK4591631.1 hypothetical protein RGQ29_016171 [Quercus rubra] | diamond | 438 | 178 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 32190729 | 32190729 | PRJNA1200128_S_NODE_19218_length_206_cov_1.441718_g19109_i0 | PRJNA1200128 | 19218 | 206 | 1.441718 | 2.96993908 | Quercus lobata | 97700 | Plants | Plants | 105 | 1.35e-24 | NR | XP_030958647.1 | 97700 | g19109 | i0 | 71.4 | 0.91747572815534 | 63 | 18 | 91.7 | 0 | 17 | 205 | 300 | 362 | XP_030958647.1 uncharacterized protein LOC115980554 [Quercus lobata] | diamond | 189 | 105 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus lobata | |
| 32254270 | 32254270 | PRJNA1200128_S_NODE_21238_length_200_cov_1.496815_g21129_i0 | PRJNA1200128 | 21238 | 200 | 1.496815 | 2.99363 | Lithocarpus litseifolius | 425828 | Plants | Plants | 139 | 1.25e-40 | NR | KAL0004350.1 | 425828 | g21129 | i0 | 95.5 | 0.99 | 66 | 3 | 99 | 0 | 1 | 198 | 59 | 124 | KAL0004350.1 hypothetical protein SO802_011911 [Lithocarpus litseifolius] | diamond | 198 | 139 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Lithocarpus | Lithocarpus litseifolius | |
| 32285900 | 32285900 | PRJNA1200128_S_NODE_4459_length_329_cov_2.202797_g4350_i0 | PRJNA1200128 | 4459 | 329 | 2.202797 | 7.24720213 | Quercus rubra | 3512 | Plants | Plants | 85.1 | 2.93e-18 | NR | KAK4594626.1 | 3512 | g4350 | i0 | 100 | 0.364741641337386 | 40 | 0 | 36.5 | 0 | 327 | 208 | 120 | 159 | KAK4594626.1 hypothetical protein RGQ29_018347 [Quercus rubra] | diamond | 120 | 85.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus rubra | |
| 32444066 | 32444066 | PRJNA1200128_S_NODE_11279_length_243_cov_2.525000_g11170_i0 | PRJNA1200128 | 11279 | 243 | 2.525 | 6.13575 | Juglans microcarpa x Juglans regia | 2249226 | Plants | Plants | 43.1 | 0.0272 | NR | XP_041021201.1 | 2249226 | g11170 | i0 | 36.5 | 0.777777777777778 | 63 | 31 | 66.7 | 4 | 197 | 36 | 421 | 483 | XP_041021201.1 ETO1-like protein 1 isoform X1 [Juglans microcarpa x Juglans regia] | diamond | 189 | 43.1 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Juglandaceae | Juglans | Juglans microcarpa x Juglans regia | |
| 32696178 | 32696178 | PRJNA1200128_S_NODE_5440_length_307_cov_3.204545_g5331_i0 | PRJNA1200128 | 5440 | 307 | 3.204545 | 9.83795315 | Quercus suber | 58331 | Plants | Plants | 75.9 | 1.29e-15 | NR | KAK7819442.1 | 58331 | g5331 | i0 | 88.4 | 0.420195439739414 | 43 | 5 | 42 | 0 | 306 | 178 | 20 | 62 | KAK7819442.1 hypothetical protein CFP56_040279 [Quercus suber] | diamond | 129 | 75.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fagales | Fagaceae | Quercus | Quercus suber |
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);;