contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA763243" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4571905 | 4571905 | PRJNA763243_P_NODE_51564_length_251_cov_1.988764_g51218_i0 | PRJNA763243 | 51564 | 251 | 1.988764 | 4.99179764 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 139 | 5e-37 | NR | KAH7624923.1 | 1650286 | g51218 | i0 | 72 | 10.7808764940239 | 82 | 23 | 98 | 0 | 248 | 3 | 261 | 342 | KAH7624923.1 putative Elongation factor 1-alpha [Chlorella desiccata (nom. nud.)] | diamond | 2706 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 7122309 | 7122309 | PRJNA763243_P_NODE_54066_length_249_cov_0.875000_g53720_i0 | PRJNA763243 | 54066 | 249 | 0.875 | 2.17875 | Chlorophyta | 3041 | Plants | Plants | 140 | 4.06e-41 | NR | CAD7703134.1 | 121088 | g53720 | i0 | 84 | 18.5421686746988 | 81 | 13 | 97.6 | 0 | 245 | 3 | 15 | 95 | CAD7703134.1 unnamed protein product [Ostreobium quekettii] | diamond | 4617 | 141 | 0.99290780141844 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 7583228 | 7583228 | PRJNA763243_P_NODE_34806_length_291_cov_1.986239_g34460_i0 | PRJNA763243 | 34806 | 291 | 1.986239 | 5.77995549 | Raphidocelis subcapitata | 307507 | Plants | Plants | 127 | 3.07e-35 | NR | GBF93448.1 | 307507 | g34460 | i0 | 71.3 | 2.63917525773196 | 94 | 23 | 96.9 | 2 | 282 | 1 | 37 | 126 | GBF93448.1 ribosomal protein S1 [Raphidocelis subcapitata] | diamond | 768 | 127 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 10947212 | 10947212 | PRJNA763243_P_NODE_32449_length_299_cov_2.982301_g32103_i0 | PRJNA763243 | 32449 | 299 | 2.982301 | 8.91707999 | Eukaryota | 2759 | Plants | Plants | 133 | 9.24e-34 | NR | PRW32884.1 | 3076 | g32103 | i0 | 83.1 | 27.622073578595305 | 83 | 14 | 83.3 | 0 | 4 | 252 | 43 | 125 | PRW32884.1 Histone H2A [Chlorella sorokiniana] | diamond | 8259 | 134 | 0.992537313432836 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 13497089 | 13497089 | PRJNA763243_P_NODE_43291_length_269_cov_1.413265_g42945_i0 | PRJNA763243 | 43291 | 269 | 1.413265 | 3.80168285 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 139 | 1.4799999999999999e-40 | NR | KAL4446784.1 | 554058 | g42945 | i0 | 75.6 | 4.817843866171 | 86 | 21 | 95.9 | 0 | 11 | 268 | 10 | 95 | KAL4446784.1 hypothetical protein ABPG77_008028 [Micractinium sp. CCAP 211/92] | diamond | 1296 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 26895169 | 26895169 | PRJNA763243_P_NODE_39181_length_279_cov_1.407767_g38835_i0 | PRJNA763243 | 39181 | 279 | 1.407767 | 3.92766993 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 106 | 1.32e-25 | NR | KAG1673219.1 | 1653778 | g38835 | i0 | 67.6 | 67.0752688172043 | 71 | 23 | 76.3 | 0 | 275 | 63 | 187 | 257 | KAG1673219.1 hypothetical protein FOA52_013099 [Chlamydomonas sp. UWO 241] | diamond | 18714 | 106 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 26926604 | 26926604 | PRJNA763243_P_NODE_34802_length_291_cov_2.022936_g34456_i0 | PRJNA763243 | 34802 | 291 | 2.022936 | 5.88674376 | [Myrmecia] bisecta | 41462 | Plants | Plants | 143 | 1.8e-37 | NR | KAK9817796.1 | 41462 | g34456 | i0 | 76.9 | 0.938144329896907 | 91 | 21 | 93.8 | 0 | 5 | 277 | 542 | 632 | KAK9817796.1 hypothetical protein WJX72_002302 [[Myrmecia] bisecta] | diamond | 273 | 143 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 26989663 | 26989663 | PRJNA763243_P_NODE_50082_length_254_cov_1.701657_g49736_i0 | PRJNA763243 | 50082 | 254 | 1.701657 | 4.32220878 | Chlorella variabilis | 554065 | Plants | Plants | 70.1 | 8.2e-12 | NR | XP_005851542.1 | 554065 | g49736 | i0 | 47.1 | 0.803149606299213 | 68 | 35 | 80.3 | 1 | 249 | 46 | 87 | 153 | XP_005851542.1 hypothetical protein CHLNCDRAFT_33886 [Chlorella variabilis] | diamond | 204 | 70.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 27473657 | 27473657 | PRJNA763243_P_NODE_38623_length_280_cov_4.144928_g38277_i0 | PRJNA763243 | 38623 | 280 | 4.144928 | 11.6057984 | root | 1 | Root_unresolved | Root_unresolved | 126 | 2.55e-33 | NR | GAX80767.1 | 1157962 | g38277 | i0 | 65.1 | 1.81071428571429 | 86 | 30 | 92.1 | 0 | 276 | 19 | 195 | 280 | GAX80767.1 hypothetical protein CEUSTIGMA_g8202.t1 [Chlamydomonas eustigma] | diamond | 507 | 126 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28032439 | 28032439 | PRJNA763243_P_NODE_41805_length_272_cov_3.668342_g41459_i0 | PRJNA763243 | 41805 | 272 | 3.668342 | 9.97789024 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 58.5 | 1.39e-7 | NR | KAL4451794.1 | 2728915 | g41459 | i0 | 58.5 | 1.16911764705882 | 53 | 22 | 58.5 | 0 | 186 | 28 | 357 | 409 | KAL4451794.1 hypothetical protein ABPG75_007456 [Micractinium tetrahymenae] | diamond | 318 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 28095438 | 28095438 | PRJNA763243_P_NODE_40985_length_274_cov_3.960199_g40639_i0 | PRJNA763243 | 40985 | 274 | 3.960199 | 10.85094526 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 161 | 2.13e-45 | NR | GAX78472.1 | 1157962 | g40639 | i0 | 86.4 | 1.93795620437956 | 88 | 12 | 96.4 | 0 | 5 | 268 | 113 | 200 | GAX78472.1 hypothetical protein CEUSTIGMA_g5911.t1 [Chlamydomonas eustigma] | diamond | 531 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 28389217 | 28389217 | PRJNA763243_P_NODE_67726_length_229_cov_3.737179_g67380_i0 | PRJNA763243 | 67726 | 229 | 3.737179 | 8.55813991 | Chlamydomonadales | 3042 | Plants | Plants | 77.8 | 3.42e-16 | NR | PNH07330.1 | 47790 | g67380 | i0 | 56.8 | 5.81659388646288 | 74 | 30 | 95.6 | 2 | 226 | 8 | 17 | 89 | PNH07330.1 40S ribosomal protein S6 [Tetrabaena socialis] | diamond | 1332 | 78.2 | 0.994884910485933 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 28705118 | 28705118 | PRJNA763243_P_NODE_39267_length_279_cov_1.033981_g38921_i0 | PRJNA763243 | 39267 | 279 | 1.033981 | 2.88480699 | Eukaryota | 2759 | Plants | Plants | 119 | 7.95e-29 | NR | XP_005844200.1 | 554065 | g38921 | i0 | 66 | 4.0215053763440904 | 94 | 28 | 96.8 | 1 | 6 | 275 | 338 | 431 | XP_005844200.1 hypothetical protein CHLNCDRAFT_59028 [Chlorella variabilis] | diamond | 1122 | 120 | 0.991666666666667 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 29263508 | 29263508 | PRJNA763243_P_NODE_51909_length_251_cov_0.865169_g51563_i0 | PRJNA763243 | 51909 | 251 | 0.865169 | 2.17157419 | [Myrmecia] bisecta | 41462 | Plants | Plants | 46.6 | 0.0018600000000000001 | NR | KAK9803301.1 | 41462 | g51563 | i0 | 45.7 | 0.549800796812749 | 46 | 23 | 52.6 | 1 | 77 | 208 | 200 | 245 | KAK9803301.1 hypothetical protein WJX72_010340 [[Myrmecia] bisecta] | diamond | 138 | 46.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 29831986 | 29831986 | PRJNA763243_P_NODE_27791_length_311_cov_1.281513_g27445_i0 | PRJNA763243 | 27791 | 311 | 1.281513 | 3.98550543 | Symbiochloris irregularis | 706552 | Plants | Plants | 107 | 4.669999999999999e-28 | NR | KAK9808445.1 | 706552 | g27445 | i0 | 64.8 | 5.03536977491961 | 71 | 25 | 68.5 | 0 | 10 | 222 | 20 | 90 | KAK9808445.1 hypothetical protein WJX73_006634 [Symbiochloris irregularis] | diamond | 1566 | 107 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 30284414 | 30284414 | PRJNA763243_P_NODE_51892_length_251_cov_0.865169_g51546_i0 | PRJNA763243 | 51892 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | Plants | Plants | 97.1 | 3.21e-21 | NR | RMZ56488.1 | 3075 | g51546 | i0 | 56.8 | 2.83266932270916 | 81 | 35 | 96.8 | 0 | 249 | 7 | 442 | 522 | RMZ56488.1 hypothetical protein APUTEX25_001335 [Auxenochlorella protothecoides] | diamond | 711 | 97.4 | 0.996919917864476 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30558475 | 30558475 | PRJNA763243_P_NODE_30253_length_308_cov_3.093617_g29907_i0 | PRJNA763243 | 30253 | 308 | 3.093617 | 9.52834036 | Coccomyxa sp. Obi | 2315456 | Plants | Plants | 65.1 | 1.17e-9 | NR | BDA51182.1 | 2315456 | g29907 | i0 | 47.5 | 0.574675324675325 | 59 | 31 | 57.5 | 0 | 304 | 128 | 166 | 224 | BDA51182.1 Xanthine dehydrogenase [Coccomyxa sp. Obi] | diamond | 177 | 65.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa sp. Obi | ||
| 30590226 | 30590226 | PRJNA763243_P_NODE_62213_length_242_cov_0.911243_g61867_i0 | PRJNA763243 | 62213 | 242 | 0.911243 | 2.20520806 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 52.4 | 1.52e-5 | NR | KAF8059687.1 | 2742167 | g61867 | i0 | 53.5 | 0.533057851239669 | 43 | 20 | 53.3 | 0 | 239 | 111 | 212 | 254 | KAF8059687.1 yciC [Scenedesmus sp. PABB004] | diamond | 129 | 52.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 30916090 | 30916090 | PRJNA763243_P_NODE_65234_length_237_cov_3.780488_g64888_i0 | PRJNA763243 | 65234 | 237 | 3.780488 | 8.95975656 | Eukaryota | 2759 | Plants | Plants | 55.1 | 3.11e-7 | NR | PRW34016.1 | 3076 | g64888 | i0 | 79.3 | 6.24050632911392 | 29 | 6 | 36.7 | 0 | 235 | 149 | 115 | 143 | PRW34016.1 60S ribosomal L23A [Chlorella sorokiniana] | diamond | 1479 | 55.5 | 0.992792792792793 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31854741 | 31854741 | PRJNA763243_P_NODE_41817_length_272_cov_3.140704_g41471_i0 | PRJNA763243 | 41817 | 272 | 3.140704 | 8.54271488 | Monoraphidium neglectum | 145388 | Plants | Plants | 91.7 | 1.05e-20 | NR | XP_013899290.1 | 145388 | g41471 | i0 | 56.6 | 0.838235294117647 | 76 | 33 | 83.8 | 0 | 269 | 42 | 117 | 192 | XP_013899290.1 hypothetical protein MNEG_7690 [Monoraphidium neglectum] | diamond | 228 | 91.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 32424385 | 32424385 | PRJNA763243_P_NODE_59359_length_244_cov_2.099415_g59013_i0 | PRJNA763243 | 59359 | 244 | 2.099415 | 5.1225726 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 44.7 | 0.0079 | NR | KAI8104682.1 | 2696299 | g59013 | i0 | 48.9 | 0.55327868852459 | 45 | 23 | 55.3 | 0 | 143 | 9 | 666 | 710 | KAI8104682.1 hypothetical protein M9434_003235 [Picochlorum sp. BPE23] | diamond | 135 | 44.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 | |||
| 32654732 | 32654732 | PRJNA763243_P_NODE_56440_length_247_cov_0.885057_g56094_i0 | PRJNA763243 | 56440 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | Plants | Plants | 84.7 | 6.61e-17 | NR | KAK9804037.1 | 706552 | g56094 | i0 | 46.5 | 2.04048582995951 | 86 | 42 | 99.6 | 2 | 246 | 1 | 290 | 375 | KAK9804037.1 hypothetical protein WJX73_006346 [Symbiochloris irregularis] | diamond | 504 | 84.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);;