contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14409513 | 14409513 | PRJNA315314_S_NODE_11432_length_240_cov_2.668246_g11111_i0 | PRJNA315314 | 11432 | 240 | 2.668246 | 6.4037904 | Eukaryota | 2759 | Plants | Plants | 132 | 1.18e-33 | NR | KAF5842043.1 | 3046 | g11111 | i0 | 82.3 | 10.8625 | 79 | 14 | 98.8 | 0 | 3 | 239 | 500 | 578 | KAF5842043.1 heat shock protein 90 [Dunaliella salina] | diamond | 2607 | 133 | 0.992481203007519 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 18232546 | 18232546 | PRJNA315314_S_NODE_26195_length_164_cov_2.385185_g25874_i0 | PRJNA315314 | 26195 | 164 | 2.385185 | 3.9117034 | Eukaryota | 2759 | Plants | Plants | 101 | 7.74e-24 | NR | KAF5839695.1 | 3046 | g25874 | i0 | 94.4 | 151.115853658537 | 54 | 3 | 98.8 | 0 | 3 | 164 | 134 | 187 | KAF5839695.1 26S proteasome regulatory subunit [Dunaliella salina] | diamond | 24783 | 102 | 0.990196078431373 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 23332981 | 23332981 | PRJNA315314_S_NODE_3279_length_440_cov_9.330900_g2959_i0 | PRJNA315314 | 3279 | 440 | 9.3309 | 41.05596 | Eukaryota | 2759 | Plants | Plants | 203 | 1.41e-63 | NR | XP_011396407.1 | 3075 | g2959 | i0 | 78.9 | 66.3272727272727 | 128 | 27 | 87.3 | 0 | 3 | 386 | 76 | 203 | XP_011396407.1 40S ribosomal protein S5-2 [Auxenochlorella protothecoides] | diamond | 29184 | 203 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 26711733 | 26711733 | PRJNA315314_S_NODE_1301_length_670_cov_6.160686_g1066_i0 | PRJNA315314 | 1301 | 670 | 6.160686 | 41.2765962 | root | 1 | Root_unresolved | Root_unresolved | 210 | 1.99e-62 | NR | KAG2485882.1 | 47281 | g1066 | i0 | 50.5 | 2.55671641791045 | 192 | 91 | 84.2 | 1 | 566 | 3 | 169 | 360 | KAG2485882.1 hypothetical protein HYH03_015465 [Edaphochlamys debaryana] | diamond | 1713 | 212 | 0.990566037735849 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 26807072 | 26807072 | PRJNA315314_S_NODE_27101_length_162_cov_1.353383_g26780_i0 | PRJNA315314 | 27101 | 162 | 1.353383 | 2.19248046 | Monoraphidium | 34111 | Plants | Plants | 60.5 | 4.68e-10 | NR | KAI8469886.1 | 39955 | g26780 | i0 | 61.4 | 2.51851851851852 | 44 | 17 | 81.5 | 0 | 133 | 2 | 41 | 84 | KAI8469886.1 MAG: hypothetical protein J3K34DRAFT_422300 [Monoraphidium minutum] | diamond | 408 | 60.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 26884681 | 26884681 | PRJNA315314_S_NODE_30941_length_153_cov_2.024194_g30620_i0 | PRJNA315314 | 30941 | 153 | 2.024194 | 3.09701682 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 82.8 | 8.01e-17 | NR | XP_011401541.1 | 3075 | g30620 | i0 | 78 | 1.96078431372549 | 50 | 11 | 98 | 0 | 3 | 152 | 490 | 539 | XP_011401541.1 T-complex protein 1 subunit alpha [Auxenochlorella protothecoides] | diamond | 300 | 82.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 26947677 | 26947677 | PRJNA315314_S_NODE_25802_length_165_cov_2.566176_g25481_i0 | PRJNA315314 | 25802 | 165 | 2.566176 | 4.2341904 | Micractinium conductrix | 554055 | Plants | Plants | 86.3 | 5.85e-18 | NR | PSC71066.1 | 554055 | g25481 | i0 | 67.9 | 0.963636363636364 | 53 | 17 | 96.4 | 0 | 163 | 5 | 35 | 87 | PSC71066.1 argonaute 1 isoform A [Micractinium conductrix] | diamond | 159 | 86.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium conductrix | |
| 27990418 | 27990418 | PRJNA315314_S_NODE_14345_length_216_cov_1.721925_g14024_i0 | PRJNA315314 | 14345 | 216 | 1.721925 | 3.719358 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 109 | 7.32e-26 | NR | CAG9462965.1 | 765719 | g14024 | i0 | 77.1 | 3.88888888888889 | 70 | 16 | 97.2 | 0 | 214 | 5 | 409 | 478 | CAG9462965.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 840 | 109 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 28685135 | 28685135 | PRJNA315314_S_NODE_21007_length_181_cov_1.394737_g20686_i0 | PRJNA315314 | 21007 | 181 | 1.394737 | 2.52447397 | Micractinium sp. CCAP 211/92 | 554058 | Plants | Plants | 65.5 | 1.57e-10 | NR | KAL4446209.1 | 554058 | g20686 | i0 | 53.8 | 0.861878453038674 | 52 | 24 | 86.2 | 0 | 2 | 157 | 528 | 579 | KAL4446209.1 hypothetical protein ABPG77_003016 [Micractinium sp. CCAP 211/92] | diamond | 156 | 65.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium sp. CCAP 211/92 | |
| 29253061 | 29253061 | PRJNA315314_S_NODE_5329_length_348_cov_1.423197_g5008_i0 | PRJNA315314 | 5329 | 348 | 1.423197 | 4.95272556 | Sanguina aurantia | 2578422 | Plants | Plants | 62 | 1.19e-9 | NR | MEW5315242.1 | 2578422 | g5008 | i0 | 38.5 | 0.896551724137931 | 104 | 58 | 88.8 | 4 | 2 | 310 | 2 | 100 | MEW5315242.1 hypothetical protein [Sanguina aurantia] | diamond | 312 | 62 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 29284722 | 29284722 | PRJNA315314_S_NODE_4509_length_377_cov_2.528736_g4188_i0 | PRJNA315314 | 4509 | 377 | 2.528736 | 9.53333472 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 58.9 | 3.22e-7 | NR | GMH40151.1 | 3041901 | g4188 | i0 | 37.9 | 1.57559681697613 | 103 | 53 | 80.4 | 4 | 3 | 305 | 284 | 377 | GMH40151.1 hypothetical protein BSKO_08055 [Bryopsis sp. KO-2023] | diamond | 594 | 58.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 29663398 | 29663398 | PRJNA315314_S_NODE_32010_length_151_cov_1.745902_g31689_i0 | PRJNA315314 | 32010 | 151 | 1.745902 | 2.63631202 | Helicosporidium sp. ATCC 5 | 1907511 | Plants | Plants | 52.8 | 2.95e-6 | NR | KDD77018.1 | 1291522 | g31689 | i0 | 52.1 | 1.90728476821192 | 48 | 23 | 95.4 | 0 | 146 | 3 | 172 | 219 | KDD77018.1 hypothetical protein H632_c39p3, partial [Helicosporidium sp. ATCC 50920] | diamond | 288 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Helicosporidium | Helicosporidium sp. ATCC 50920 | |
| 29712438 | 29712438 | PRJNA315314_S_NODE_20690_length_182_cov_2.516340_g20369_i0 | PRJNA315314 | 20690 | 182 | 2.51634 | 4.5797388 | Eukaryota | 2759 | Plants | Plants | 103 | 8.49e-24 | NR | RMZ56549.1 | 3075 | g20369 | i0 | 84.3 | 74.7692307692308 | 51 | 8 | 84.1 | 0 | 29 | 181 | 41 | 91 | RMZ56549.1 hypothetical protein APUTEX25_001396 [Auxenochlorella protothecoides] | diamond | 13608 | 103 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 30074188 | 30074188 | PRJNA315314_S_NODE_26912_length_162_cov_2.616541_g26591_i0 | PRJNA315314 | 26912 | 162 | 2.616541 | 4.23879642 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 74.3 | 1.86e-14 | NR | GAX84228.1 | 1157962 | g26591 | i0 | 64.6 | 0.888888888888889 | 48 | 16 | 88.9 | 1 | 1 | 144 | 100 | 146 | GAX84228.1 hypothetical protein CEUSTIGMA_g11651.t1 [Chlamydomonas eustigma] | diamond | 144 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30327639 | 30327639 | PRJNA315314_S_NODE_8392_length_279_cov_3.908000_g8071_i0 | PRJNA315314 | 8392 | 279 | 3.908 | 10.90332 | Chlorella ohadii | 2649997 | Plants | Plants | 48.1 | 6.89e-4 | NR | KAI7845837.1 | 2649997 | g8071 | i0 | 27.5 | 3.60215053763441 | 91 | 60 | 91.4 | 2 | 9 | 263 | 320 | 410 | KAI7845837.1 hypothetical protein COHA_000747 [Chlorella ohadii] | diamond | 1005 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 30453736 | 30453736 | PRJNA315314_S_NODE_26353_length_164_cov_1.222222_g26032_i0 | PRJNA315314 | 26353 | 164 | 1.222222 | 2.00444408 | Apatococcus lobatus | 904363 | Plants | Plants | 55.5 | 4.12e-7 | NR | KAK9818541.1 | 904363 | g26032 | i0 | 51.8 | 3.42073170731707 | 56 | 20 | 91.5 | 2 | 14 | 163 | 89 | 143 | KAK9818541.1 hypothetical protein WJX74_002024 [Apatococcus lobatus] | diamond | 561 | 55.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Apatococcus | Apatococcus lobatus | |
| 30945046 | 30945046 | PRJNA315314_S_NODE_30934_length_153_cov_2.056452_g30613_i0 | PRJNA315314 | 30934 | 153 | 2.056452 | 3.14637156 | Eukaryota | 2759 | Plants | Plants | 57 | 3.45e-8 | NR | PRW57226.1 | 3076 | g30613 | i0 | 54.2 | 53.6862745098039 | 48 | 22 | 94.1 | 0 | 148 | 5 | 56 | 103 | PRW57226.1 60S ribosomal L18a-2 [Chlorella sorokiniana] | diamond | 8214 | 57 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31749365 | 31749365 | PRJNA315314_S_NODE_27857_length_160_cov_1.335878_g27536_i0 | PRJNA315314 | 27857 | 160 | 1.335878 | 2.1374048 | Chlorella desiccata (nom. nud.) | 1650286 | Plants | Plants | 79 | 5.84e-17 | NR | KAG7672495.1 | 1650286 | g27536 | i0 | 58.8 | 2.94375 | 51 | 21 | 95.6 | 0 | 8 | 160 | 41 | 91 | KAG7672495.1 hypothetical protein KSW81_001459 [Chlorella desiccata (nom. nud.)] | diamond | 471 | 79 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 31893502 | 31893502 | PRJNA315314_S_NODE_6717_length_312_cov_2.943463_g6396_i0 | PRJNA315314 | 6717 | 312 | 2.943463 | 9.18360456 | Eukaryota | 2759 | Plants | Plants | 114 | 2.41e-28 | NR | KAK9815254.1 | 41462 | g6396 | i0 | 82.7 | 8.97115384615385 | 104 | 18 | 100 | 0 | 1 | 312 | 39 | 142 | KAK9815254.1 hypothetical protein WJX72_000717 [[Myrmecia] bisecta] | diamond | 2799 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 32097457 | 32097457 | PRJNA315314_S_NODE_32078_length_151_cov_1.442623_g31757_i0 | PRJNA315314 | 32078 | 151 | 1.442623 | 2.17836073 | Sanguina aurantia | 2578422 | Plants | Plants | 42.4 | 0.0147 | NR | MEW5316514.1 | 2578422 | g31757 | i0 | 46.9 | 0.635761589403974 | 32 | 17 | 63.6 | 0 | 16 | 111 | 319 | 350 | MEW5316514.1 hypothetical protein [Sanguina aurantia] | diamond | 96 | 42.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 32305143 | 32305143 | PRJNA315314_S_NODE_1659_length_603_cov_11.418118_g1395_i0 | PRJNA315314 | 1659 | 603 | 11.418118 | 68.85125154 | Chlorellaceae | 35461 | Plants | Plants | 244 | 6.48e-79 | NR | KAK2079457.1 | 3111 | g1395 | i0 | 69.3 | 10.7960199004975 | 179 | 54 | 88.6 | 1 | 602 | 69 | 16 | 194 | KAK2079457.1 60S ribosomal protein L15-2 [Prototheca wickerhamii] | diamond | 6510 | 244 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 32809885 | 32809885 | PRJNA315314_S_NODE_14600_length_214_cov_2.189189_g14279_i0 | PRJNA315314 | 14600 | 214 | 2.189189 | 4.68486446 | Scenedesmus | 3087 | Plants | Plants | 77.4 | 9.17e-15 | NR | KAF6262894.1 | 2650976 | g14279 | i0 | 50.6 | 2.22897196261682 | 79 | 31 | 99.5 | 1 | 1 | 213 | 112 | 190 | KAF6262894.1 hypothetical protein COO60DRAFT_1493309 [Scenedesmus sp. NREL 46B-D3] | diamond | 477 | 77.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 |
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);;