contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 976894 | 976894 | PRJNA994052_P_NODE_83441_length_197_cov_9.790323_g82184_i0 | PRJNA994052 | 83441 | 197 | 9.790323 | 19.28693631 | Nyssa sinensis | 561372 | Plants | Plants | 78.2 | 6.57e-15 | NR | KAA8539484.1 | 561372 | g82184 | i0 | 51.6 | 3.77664974619289 | 62 | 30 | 94.4 | 0 | 9 | 194 | 844 | 905 | KAA8539484.1 hypothetical protein F0562_026176 [Nyssa sinensis] | diamond | 744 | 78.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Cornales | Nyssaceae | Nyssa | Nyssa sinensis | |
| 26652241 | 26652241 | PRJNA994052_P_NODE_67081_length_216_cov_31.279720_g65825_i0 | PRJNA994052 | 67081 | 216 | 31.27972 | 67.5641952 | Streptophyta | 35493 | Plants | Plants | 92.8 | 6.420000000000001e-21 | NR | XP_024358400.1 | 3218 | g65825 | i0 | 76.5 | 9.44444444444444 | 68 | 12 | 94.4 | 2 | 206 | 3 | 6 | 69 | XP_024358400.1 ribonuclease P protein subunit p25-like protein [Physcomitrium patens] | diamond | 2040 | 93.6 | 0.991452991452991 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Bryopsida | Funariales | Funariaceae | Physcomitrium | Physcomitrium patens | |
| 27279461 | 27279461 | PRJNA994052_P_NODE_79623_length_201_cov_21.500000_g78366_i0 | PRJNA994052 | 79623 | 201 | 21.5 | 43.215 | Stylosanthes scabra | 79078 | Plants | Plants | 96.3 | 8.14e-24 | NR | MED6214258.1 | 79078 | g78366 | i0 | 94.1 | 0.761194029850746 | 51 | 3 | 76.1 | 0 | 154 | 2 | 59 | 109 | MED6214258.1 hypothetical protein [Stylosanthes scabra] | diamond | 153 | 96.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Stylosanthes | Stylosanthes scabra | |
| 27563343 | 27563343 | PRJNA994052_P_NODE_31504_length_278_cov_8.658537_g30260_i0 | PRJNA994052 | 31504 | 278 | 8.658537 | 24.07073286 | Malus baccata | 106549 | Plants | Plants | 42.7 | 0.0404 | NR | TQD84541.1 | 106549 | g30260 | i0 | 44.2 | 0.464028776978417 | 43 | 23 | 46.4 | 1 | 42 | 170 | 151 | 192 | TQD84541.1 hypothetical protein C1H46_029884 [Malus baccata] | diamond | 129 | 42.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Rosaceae | Malus | Malus baccata | |
| 27784854 | 27784854 | PRJNA994052_P_NODE_22464_length_302_cov_103.524017_g21235_i0 | PRJNA994052 | 22464 | 302 | 103.524017 | 312.64253134 | Camelina sativa | 90675 | Plants | Plants | 43.5 | 0.0378 | NR | XP_019096290.1 | 90675 | g21235 | i0 | 38.8 | 0.665562913907285 | 67 | 38 | 66.6 | 1 | 62 | 262 | 70 | 133 | XP_019096290.1 PREDICTED: transcription factor TCP18-like isoform X2 [Camelina sativa] | diamond | 201 | 43.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Brassicales | Brassicaceae | Camelina | Camelina sativa | |
| 28132117 | 28132117 | PRJNA994052_P_NODE_63125_length_221_cov_81.912162_g61869_i0 | PRJNA994052 | 63125 | 221 | 81.912162 | 181.02587802 | Hibiscus sabdariffa | 183260 | Plants | Plants | 63.5 | 1.3e-9 | NR | KAK9029066.1 | 183260 | g61869 | i0 | 58.1 | 8.97285067873303 | 43 | 18 | 58.4 | 0 | 211 | 83 | 784 | 826 | KAK9029066.1 hypothetical protein V6N11_026189 [Hibiscus sabdariffa] | diamond | 1983 | 63.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Malvales | Malvaceae | Hibiscus | Hibiscus sabdariffa | |
| 28573923 | 28573923 | PRJNA994052_P_NODE_30947_length_279_cov_33.373786_g29703_i0 | PRJNA994052 | 30947 | 279 | 33.373786 | 93.11286294 | Solanum tuberosum | 4113 | Plants | Plants | 52 | 3.21e-5 | NR | KAH0771959.1 | 4113 | g29703 | i0 | 31.6 | 1.40860215053763 | 79 | 50 | 80.6 | 2 | 274 | 50 | 89 | 167 | KAH0771959.1 hypothetical protein KY290_015940 [Solanum tuberosum] | diamond | 393 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum tuberosum | |
| 28921150 | 28921150 | PRJNA994052_P_NODE_67688_length_215_cov_65.359155_g66432_i0 | PRJNA994052 | 67688 | 215 | 65.359155 | 140.52218325 | Cinnamomum micranthum f. kanehirae | 337451 | Plants | Plants | 62 | 1.8e-9 | NR | RWR85244.1 | 337451 | g66432 | i0 | 96.4 | 0.390697674418605 | 28 | 1 | 39.1 | 0 | 215 | 132 | 198 | 225 | RWR85244.1 NDR1/HIN1-Like protein 3-like protein [Cinnamomum micranthum f. kanehirae] | diamond | 84 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Laurales | Lauraceae | Cinnamomum | Cinnamomum micranthum | |
| 29047717 | 29047717 | PRJNA994052_P_NODE_13708_length_315_cov_17.272727_g12487_i0 | PRJNA994052 | 13708 | 315 | 17.272727 | 54.40909005 | Bauhinia variegata | 167791 | Plants | Plants | 80.5 | 2.43e-15 | NR | KAI4333518.1 | 167791 | g12487 | i0 | 47.5 | 1.92380952380952 | 99 | 40 | 82.9 | 1 | 2 | 262 | 233 | 331 | KAI4333518.1 hypothetical protein L6164_018312 [Bauhinia variegata] | diamond | 606 | 80.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Bauhinia | Bauhinia variegata | |
| 29300217 | 29300217 | PRJNA994052_P_NODE_78509_length_202_cov_48.860465_g77252_i0 | PRJNA994052 | 78509 | 202 | 48.860465 | 98.6981393 | Solanum commersonii | 4109 | Plants | Plants | 53.9 | 2.52e-6 | NR | KAG5614778.1 | 4109 | g77252 | i0 | 44.8 | 2.16831683168317 | 58 | 32 | 86.1 | 0 | 189 | 16 | 523 | 580 | KAG5614778.1 hypothetical protein H5410_014602 [Solanum commersonii] | diamond | 438 | 53.9 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum commersonii | |
| 29615609 | 29615609 | PRJNA994052_P_NODE_70170_length_212_cov_37.748201_g68914_i0 | PRJNA994052 | 70170 | 212 | 37.748201 | 80.02618612 | Vigna radiata var. radiata | 3916 | Plants | Plants | 68.2 | 6.36e-13 | NR | XP_014508110.1 | 3916 | g68914 | i0 | 55.2 | 3.07075471698113 | 58 | 18 | 70.8 | 1 | 20 | 169 | 38 | 95 | XP_014508110.1 10 kDa chaperonin, mitochondrial [Vigna radiata var. radiata] | diamond | 651 | 68.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Fabales | Fabaceae | Vigna | Vigna radiata | |
| 29710293 | 29710293 | PRJNA994052_P_NODE_17450_length_312_cov_4.937238_g16229_i0 | PRJNA994052 | 17450 | 312 | 4.937238 | 15.40418256 | Anisodus tanguticus | 243964 | Plants | Plants | 73.2 | 1.68e-12 | NR | KAK4337274.1 | 243964 | g16229 | i0 | 68 | 6.70192307692308 | 50 | 16 | 48.1 | 0 | 162 | 311 | 563 | 612 | KAK4337274.1 hypothetical protein RND71_043272 [Anisodus tanguticus] | diamond | 2091 | 73.2 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Anisodus | Anisodus tanguticus | |
| 30215906 | 30215906 | PRJNA994052_P_NODE_66292_length_217_cov_38.173611_g65036_i0 | PRJNA994052 | 66292 | 217 | 38.173611 | 82.83673587 | Klebsormidium nitens | 105231 | Plants | Plants | 55.8 | 6.39e-7 | NR | GAQ82529.1 | 105231 | g65036 | i0 | 45.9 | 2.0184331797235 | 74 | 34 | 95.4 | 4 | 211 | 5 | 468 | 540 | GAQ82529.1 hypothetical protein KFL_001140170 [Klebsormidium nitens] | diamond | 438 | 55.8 | 1 | Eukaryota | Viridiplantae | Streptophyta | Klebsormidiophyceae | Klebsormidiales | Klebsormidiaceae | Klebsormidium | Klebsormidium nitens | ||
| 30406042 | 30406042 | PRJNA994052_P_NODE_21193_length_306_cov_37.412017_g19966_i0 | PRJNA994052 | 21193 | 306 | 37.412017 | 114.48077202 | Oryza sativa Japonica Group | 39947 | Plants | Plants | 54.3 | 6.55e-6 | NR | EEE59534.1 | 39947 | g19966 | i0 | 40.8 | 0.96078431372549 | 49 | 28 | 47.1 | 1 | 158 | 15 | 181 | 229 | EEE59534.1 hypothetical protein OsJ_11799 [Oryza sativa Japonica Group] | diamond | 294 | 54.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Oryza | Oryza sativa | |
| 30942916 | 30942916 | PRJNA994052_P_NODE_49954_length_241_cov_37.214286_g48700_i0 | PRJNA994052 | 49954 | 241 | 37.214286 | 89.68642926 | Solanum tuberosum | 4113 | Plants | Plants | 52 | 1.93e-5 | NR | KAH0765374.1 | 4113 | g48700 | i0 | 52.1 | 0.597510373443983 | 48 | 23 | 59.8 | 0 | 51 | 194 | 192 | 239 | KAH0765374.1 hypothetical protein KY285_001245 [Solanum tuberosum] | diamond | 144 | 52 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Solanales | Solanaceae | Solanum | Solanum tuberosum | |
| 31100599 | 31100599 | PRJNA994052_P_NODE_49915_length_241_cov_46.690476_g48661_i0 | PRJNA994052 | 49915 | 241 | 46.690476 | 112.52404716 | Hordeum vulgare subsp. vulgare | 112509 | Plants | Plants | 62 | 5.88e-9 | NR | BAJ93773.1 | 112509 | g48661 | i0 | 75.7 | 0.460580912863071 | 37 | 9 | 46.1 | 0 | 238 | 128 | 521 | 557 | BAJ93773.1 predicted protein [Hordeum vulgare subsp. vulgare] | diamond | 111 | 62 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Hordeum | Hordeum vulgare | |
| 31163644 | 31163644 | PRJNA994052_P_NODE_42575_length_254_cov_2.729282_g41328_i0 | PRJNA994052 | 42575 | 254 | 2.729282 | 6.93237628 | Triticum turgidum subsp. durum | 4567 | Plants | Plants | 64.7 | 3.12e-10 | NR | VAH14583.1 | 4567 | g41328 | i0 | 57.1 | 3.68503937007874 | 56 | 23 | 65 | 1 | 247 | 83 | 176 | 231 | VAH14583.1 unnamed protein product [Triticum turgidum subsp. durum] | diamond | 936 | 64.7 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum turgidum | |
| 31327855 | 31327855 | PRJNA994052_P_NODE_19235_length_310_cov_35.303797_g18012_i0 | PRJNA994052 | 19235 | 310 | 35.303797 | 109.4417707 | Magnoliopsida | 3398 | Plants | Plants | 64.3 | 2.1e-9 | NR | KAH9603189.1 | 39905 | g18012 | i0 | 51.4 | 4.41290322580645 | 72 | 26 | 61 | 2 | 5 | 193 | 7 | 78 | KAH9603189.1 hypothetical protein KSS87_021909 [Heliosperma pusillum] | diamond | 1368 | 64.3 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Heliosperma | Heliosperma pusillum | |
| 31327858 | 31327858 | PRJNA994052_P_NODE_66615_length_217_cov_6.868056_g65359_i0 | PRJNA994052 | 66615 | 217 | 6.868056 | 14.90368152 | Eukaryota | 2759 | Plants | Plants | 59.3 | 3.44e-8 | NR | KAG9146763.1 | 34254 | g65359 | i0 | 58.2 | 8.6405529953917 | 55 | 23 | 76 | 0 | 51 | 215 | 117 | 171 | KAG9146763.1 hypothetical protein Leryth_005085 [Lithospermum erythrorhizon] | diamond | 1875 | 59.7 | 0.993299832495812 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Boraginales | Boraginaceae | Lithospermum | Lithospermum erythrorhizon | |
| 31391300 | 31391300 | PRJNA994052_P_NODE_33716_length_272_cov_35.226131_g32472_i0 | PRJNA994052 | 33716 | 272 | 35.226131 | 95.81507632 | Magnoliopsida | 3398 | Plants | Plants | 75.5 | 1.03e-13 | NR | KAI3734209.1 | 4217 | g32472 | i0 | 55.4 | 28.5441176470588 | 74 | 8 | 81.6 | 1 | 224 | 3 | 187 | 235 | KAI3734209.1 hypothetical protein L6452_13673 [Arctium lappa] | diamond | 7764 | 75.5 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Asterales | Asteraceae | Arctium | Arctium lappa | |
| 31422798 | 31422798 | PRJNA994052_P_NODE_70136_length_212_cov_42.611511_g68880_i0 | PRJNA994052 | 70136 | 212 | 42.611511 | 90.33640332 | root | 1 | Root_unresolved | Root_unresolved | 47 | 7.23e-4 | NR | KAL3680677.1 | 122646 | g68880 | i0 | 42.9 | 5.88679245283019 | 70 | 33 | 89.2 | 2 | 211 | 23 | 171 | 240 | KAL3680677.1 hypothetical protein R1sor_023633 [Riccia sorocarpa] | diamond | 1248 | 47.4 | 0.991561181434599 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Marchantiopsida | Marchantiales | Ricciaceae | Riccia | Riccia sorocarpa | |
| 31644046 | 31644046 | PRJNA994052_P_NODE_60456_length_225_cov_43.671053_g59200_i0 | PRJNA994052 | 60456 | 225 | 43.671053 | 98.25986925 | Rosales | 3744 | Plants | Plants | 61.6 | 3.01e-10 | NR | PON58107.1 | 3476 | g59200 | i0 | 68.5 | 1.44 | 54 | 11 | 72 | 1 | 9 | 170 | 53 | 100 | PON58107.1 hypothetical protein PanWU01x14_168770 [Parasponia andersonii] | diamond | 324 | 62 | 0.993548387096774 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Rosales | Cannabaceae | Parasponia | Parasponia andersonii | |
| 31833823 | 31833823 | PRJNA994052_P_NODE_35497_length_268_cov_31.025641_g34251_i0 | PRJNA994052 | 35497 | 268 | 31.025641 | 83.14871788 | Poales | 38820 | Plants | Plants | 52.8 | 1.47e-5 | NR | KAJ3680304.1 | 13579 | g34251 | i0 | 39.3 | 2.40671641791045 | 56 | 32 | 60.4 | 1 | 8 | 169 | 415 | 470 | KAJ3680304.1 hypothetical protein LUZ60_016582 [Juncus effusus] | diamond | 645 | 52.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Juncaceae | Juncus | Juncus effusus | |
| 32498633 | 32498633 | PRJNA994052_P_NODE_10899_length_331_cov_80.728682_g9686_i0 | PRJNA994052 | 10899 | 331 | 80.728682 | 267.21193742 | Eukaryota | 2759 | Plants | Plants | 73.2 | 2.07e-12 | NR | KAH9603189.1 | 39905 | g9686 | i0 | 52.6 | 3.70694864048338 | 78 | 36 | 69.8 | 1 | 5 | 235 | 7 | 84 | KAH9603189.1 hypothetical protein KSS87_021909 [Heliosperma pusillum] | diamond | 1227 | 73.6 | 0.994565217391304 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Caryophyllales | Caryophyllaceae | Heliosperma | Heliosperma pusillum | |
| 32618846 | 32618846 | PRJNA994052_P_NODE_68860_length_214_cov_8.843972_g67604_i0 | PRJNA994052 | 68860 | 214 | 8.843972 | 18.92610008 | Triticum aestivum | 4565 | Plants | Plants | 77.8 | 2.94e-16 | NR | XBI40238.1 | 4565 | g67604 | i0 | 76.4 | 0.771028037383178 | 55 | 11 | 77.1 | 1 | 168 | 4 | 41 | 93 | XBI40238.1 hypothetical protein VPH35_124854 [Triticum aestivum] | diamond | 165 | 77.8 | 1 | Eukaryota | Embryophyta | Viridiplantae | Streptophyta | Magnoliopsida | Poales | Poaceae | Triticum | Triticum aestivum |
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);;