contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_clade = "core chlorophytes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 769088 | 769088 | PRJNA788929_P_NODE_15161_length_432_cov_10.727019_g14502_i0 | PRJNA788929 | 15161 | 432 | 10.727019 | 46.34072208 | Raphidocelis subcapitata | 307507 | Plants | Plants | 157 | 5.34e-46 | NR | GBF93448.1 | 307507 | g14502 | i0 | 66.1 | 37.7222222222222 | 118 | 37 | 79.9 | 1 | 374 | 30 | 42 | 159 | GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata] | diamond | 16296 | 157 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 2045035 | 2045035 | PRJNA788929_P_NODE_15022_length_434_cov_39.426593_g14363_i0 | PRJNA788929 | 15022 | 434 | 39.426593 | 171.11141362 | Eukaryota | 2759 | Plants | Plants | 119 | 1.66e-29 | NR | CAD7701259.1 | 121088 | g14363 | i0 | 62.9 | 3.03456221198157 | 89 | 32 | 61.5 | 1 | 21 | 287 | 188 | 275 | CAD7701259.1 unnamed protein product [Ostreobium quekettii] | diamond | 1317 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 2045640 | 2045640 | PRJNA788929_P_NODE_6542_length_746_cov_25.011887_g5921_i0 | PRJNA788929 | 6542 | 746 | 25.011887 | 186.58867702 | Eukaryota | 2759 | Plants | Plants | 199 | 1.01e-60 | NR | XP_011399223.1 | 3075 | g5921 | i0 | 51 | 11.6018766756032 | 192 | 94 | 77.2 | 0 | 33 | 608 | 1 | 192 | XP_011399223.1 60S ribosomal protein L9 [Auxenochlorella protothecoides] | diamond | 8655 | 199 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 3320339 | 3320339 | PRJNA788929_P_NODE_12503_length_489_cov_20.723558_g11846_i0 | PRJNA788929 | 12503 | 489 | 20.723558 | 101.33819862 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 102 | 1.13e-24 | NR | CAG9460866.1 | 765719 | g11846 | i0 | 46.8 | 0.865030674846626 | 141 | 56 | 86.5 | 2 | 33 | 455 | 1 | 122 | CAG9460866.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 423 | 102 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 12249299 | 12249299 | PRJNA788929_P_NODE_930_length_2065_cov_10.487450_g802_i0 | PRJNA788929 | 930 | 2065 | 10.48745 | 216.5658425 | Prototheca wickerhamii | 3111 | Plants | Plants | 1064 | 0 | NR | KAK2075861.1 | 3111 | g802 | i0 | 99.5 | 0.796125907990315 | 548 | 3 | 79.6 | 0 | 1947 | 304 | 1 | 548 | KAK2075861.1 hypothetical protein QBZ16_001602 [Prototheca wickerhamii] | diamond | 1644 | 1064 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 16071683 | 16071683 | PRJNA788929_P_NODE_1993_length_1492_cov_21.278365_g1737_i0 | PRJNA788929 | 1993 | 1492 | 21.278365 | 317.4732058 | Prototheca wickerhamii | 3111 | Plants | Plants | 783 | 3.57e-284 | NR | KAK2080578.1 | 3111 | g1737 | i0 | 99.7 | 0.739946380697051 | 368 | 1 | 74 | 0 | 1373 | 270 | 1 | 368 | KAK2080578.1 hypothetical protein QBZ16_000432 [Prototheca wickerhamii] | diamond | 1104 | 783 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 21172168 | 21172168 | PRJNA788929_P_NODE_4897_length_905_cov_45.746394_g4333_i0 | PRJNA788929 | 4897 | 905 | 45.746394 | 414.0048657 | Eukaryota | 2759 | Plants | Plants | 361 | 2.44e-122 | NR | PRW39386.1 | 3076 | g4333 | i0 | 72.8 | 5.82762430939226 | 250 | 66 | 82.2 | 1 | 829 | 86 | 1 | 250 | PRW39386.1 40S ribosomal S3a-2 isoform B [Chlorella sorokiniana] | diamond | 5274 | 361 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 26999491 | 26999491 | PRJNA788929_P_NODE_8962_length_609_cov_36.050373_g8312_i0 | PRJNA788929 | 8962 | 609 | 36.050373 | 219.54677157 | Trebouxiales | 2507901 | Plants | Plants | 105 | 4.35e-25 | NR | XP_005645013.1 | 574566 | g8312 | i0 | 85.5 | 0.541871921182266 | 55 | 8 | 27.1 | 0 | 24 | 188 | 76 | 130 | XP_005645013.1 ribosomal protein S15a component of cytosolic 80S ribosome and 40S small subunit [Coccomyxa subellipsoidea C-169] | diamond | 330 | 106 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27496170 | 27496170 | PRJNA788929_P_NODE_47883_length_211_cov_14.913043_g47222_i0 | PRJNA788929 | 47883 | 211 | 14.913043 | 31.46652073 | Ulva flexuosa | 83791 | Plants | Plants | 87.8 | 3.16e-18 | NR | AZP40192.1 | 83791 | g47222 | i0 | 62.5 | 0.909952606635071 | 64 | 24 | 91 | 0 | 15 | 206 | 166 | 229 | AZP40192.1 hypothetical protein [Ulva flexuosa] | diamond | 192 | 87.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva flexuosa | |
| 27780391 | 27780391 | PRJNA788929_P_NODE_17764_length_392_cov_23.037618_g17104_i0 | PRJNA788929 | 17764 | 392 | 23.037618 | 90.30746256 | Apatococcus lobatus | 904363 | Plants | Plants | 88.2 | 6.4e-18 | NR | KAK9817581.1 | 904363 | g17104 | i0 | 57.8 | 0.948979591836735 | 64 | 27 | 49 | 0 | 369 | 178 | 245 | 308 | KAK9817581.1 hypothetical protein WJX74_002359 [Apatococcus lobatus] | diamond | 372 | 88.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 27978893 | 27978893 | PRJNA788929_P_NODE_17525_length_395_cov_28.360248_g16865_i0 | PRJNA788929 | 17525 | 395 | 28.360248 | 112.0229796 | Trebouxia | 13786 | Plants | Plants | 68.9 | 3.09e-11 | NR | KAL0037326.1 | 2905654 | g16865 | i0 | 50.6 | 2.96962025316456 | 77 | 35 | 58.5 | 2 | 381 | 151 | 140 | 213 | KAL0037326.1 hypothetical protein WJX79_002217 [Trebouxia sp. C0005] | diamond | 1173 | 68.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 28001459 | 28001459 | PRJNA788929_P_NODE_11905_length_505_cov_26.884259_g11249_i0 | PRJNA788929 | 11905 | 505 | 26.884259 | 135.76550795 | Prototheca wickerhamii | 3111 | Plants | Plants | 182 | 4.179999999999999e-55 | NR | KAK2077127.1 | 3111 | g11249 | i0 | 95.2 | 0.617821782178218 | 104 | 0 | 58.8 | 2 | 383 | 87 | 1 | 104 | KAK2077127.1 hypothetical protein QBZ16_004761 [Prototheca wickerhamii] | diamond | 312 | 182 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28948732 | 28948732 | PRJNA788929_P_NODE_4368_length_970_cov_22.907469_g3856_i0 | PRJNA788929 | 4368 | 970 | 22.907469 | 222.2024493 | Edaphochlamys debaryana | 47281 | Plants | Plants | 222 | 2.14e-65 | NR | KAG2485882.1 | 47281 | g3856 | i0 | 55 | 1.08865979381443 | 171 | 77 | 52.9 | 0 | 94 | 606 | 161 | 331 | KAG2485882.1 hypothetical protein HYH03_015465 [Edaphochlamys debaryana] | diamond | 1056 | 222 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 28980265 | 28980265 | PRJNA788929_P_NODE_9468_length_587_cov_10.807393_g8816_i0 | PRJNA788929 | 9468 | 587 | 10.807393 | 63.43939691 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 113 | 1.62e-26 | NR | KAG2441235.1 | 2026947 | g8816 | i0 | 41 | 0.710391822827939 | 139 | 79 | 69.5 | 1 | 577 | 170 | 100 | 238 | KAG2441235.1 hypothetical protein HYH02_010078 [Chlamydomonas schloesseri] | diamond | 417 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri | |
| 29138187 | 29138187 | PRJNA788929_P_NODE_13849_length_458_cov_19.488312_g13191_i0 | PRJNA788929 | 13849 | 458 | 19.488312 | 89.25646896 | Coccomyxa viridis | 1274662 | Plants | Plants | 45.4 | 0.0163 | NR | CAK0780326.1 | 1274662 | g13191 | i0 | 47.3 | 0.96943231441048 | 55 | 29 | 36 | 0 | 111 | 275 | 109 | 163 | CAK0780326.1 hypothetical protein CVIRNUC_005013 [Coccomyxa viridis] | diamond | 444 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 29273262 | 29273262 | PRJNA788929_P_NODE_15629_length_424_cov_25.532764_g14970_i0 | PRJNA788929 | 15629 | 424 | 25.532764 | 108.25891936 | Trebouxiophyceae | 75966 | Plants | Plants | 80.9 | 1.31e-14 | NR | KAK2079618.1 | 3111 | g14970 | i0 | 59.8 | 5.625 | 82 | 26 | 53.1 | 3 | 413 | 189 | 1005 | 1086 | KAK2079618.1 hypothetical protein QBZ16_002013 [Prototheca wickerhamii] | diamond | 2385 | 81.6 | 0.991421568627451 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29548209 | 29548209 | PRJNA788929_P_NODE_16730_length_407_cov_41.664671_g16071_i0 | PRJNA788929 | 16730 | 407 | 41.664671 | 169.57521097 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 59.3 | 1.03e-7 | NR | KAG7673152.1 | 1650286 | g16071 | i0 | 52.1 | 2.10810810810811 | 71 | 28 | 50.1 | 3 | 384 | 181 | 119 | 186 | KAG7673152.1 hypothetical protein KSW81_006366 [Chlorella desiccata (nom. nud.)] | diamond | 858 | 59.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 29620313 | 29620313 | PRJNA788929_P_NODE_44110_length_233_cov_13.256250_g43449_i0 | PRJNA788929 | 44110 | 233 | 13.25625 | 30.8870625 | Coccomyxa | 41891 | Plants | Plants | 53.9 | 3.58e-6 | NR | KAK9917143.1 | 248742 | g43449 | i0 | 54.9 | 3.93991416309013 | 51 | 21 | 65.7 | 1 | 200 | 48 | 90 | 138 | KAK9917143.1 hypothetical protein WJX75_001268 [Coccomyxa subellipsoidea] | diamond | 918 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 29737587 | 29737587 | PRJNA788929_P_NODE_2010_length_1483_cov_22.135461_g1753_i0 | PRJNA788929 | 2010 | 1483 | 22.135461 | 328.26888663 | Prototheca wickerhamii | 3111 | Plants | Plants | 611 | 2.58e-217 | NR | KAK2080631.1 | 3111 | g1753 | i0 | 92 | 0.679703304113284 | 336 | 6 | 68 | 1 | 244 | 1251 | 1 | 315 | KAK2080631.1 hypothetical protein QBZ16_000485 [Prototheca wickerhamii] | diamond | 1008 | 611 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 29936649 | 29936649 | PRJNA788929_P_NODE_17871_length_391_cov_12.849057_g17211_i0 | PRJNA788929 | 17871 | 391 | 12.849057 | 50.23981287 | Chlorophyta | 3041 | Plants | Plants | 119 | 3.4499999999999995e-32 | NR | XP_011395717.1 | 3075 | g17211 | i0 | 71.1 | 5.25575447570333 | 76 | 22 | 58.3 | 0 | 71 | 298 | 1 | 76 | XP_011395717.1 40S ribosomal protein S21 [Auxenochlorella protothecoides] | diamond | 2055 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30085190 | 30085190 | PRJNA788929_P_NODE_29752_length_289_cov_26.004630_g29091_i0 | PRJNA788929 | 29752 | 289 | 26.00463 | 75.1533807 | Ostreobium quekettii | 121088 | Plants | Plants | 113 | 1.7000000000000002e-27 | NR | CAD7695328.1 | 121088 | g29091 | i0 | 54 | 0.903114186851211 | 87 | 40 | 90.3 | 0 | 266 | 6 | 303 | 389 | CAD7695328.1 unnamed protein product [Ostreobium quekettii] | diamond | 261 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 30116778 | 30116778 | PRJNA788929_P_NODE_28032_length_299_cov_63.008850_g27371_i0 | PRJNA788929 | 28032 | 299 | 63.00885 | 188.3964615 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 45.1 | 0.0113 | NR | CAG9463377.1 | 765719 | g27371 | i0 | 47.6 | 0.421404682274247 | 42 | 21 | 42.1 | 1 | 35 | 160 | 733 | 773 | CAG9463377.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 126 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 31896174 | 31896174 | PRJNA788929_P_NODE_35517_length_260_cov_15.850267_g34856_i0 | PRJNA788929 | 35517 | 260 | 15.850267 | 41.2106942 | Eukaryota | 2759 | Plants | Plants | 82 | 5.6e-18 | NR | PRW57963.1 | 3076 | g34856 | i0 | 58 | 2.31923076923077 | 69 | 29 | 79.6 | 0 | 249 | 43 | 40 | 108 | PRW57963.1 Thioredoxin H-type [Chlorella sorokiniana] | diamond | 603 | 82.4 | 0.995145631067961 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 32583198 | 32583198 | PRJNA788929_P_NODE_3439_length_1115_cov_24.928983_g3024_i0 | PRJNA788929 | 3439 | 1115 | 24.928983 | 277.95816045 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 306 | 6.189999999999998e-96 | NR | GMH43207.1 | 3041901 | g3024 | i0 | 42.2 | 3.43318385650224 | 422 | 139 | 88.5 | 3 | 10 | 996 | 135 | 544 | GMH43207.1 hypothetical protein BSKO_11129 [Bryopsis sp. KO-2023] | diamond | 3828 | 306 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 32834829 | 32834829 | PRJNA788929_P_NODE_21660_length_349_cov_22.079710_g20999_i0 | PRJNA788929 | 21660 | 349 | 22.07971 | 77.0581879 | Symbiochloris irregularis | 706552 | Plants | Plants | 74.7 | 1.7e-13 | NR | KAK9808539.1 | 706552 | g20999 | i0 | 60.7 | 1.4269340974212 | 56 | 22 | 48.1 | 0 | 325 | 158 | 178 | 233 | KAK9808539.1 hypothetical protein WJX73_006377 [Symbiochloris irregularis] | diamond | 498 | 74.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis |
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);;