contig_metadata
24 rows where bioproject = "PRJNA529241" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 499548 | 499548 | PRJNA529241_P_NODE_25201_length_418_cov_5.566929_g22910_i0 | PRJNA529241 | 25201 | 418 | 5.566929 | 23.26976322 | Jenufa minuta | 993092 | Plants | Plants | 634 | 3.14e-177 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g22910 | i0 | 94.076 | 218.698564593301 | 422 | 18 | 100 | 5 | 1 | 418 | 103421 | 103003 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 91416 | 634 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 1773369 | 1773369 | PRJNA529241_P_NODE_113942_length_207_cov_1.100000_g111620_i0 | PRJNA529241 | 113942 | 207 | 1.1 | 2.277 | Prasiola crispa | 173492 | Plants | Plants | 333 | 5.779999999999999e-87 | NTclustered | gi|806639636|gb|KR017749.1| | 173492 | g111620 | i0 | 95.673 | 131.275362318841 | 208 | 7 | 100 | 2 | 1 | 207 | 3106 | 2900 | Prasiola crispa clone Contig2 chloroplast sequence | blastn | 27174 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Prasiola | Prasiola crispa | |
| 1773878 | 1773878 | PRJNA529241_P_NODE_151562_length_185_cov_1.844595_g149240_i0 | PRJNA529241 | 151562 | 185 | 1.844595 | 3.41250075 | Jenufa minuta | 993092 | Plants | Plants | 342 | 8.369999999999999e-90 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g149240 | i0 | 100 | 9.37837837837838 | 185 | 0 | 100 | 0 | 1 | 185 | 104694 | 104878 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 1735 | 342 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 3049787 | 3049787 | PRJNA529241_P_NODE_160363_length_181_cov_1.083333_g158041_i0 | PRJNA529241 | 160363 | 181 | 1.083333 | 1.96083273 | Coccomyxa | 41891 | Plants | Plants | 121 | 2.2799999999999998e-32 | NR | XP_005646819.1 | 574566 | g158041 | i0 | 95 | 9.94475138121547 | 60 | 3 | 99.4 | 0 | 180 | 1 | 188 | 247 | XP_005646819.1 ribosomal protein L8 component of cytosolic 80S ribosome and 60S large subunit [Coccomyxa subellipsoidea C-169] | diamond | 1800 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 3052179 | 3052179 | PRJNA529241_P_NODE_451463_length_156_cov_1.638655_g449141_i0 | PRJNA529241 | 451463 | 156 | 1.638655 | 2.5563018 | Chlorella endosymbiont of Stentor polymorphus | 2219871 | Plants | Plants | 237 | 3.31e-58 | NTclustered | gi|1401669229|gb|MH295835.1| | 2219871 | g449141 | i0 | 94.231 | 100.096153846154 | 156 | 8 | 100 | 1 | 1 | 156 | 1362 | 1208 | Chlorella endosymbiont of Stentor polymorphus 28S ribosomal RNA gene, partial sequence | blastn | 15615 | 237 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella endosymbiont of Stentor polymorphus | |
| 4944414 | 4944414 | PRJNA529241_P_NODE_49024_length_292_cov_1.686275_g46702_i0 | PRJNA529241 | 49024 | 292 | 1.686275 | 4.923923 | Watanabeales | 2981622 | Plants | Plants | 401 | 2.3299999999999993e-107 | NTclustered | gi|2663407540|emb|OY754499.1| | 1274662 | g46702 | i0 | 91.497 | 149.544520547945 | 294 | 22 | 100 | 3 | 1 | 292 | 158144 | 157852 | Coccomyxa viridis genome assembly, organelle: plastid | blastn | 43667 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 6219998 | 6219998 | PRJNA529241_P_NODE_54345_length_279_cov_3.252066_g52023_i0 | PRJNA529241 | 54345 | 279 | 3.252066 | 9.07326414 | Trebouxiophyceae | 75966 | Plants | Plants | 508 | 1.27e-139 | NTclustered | gi|328349687|emb|FN298931.1| | 3075 | g52023 | i0 | 99.64 | 98.8745519713262 | 278 | 1 | 99 | 0 | 1 | 278 | 10 | 287 | Auxenochlorella protothecoides 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene (partial), strain CCAP 211/7A | blastn | 27586 | 508 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 8154186 | 8154186 | PRJNA529241_P_NODE_457187_length_154_cov_2.717949_g454865_i0 | PRJNA529241 | 457187 | 154 | 2.717949 | 4.18564146 | Chlorella variabilis | 554065 | Plants | Plants | 54.7 | 0.004 | NTclustered | gi|552816487|ref|XM_005844636.1| | 554065 | g454865 | i0 | 84.746 | 0.383116883116883 | 59 | 3 | 34 | 4 | 83 | 135 | 1292 | 1234 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_138627) mRNA, complete cds | blastn | 59 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 9427731 | 9427731 | PRJNA529241_P_NODE_24948_length_421_cov_3.572917_g22657_i0 | PRJNA529241 | 24948 | 421 | 3.572917 | 15.04198057 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 630 | 4.0899999999999984e-176 | NTclustered | gi|440136375|gb|JX857664.1| | 3075 | g22657 | i0 | 97.832 | 47.0593824228028 | 369 | 1 | 88 | 3 | 53 | 421 | 388 | 27 | Auxenochlorella protothecoides strain 0710 clone CHLPROCpK12 large subunit ribosomal RNA, partial sequence | blastn | 19812 | 630 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 11977518 | 11977518 | PRJNA529241_P_NODE_157970_length_182_cov_1.344828_g155648_i0 | PRJNA529241 | 157970 | 182 | 1.344828 | 2.44758696 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 337 | 3.82e-88 | NTclustered | gi|741870561|ref|NC_026009.1| | 3075 | g155648 | i0 | 100 | 38.1923076923077 | 182 | 0 | 100 | 0 | 1 | 182 | 32661 | 32480 | Auxenochlorella protothecoides mitochondrion, complete genome | blastn | 6951 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 11977520 | 11977520 | PRJNA529241_P_NODE_158010_length_182_cov_1.344828_g155688_i0 | PRJNA529241 | 158010 | 182 | 1.344828 | 2.44758696 | Jenufa minuta | 993092 | Plants | Plants | 337 | 3.82e-88 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g155688 | i0 | 100 | 99.6373626373626 | 182 | 0 | 100 | 0 | 1 | 182 | 46160 | 46341 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 18134 | 337 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 14527608 | 14527608 | PRJNA529241_P_NODE_155712_length_183_cov_1.869863_g153390_i0 | PRJNA529241 | 155712 | 183 | 1.869863 | 3.42184929 | Jenufa minuta | 993092 | Plants | Plants | 333 | 4.97e-87 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g153390 | i0 | 99.454 | 60.8087431693989 | 183 | 1 | 100 | 0 | 1 | 183 | 34814 | 34632 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 11128 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 15803471 | 15803471 | PRJNA529241_P_NODE_423033_length_167_cov_1.130769_g420711_i0 | PRJNA529241 | 423033 | 167 | 1.130769 | 1.88838423 | Haematococcus lacustris | 44745 | Plants | Plants | 230 | 6.029999999999999e-56 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g420711 | i0 | 92.025 | 442.922155688623 | 163 | 13 | 98 | 0 | 1 | 163 | 3843 | 3681 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 73968 | 230 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 17694660 | 17694660 | PRJNA529241_P_NODE_7854_length_1081_cov_3.011494_g6616_i0 | PRJNA529241 | 7854 | 1081 | 3.011494 | 32.55425014 | Ulva | 3118 | Plants | Plants | 1181 | 0 | NTclustered | gi|2095862465|gb|MN853879.1| | 3117 | g6616 | i0 | 86.761 | 110.894542090657 | 1065 | 136 | 98 | 5 | 19 | 1081 | 24427 | 23366 | Ulva prolifera chloroplast, complete genome | blastn | 119877 | 1192 | 0.990771812080537 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva prolifera | |
| 18352329 | 18352329 | PRJNA529241_P_NODE_422695_length_167_cov_1.453846_g420373_i0 | PRJNA529241 | 422695 | 167 | 1.453846 | 2.42792282 | Jenufa minuta | 993092 | Plants | Plants | 274 | 2.75e-69 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g420373 | i0 | 100 | 101.017964071856 | 148 | 0 | 89 | 0 | 20 | 167 | 45740 | 45887 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 16870 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 22175683 | 22175683 | PRJNA529241_P_NODE_173898_length_175_cov_1.695652_g171576_i0 | PRJNA529241 | 173898 | 175 | 1.695652 | 2.967391 | Jenufa minuta | 993092 | Plants | Plants | 217 | 4.94e-52 | NTclustered | gi|1829768154|ref|NC_046780.1| | 993092 | g171576 | i0 | 89.773 | 1.38285714285714 | 176 | 8 | 100 | 6 | 1 | 175 | 21660 | 21494 | Jenufa minuta culture CAUP:H8102 mitochondrion, complete genome | blastn | 242 | 217 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 24724471 | 24724471 | PRJNA529241_P_NODE_13340_length_674_cov_6.676609_g11453_i0 | PRJNA529241 | 13340 | 674 | 6.676609 | 45.00034466 | Jenufa minuta | 993092 | Plants | Plants | 1243 | 0 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g11453 | i0 | 100 | 135.43175074184 | 673 | 0 | 99 | 0 | 1 | 673 | 103484 | 104156 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 91281 | 1243 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 26902994 | 26902994 | PRJNA529241_P_NODE_366581_length_173_cov_2.698529_g364259_i0 | PRJNA529241 | 366581 | 173 | 2.698529 | 4.66845517 | Eukaryota | 2759 | Plants | Plants | 47.4 | 2.93e-4 | NR | KAK9918745.1 | 248742 | g364259 | i0 | 91.3 | 8.0635838150289 | 23 | 2 | 39.9 | 0 | 100 | 168 | 168 | 190 | KAK9918745.1 hypothetical protein WJX75_006512 [Coccomyxa subellipsoidea] | diamond | 1395 | 47.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 27282402 | 27282402 | PRJNA529241_P_NODE_551103_length_151_cov_2.596491_g548781_i0 | PRJNA529241 | 551103 | 151 | 2.596491 | 3.92070141 | Chlorophyceae | 3166 | Plants | Plants | 48.5 | 5.46e-5 | NR | KXZ45106.1 | 33097 | g548781 | i0 | 60 | 1.1523178807947 | 30 | 12 | 59.6 | 0 | 150 | 61 | 71 | 100 | KXZ45106.1 hypothetical protein GPECTOR_58g555 [Gonium pectorale] | diamond | 174 | 48.9 | 0.991820040899796 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 27756294 | 27756294 | PRJNA529241_P_NODE_279964_length_173_cov_3.845588_g277642_i0 | PRJNA529241 | 279964 | 173 | 3.845588 | 6.65286724 | root | 1 | Root_unresolved | Root_unresolved | 42.4 | 0.02 | NR | KAI8469007.1 | 39955 | g277642 | i0 | 66.7 | 1.21387283236994 | 24 | 8 | 41.6 | 0 | 168 | 97 | 206 | 229 | KAI8469007.1 MAG: major facilitator superfamily transporter [Monoraphidium minutum] | diamond | 210 | 42.7 | 0.992974238875878 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 29319452 | 29319452 | PRJNA529241_P_NODE_167209_length_178_cov_1.078014_g164887_i0 | PRJNA529241 | 167209 | 178 | 1.078014 | 1.91886492 | Scenedesmus sp. NREL 46B-D3 | 2650976 | Plants | Plants | 39.7 | 0.0423 | NR | KAF6261890.1 | 2650976 | g164887 | i0 | 42.9 | 0.471910112359551 | 28 | 16 | 47.2 | 0 | 74 | 157 | 32 | 59 | KAF6261890.1 hypothetical protein COO60DRAFT_1499080 [Scenedesmus sp. NREL 46B-D3] | diamond | 84 | 39.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 30172144 | 30172144 | PRJNA529241_P_NODE_244052_length_173_cov_4.573529_g241730_i0 | PRJNA529241 | 244052 | 173 | 4.573529 | 7.91220517 | Trebouxia sp. C | 2796353 | Plants | Plants | 53.9 | 1.62e-6 | NR | KAL3135587.1 | 3373144 | g241730 | i0 | 60.4 | 2.4971098265896 | 48 | 16 | 83.2 | 1 | 1 | 144 | 88 | 132 | KAL3135587.1 hypothetical protein ABBQ38_006067 [Trebouxia sp. C0009 RCD-2024] | diamond | 432 | 53.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0009 RCD-2024 | |
| 30661371 | 30661371 | PRJNA529241_P_NODE_420153_length_168_cov_1.190840_g417831_i0 | PRJNA529241 | 420153 | 168 | 1.19084 | 2.0006112 | Chlorophyta | 3041 | Plants | Plants | 71.2 | 1.61e-14 | NR | KAF5837181.1 | 3046 | g417831 | i0 | 77.3 | 2.25 | 44 | 10 | 78.6 | 0 | 168 | 37 | 42 | 85 | KAF5837181.1 60S ribosomal protein L38 [Dunaliella salina] | diamond | 378 | 71.6 | 0.994413407821229 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31025437 | 31025437 | PRJNA529241_P_NODE_374755_length_173_cov_2.625000_g372433_i0 | PRJNA529241 | 374755 | 173 | 2.625 | 4.54125 | Chlamydomonas incerta | 51695 | Plants | Plants | 45.8 | 0.00118 | NR | KAG2426295.1 | 51695 | g372433 | i0 | 54.5 | 0.763005780346821 | 44 | 18 | 72.8 | 1 | 171 | 46 | 141 | 184 | KAG2426295.1 hypothetical protein HXX76_013052 [Chlamydomonas incerta] | diamond | 132 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta |
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);;