contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA849172" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2112113 | 2112113 | PRJNA849172_P_NODE_54182_length_289_cov_1.222222_g53822_i0 | PRJNA849172 | 54182 | 289 | 1.222222 | 3.53222158 | Trebouxia | 13786 | Plants | Plants | 159 | 7.61e-43 | NR | KAL0033422.1 | 2905653 | g53822 | i0 | 96.4 | 2.6159169550173 | 84 | 3 | 87.2 | 0 | 2 | 253 | 955 | 1038 | KAL0033422.1 hypothetical protein WJX77_008849 [Trebouxia sp. C0004] | diamond | 756 | 159 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0004 | |
| 11039398 | 11039398 | PRJNA849172_P_NODE_229_length_3290_cov_22.350948_g210_i0 | PRJNA849172 | 229 | 3290 | 22.350948 | 735.3461892 | Trebouxia | 13786 | Plants | Plants | 452 | 1.0299999999999996e-143 | NR | KAL0055962.1 | 2905655 | g210 | i0 | 52.3 | 1.20364741641337 | 434 | 195 | 39.4 | 3 | 267 | 1562 | 15 | 438 | KAL0055962.1 hypothetical protein WJX82_006218 [Trebouxia sp. C0006] | diamond | 3960 | 455 | 0.993406593406593 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 | |
| 18687132 | 18687132 | PRJNA849172_P_NODE_28555_length_383_cov_21.096774_g28196_i0 | PRJNA849172 | 28555 | 383 | 21.096774 | 80.80064442 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 149 | 3.57e-41 | NR | GAX81966.1 | 1157962 | g28196 | i0 | 67.3 | 3.33681462140992 | 107 | 30 | 82.2 | 2 | 316 | 2 | 204 | 307 | GAX81966.1 hypothetical protein CEUSTIGMA_g9394.t1 [Chlamydomonas eustigma] | diamond | 1278 | 149 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 20358251 | 20358251 | PRJNA849172_P_NODE_10956_length_644_cov_11.457093_g10604_i0 | PRJNA849172 | 10956 | 644 | 11.457093 | 73.78367892 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 199 | 1.0699999999999995e-55 | NR | KAL4514472.1 | 1650286 | g10604 | i0 | 72.5 | 4.12267080745342 | 138 | 38 | 64.3 | 0 | 1 | 414 | 615 | 752 | KAL4514472.1 hypothetical protein Ndes2526A_g03942 [Chlorella desiccata (nom. nud.)] | diamond | 2655 | 199 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 27655279 | 27655279 | PRJNA849172_P_NODE_133764_length_215_cov_11.936620_g133404_i0 | PRJNA849172 | 133764 | 215 | 11.93662 | 25.663733 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 53.9 | 7.17e-7 | NR | KAG1677435.1 | 1653778 | g133404 | i0 | 72.2 | 1.0046511627907 | 36 | 10 | 50.2 | 0 | 3 | 110 | 112 | 147 | KAG1677435.1 hypothetical protein FOA52_001890 [Chlamydomonas sp. UWO 241] | diamond | 216 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 28389574 | 28389574 | PRJNA849172_P_NODE_9086_length_718_cov_33.730233_g8742_i0 | PRJNA849172 | 9086 | 718 | 33.730233 | 242.18307294 | Trebouxiales | 2507901 | Plants | Plants | 75.5 | 1.45e-11 | NR | CAL5228944.1 | 1274662 | g8742 | i0 | 71.2 | 0.86908077994429 | 59 | 17 | 24.7 | 0 | 177 | 353 | 846 | 904 | CAL5228944.1 g12175 [Coccomyxa viridis] | diamond | 624 | 75.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 28539370 | 28539370 | PRJNA849172_P_NODE_120607_length_231_cov_4.379747_g120247_i0 | PRJNA849172 | 120607 | 231 | 4.379747 | 10.11721557 | Coccomyxa viridis | 1274662 | Plants | Plants | 65.5 | 2.75e-11 | NR | CAK0783664.1 | 1274662 | g120247 | i0 | 47.5 | 4.06493506493506 | 80 | 36 | 98.7 | 3 | 230 | 3 | 1 | 78 | CAK0783664.1 60S ribosomal protein L36A [Coccomyxa viridis] | diamond | 939 | 65.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 28697211 | 28697211 | PRJNA849172_P_NODE_22747_length_431_cov_11.547486_g22388_i0 | PRJNA849172 | 22747 | 431 | 11.547486 | 49.76966466 | Prototheca wickerhamii | 3111 | Plants | Plants | 187 | 1.5399999999999998e-57 | NR | KAK2079457.1 | 3111 | g22388 | i0 | 70 | 3.54292343387471 | 130 | 38 | 89.8 | 1 | 16 | 402 | 75 | 204 | KAK2079457.1 60S ribosomal protein L15-2 [Prototheca wickerhamii] | diamond | 1527 | 187 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28886389 | 28886389 | PRJNA849172_P_NODE_7968_length_771_cov_23.249284_g7631_i0 | PRJNA849172 | 7968 | 771 | 23.249284 | 179.25197964 | Apatococcus lobatus | 904363 | Plants | Plants | 240 | 2.24e-68 | NR | KAK9818626.1 | 904363 | g7631 | i0 | 81.4 | 0.56420233463035 | 145 | 27 | 56.4 | 0 | 3 | 437 | 2364 | 2508 | KAK9818626.1 hypothetical protein WJX74_004201 [Apatococcus lobatus] | diamond | 435 | 240 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 29517899 | 29517899 | PRJNA849172_P_NODE_61150_length_279_cov_11.922330_g60790_i0 | PRJNA849172 | 61150 | 279 | 11.92233 | 33.2633007 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 79 | 1.83e-16 | NR | XP_005644184.1 | 574566 | g60790 | i0 | 94.3 | 0.752688172043011 | 35 | 2 | 37.6 | 0 | 2 | 106 | 93 | 127 | XP_005644184.1 hypothetical protein COCSUDRAFT_25684 [Coccomyxa subellipsoidea C-169] | diamond | 210 | 79 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 31034579 | 31034579 | PRJNA849172_P_NODE_1235_length_1863_cov_22.570391_g1133_i0 | PRJNA849172 | 1235 | 1863 | 22.570391 | 420.48638433 | Raphidocelis subcapitata | 307507 | Plants | Plants | 68.2 | 6.9e-8 | NR | GBF94470.1 | 307507 | g1133 | i0 | 36 | 0.183574879227053 | 114 | 36 | 12.4 | 2 | 502 | 732 | 108 | 221 | GBF94470.1 hypothetical protein Rsub_07004 [Raphidocelis subcapitata] | diamond | 342 | 68.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 31034615 | 31034615 | PRJNA849172_P_NODE_25515_length_406_cov_28.696697_g25156_i0 | PRJNA849172 | 25515 | 406 | 28.696697 | 116.50858982 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 61.6 | 5.59e-8 | NR | GMH35908.1 | 3041901 | g25156 | i0 | 42.4 | 0.487684729064039 | 66 | 38 | 48.8 | 0 | 34 | 231 | 386 | 451 | GMH35908.1 hypothetical protein BSKO_03776 [Bryopsis sp. KO-2023] | diamond | 198 | 61.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 32362949 | 32362949 | PRJNA849172_P_NODE_11579_length_624_cov_11.911071_g11225_i0 | PRJNA849172 | 11579 | 624 | 11.911071 | 74.32508304 | Volvox reticuliferus | 1737510 | Plants | Plants | 51.6 | 8.8e-4 | NR | GIL87948.1 | 1737510 | g11225 | i0 | 29.1 | 0.990384615384615 | 206 | 72 | 66.8 | 7 | 75 | 491 | 254 | 452 | GIL87948.1 hypothetical protein Vretifemale_15997 [Volvox reticuliferus] | diamond | 618 | 51.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 32678286 | 32678286 | PRJNA849172_P_NODE_108200_length_242_cov_1.822485_g107840_i0 | PRJNA849172 | 108200 | 242 | 1.822485 | 4.4104137 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 67 | 1.03e-10 | NR | KAG1678522.1 | 1653778 | g107840 | i0 | 53.8 | 0.644628099173554 | 52 | 24 | 64.5 | 0 | 85 | 240 | 365 | 416 | KAG1678522.1 hypothetical protein FOA52_014556 [Chlamydomonas sp. UWO 241] | diamond | 156 | 67 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 |
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);;