contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418527 | 418527 | PRJNA408129_S_NODE_5161_length_265_cov_2.653509_g5143_i0 | PRJNA408129 | 5161 | 265 | 2.653509 | 7.03179885 | Chlorophyta | 3041 | Plants | Plants | 130 | 2.78e-35 | NR | XP_001693710.1 | 3055 | g5143 | i0 | 83.8 | 6.35094339622642 | 80 | 12 | 90.6 | 1 | 1 | 240 | 177 | 255 | XP_001693710.1 ribosomal protein S3a [Chlamydomonas reinhardtii] | diamond | 1683 | 130 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 27154989 | 27154989 | PRJNA408129_S_NODE_13362_length_203_cov_1.789157_g13344_i0 | PRJNA408129 | 13362 | 203 | 1.789157 | 3.63198871 | Chlorophyta | 3041 | Plants | Plants | 43.5 | 0.0117 | NR | ABQ81938.1 | 3116 | g13344 | i0 | 100 | 0.886699507389163 | 20 | 0 | 29.6 | 0 | 203 | 144 | 427 | 446 | ABQ81938.1 elongation factor-1 alpha-like protein, partial [Ulva intestinalis] | diamond | 180 | 43.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva intestinalis | |
| 27296811 | 27296811 | PRJNA408129_S_NODE_20683_length_177_cov_2.371429_g20665_i0 | PRJNA408129 | 20683 | 177 | 2.371429 | 4.19742933 | Monoraphidium neglectum | 145388 | Plants | Plants | 48.1 | 1.58e-4 | NR | XP_013900905.1 | 145388 | g20665 | i0 | 63.3 | 1.52542372881356 | 30 | 11 | 50.8 | 0 | 177 | 88 | 196 | 225 | XP_013900905.1 40S ribosomal protein S3-1 [Monoraphidium neglectum] | diamond | 270 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 27360158 | 27360158 | PRJNA408129_S_NODE_31423_length_156_cov_1.890756_g31405_i0 | PRJNA408129 | 31423 | 156 | 1.890756 | 2.94957936 | Trebouxia sp. C | 2796353 | Plants | Plants | 92.8 | 4.64e-23 | NR | KAL0039368.1 | 2905654 | g31405 | i0 | 87.8 | 1.86538461538462 | 49 | 6 | 94.2 | 0 | 2 | 148 | 44 | 92 | KAL0039368.1 hypothetical protein WJX79_005033 [Trebouxia sp. C0005] | diamond | 291 | 92.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0005 | |
| 27486351 | 27486351 | PRJNA408129_S_NODE_32943_length_154_cov_1.632479_g32925_i0 | PRJNA408129 | 32943 | 154 | 1.632479 | 2.51401766 | Ulva flexuosa | 83791 | Plants | Plants | 74.3 | 8.08e-14 | NR | AZP40192.1 | 83791 | g32925 | i0 | 64.7 | 1.98701298701299 | 51 | 18 | 99.4 | 0 | 154 | 2 | 187 | 237 | AZP40192.1 hypothetical protein [Ulva flexuosa] | diamond | 306 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva flexuosa | |
| 27676021 | 27676021 | PRJNA408129_S_NODE_33944_length_152_cov_6.321739_g33926_i0 | PRJNA408129 | 33944 | 152 | 6.321739 | 9.60904328 | Prototheca wickerhamii | 3111 | Plants | Plants | 67.8 | 1.52e-11 | NR | KAK2079609.1 | 3111 | g33926 | i0 | 93.3 | 2.96052631578947 | 30 | 2 | 59.2 | 0 | 6 | 95 | 394 | 423 | KAK2079609.1 hypothetical protein QBZ16_002004 [Prototheca wickerhamii] | diamond | 450 | 67.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 28496831 | 28496831 | PRJNA408129_S_NODE_23547_length_170_cov_2.443609_g23529_i0 | PRJNA408129 | 23547 | 170 | 2.443609 | 4.1541353 | Monoraphidium minutum | 39955 | Plants | Plants | 63.2 | 8.61e-10 | NR | KAI8477130.1 | 39955 | g23529 | i0 | 81.6 | 0.670588235294118 | 38 | 7 | 67.1 | 0 | 158 | 45 | 548 | 585 | KAI8477130.1 MAG: lysyl-tRNA synthetase, LysRS [Monoraphidium minutum] | diamond | 114 | 63.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 28749310 | 28749310 | PRJNA408129_S_NODE_8987_length_228_cov_4.670157_g8969_i0 | PRJNA408129 | 8987 | 228 | 4.670157 | 10.64795796 | Coccomyxa subellipsoidea C-169 | 574566 | Plants | Plants | 44.3 | 0.0085 | NR | XP_005643479.1 | 574566 | g8969 | i0 | 63.6 | 0.434210526315789 | 33 | 12 | 43.4 | 0 | 87 | 185 | 402 | 434 | XP_005643479.1 Clavaminate synthase-like protein [Coccomyxa subellipsoidea C-169] | diamond | 99 | 44.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 29002330 | 29002330 | PRJNA408129_S_NODE_4148_length_281_cov_2.942623_g4130_i0 | PRJNA408129 | 4148 | 281 | 2.942623 | 8.26877063 | Chlorella sorokiniana | 3076 | Plants | Plants | 75.1 | 2.51e-13 | NR | PRW05900.1 | 3076 | g4130 | i0 | 63.8 | 1.00355871886121 | 58 | 21 | 61.9 | 0 | 1 | 174 | 656 | 713 | PRW05900.1 acetolactate synthase isoform A [Chlorella sorokiniana] | diamond | 282 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 29664570 | 29664570 | PRJNA408129_S_NODE_19950_length_179_cov_2.387324_g19932_i0 | PRJNA408129 | 19950 | 179 | 2.387324 | 4.27330996 | Bryopsis sp. KO-2 | 3115439 | Plants | Plants | 75.1 | 7.71e-16 | NR | GMH40780.1 | 3041901 | g19932 | i0 | 72.7 | 0.921787709497207 | 55 | 15 | 92.2 | 0 | 179 | 15 | 41 | 95 | GMH40780.1 hypothetical protein BSKO_08684 [Bryopsis sp. KO-2023] | diamond | 165 | 75.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis sp. KO-2023 | |
| 29744481 | 29744481 | PRJNA408129_S_NODE_20030_length_179_cov_1.570423_g20012_i0 | PRJNA408129 | 20030 | 179 | 1.570423 | 2.81105717 | Chlorophyta | 3041 | Plants | Plants | 49.3 | 5.1e-5 | NR | KAK9811451.1 | 41462 | g20012 | i0 | 73.3 | 3.5195530726257 | 30 | 8 | 50.3 | 0 | 2 | 91 | 175 | 204 | KAK9811451.1 hypothetical protein WJX72_004104 [[Myrmecia] bisecta] | diamond | 630 | 49.7 | 0.991951710261569 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30012496 | 30012496 | PRJNA408129_S_NODE_15931_length_192_cov_1.548387_g15913_i0 | PRJNA408129 | 15931 | 192 | 1.548387 | 2.97290304 | Ulva pertusa | 3120 | Plants | Plants | 48.1 | 7.71e-5 | NR | AAT45616.1 | 3120 | g15913 | i0 | 74.1 | 0.84375 | 27 | 7 | 42.2 | 0 | 191 | 111 | 112 | 138 | AAT45616.1 plastocyanin precursor [Ulva pertusa] | diamond | 162 | 48.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva pertusa | |
| 30360377 | 30360377 | PRJNA408129_S_NODE_8252_length_234_cov_2.208122_g8234_i0 | PRJNA408129 | 8252 | 234 | 2.208122 | 5.16700548 | Acetabularia acetabulum | 35845 | Plants | Plants | 64.7 | 3.17e-10 | NR | DAA05905.1 | 35845 | g8234 | i0 | 87.1 | 1.16666666666667 | 31 | 4 | 39.7 | 0 | 4 | 96 | 223 | 253 | DAA05905.1 TPA_inf: chloroplast light-harvesting complex II protein precursor Lhcbm12 [Acetabularia acetabulum] | diamond | 273 | 64.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Dasycladales | Polyphysaceae | Acetabularia | Acetabularia acetabulum | |
| 30517878 | 30517878 | PRJNA408129_S_NODE_34753_length_151_cov_5.280702_g34735_i0 | PRJNA408129 | 34753 | 151 | 5.280702 | 7.97386002 | [Myrmecia] bisecta | 41462 | Plants | Plants | 90.1 | 2.23e-21 | NR | KAK9811693.1 | 41462 | g34735 | i0 | 94 | 0.993377483443709 | 50 | 3 | 99.3 | 0 | 151 | 2 | 97 | 146 | KAK9811693.1 hypothetical protein WJX72_008509 [[Myrmecia] bisecta] | diamond | 150 | 90.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30897202 | 30897202 | PRJNA408129_S_NODE_18574_length_183_cov_1.910959_g18556_i0 | PRJNA408129 | 18574 | 183 | 1.910959 | 3.49705497 | Symbiochloris irregularis | 706552 | Plants | Plants | 101 | 5.37e-24 | NR | KAK9806558.1 | 706552 | g18556 | i0 | 82.1 | 1.81967213114754 | 56 | 10 | 91.8 | 0 | 1 | 168 | 255 | 310 | KAK9806558.1 hypothetical protein WJX73_000697 [Symbiochloris irregularis] | diamond | 333 | 101 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 31023418 | 31023418 | PRJNA408129_S_NODE_12375_length_208_cov_2.701754_g12357_i0 | PRJNA408129 | 12375 | 208 | 2.701754 | 5.61964832 | Sanguina aurantia | 2578422 | Plants | Plants | 45.1 | 0.00236 | NR | MEW5302222.1 | 2578422 | g12357 | i0 | 71.8 | 0.5625 | 39 | 9 | 56.3 | 2 | 2 | 118 | 140 | 176 | MEW5302222.1 hypothetical protein [Sanguina aurantia] | diamond | 117 | 45.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Sanguina | Sanguina aurantia | |
| 31117943 | 31117943 | PRJNA408129_S_NODE_32795_length_154_cov_2.452991_g32777_i0 | PRJNA408129 | 32795 | 154 | 2.452991 | 3.77760614 | Dicloster acuatus | 91190 | Plants | Plants | 45.4 | 9.18e-4 | NR | YP_009106639.1 | 91190 | g32777 | i0 | 43.5 | 0.896103896103896 | 46 | 26 | 89.6 | 0 | 15 | 152 | 144 | 189 | YP_009106639.1 putative site-specific DNA endonuclease [Dicloster acuatus] | diamond | 138 | 45.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Dicloster | Dicloster acuatus | |
| 31687352 | 31687352 | PRJNA408129_S_NODE_27157_length_163_cov_1.793651_g27139_i0 | PRJNA408129 | 27157 | 163 | 1.793651 | 2.92365113 | Raphidocelis subcapitata | 307507 | Plants | Plants | 81.6 | 5.51e-18 | NR | GBG00329.1 | 307507 | g27139 | i0 | 80.4 | 2.8159509202454 | 51 | 10 | 93.9 | 0 | 9 | 161 | 81 | 131 | GBG00329.1 60S ribosomal protein L27a [Raphidocelis subcapitata] | diamond | 459 | 81.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 32541903 | 32541903 | PRJNA408129_S_NODE_1599_length_349_cov_21.237179_g1581_i0 | PRJNA408129 | 1599 | 349 | 21.237179 | 74.11775471 | [Myrmecia] bisecta | 41462 | Plants | Plants | 66.6 | 1.41e-11 | NR | KAK9814105.1 | 41462 | g1581 | i0 | 56.9 | 0.498567335243553 | 58 | 25 | 49.9 | 0 | 22 | 195 | 4 | 61 | KAK9814105.1 hypothetical protein WJX72_000742 [[Myrmecia] bisecta] | diamond | 174 | 66.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta |
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);;