contig_metadata
20 rows where bioproject = "PRJNA1174207" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 315865 | 315865 | PRJNA1174207_P_NODE_36741_length_247_cov_0.885057_g36212_i0 | PRJNA1174207 | 36741 | 247 | 0.885057 | 2.18609079 | Haematococcus lacustris | 44745 | Plants | Plants | 110 | 4.95e-28 | NR | KAJ9523538.1 | 44745 | g36212 | i0 | 65.9 | 2.97570850202429 | 82 | 28 | 99.6 | 0 | 2 | 247 | 67 | 148 | KAJ9523538.1 hypothetical protein QJQ45_007182 [Haematococcus lacustris] | diamond | 735 | 110 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 4142430 | 4142430 | PRJNA1174207_P_NODE_22864_length_297_cov_1.718750_g22335_i0 | PRJNA1174207 | 22864 | 297 | 1.71875 | 5.1046875 | Eukaryota | 2759 | Plants | Plants | 167 | 3.65e-48 | NR | KAI3426228.1 | 3077 | g22335 | i0 | 79.6 | 31.6565656565657 | 98 | 20 | 99 | 0 | 295 | 2 | 35 | 132 | KAI3426228.1 hypothetical protein D9Q98_008604 [Chlorella vulgaris] | diamond | 9402 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 4868851 | 4868851 | PRJNA1174207_P_NODE_43724_length_204_cov_4.251908_g43195_i0 | PRJNA1174207 | 43724 | 204 | 4.251908 | 8.67389232 | root | 1 | Root_unresolved | Root_unresolved | 287 | 4.479999999999999e-73 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g43195 | i0 | 92.233 | 100.78431372549 | 206 | 10 | 99 | 6 | 1 | 203 | 4838 | 5040 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 20560 | 287 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 10519392 | 10519392 | PRJNA1174207_P_NODE_35309_length_249_cov_0.875000_g34780_i0 | PRJNA1174207 | 35309 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Plants | Plants | 115 | 1.12e-30 | NR | PNG93953.1 | 47790 | g34780 | i0 | 67.1 | 4.85542168674699 | 82 | 24 | 98.8 | 1 | 2 | 247 | 89 | 167 | PNG93953.1 Guanine nucleotide-binding protein subunit beta-like protein, partial [Tetrabaena socialis] | diamond | 1209 | 115 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 10519414 | 10519414 | PRJNA1174207_P_NODE_36149_length_248_cov_0.880000_g35620_i0 | PRJNA1174207 | 36149 | 248 | 0.88 | 2.1824 | Ostreobium quekettii | 121088 | Plants | Plants | 84 | 1.23e-16 | NR | CAD7696847.1 | 121088 | g35620 | i0 | 50 | 0.943548387096774 | 78 | 39 | 94.4 | 0 | 235 | 2 | 486 | 563 | CAD7696847.1 unnamed protein product [Ostreobium quekettii] | diamond | 234 | 84 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 11794520 | 11794520 | PRJNA1174207_P_NODE_42970_length_229_cov_2.205128_g42441_i0 | PRJNA1174207 | 42970 | 229 | 2.205128 | 5.04974312 | Chloromonas actinochloris | 158501 | Plants | Plants | 274 | 4.0099999999999997e-69 | NTclustered | gi|66864280|gb|DQ015735.1| | 158501 | g42441 | i0 | 88.261 | 100.2096069869 | 230 | 25 | 100 | 2 | 1 | 229 | 1624 | 1396 | Chloromonas actinochloris strain SAG 1.72 26S ribosomal RNA gene, partial sequence | blastn | 22948 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chloromonas | Chloromonas actinochloris | |
| 13793835 | 13793835 | PRJNA1174207_P_NODE_20671_length_311_cov_1.995798_g20142_i0 | PRJNA1174207 | 20671 | 311 | 1.995798 | 6.20693178 | Jaagichlorella | 2304164 | Plants | Plants | 564 | 3.02e-156 | NTclustered | gi|1802907783|gb|MT006204.1| | 2704669 | g20142 | i0 | 99.357 | 99.7781350482315 | 311 | 2 | 100 | 0 | 1 | 311 | 3193 | 3503 | Jaagichlorella nagensis strain FACHB-2415 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 31031 | 564 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella nagensis | |
| 15068493 | 15068493 | PRJNA1174207_P_NODE_43552_length_213_cov_4.600000_g43023_i0 | PRJNA1174207 | 43552 | 213 | 4.6 | 9.798 | Watanabeaceae | 2981775 | Plants | Plants | 383 | 5.8499999999999996e-102 | NTclustered | gi|1561005731|gb|MG493347.1| | 167235 | g43023 | i0 | 99.061 | 99.6244131455399 | 213 | 2 | 100 | 0 | 1 | 213 | 109 | 321 | Uncultured Trebouxiophyceae clone LSY2026 18S ribosomal RNA gene, partial sequence | blastn | 21220 | 383 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Trebouxiophyceae | ||||
| 16343185 | 16343185 | PRJNA1174207_P_NODE_31433_length_258_cov_3.405405_g30904_i0 | PRJNA1174207 | 31433 | 258 | 3.405405 | 8.7859449 | root | 1 | Root_unresolved | Root_unresolved | 455 | 1.53e-123 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g30904 | i0 | 98.456 | 100.352713178295 | 259 | 3 | 100 | 1 | 1 | 258 | 876 | 618 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 25891 | 455 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 23992668 | 23992668 | PRJNA1174207_P_NODE_18199_length_333_cov_4.519231_g17670_i0 | PRJNA1174207 | 18199 | 333 | 4.5192310000000004 | 15.04903923 | Trebouxiophyceae | 75966 | Plants | Plants | 599 | 8.94e-167 | NTclustered | gi|148763239|gb|EF595524.1| | 445995 | g17670 | i0 | 99.102 | 101.765765765766 | 334 | 2 | 100 | 1 | 1 | 333 | 1329 | 996 | Heveochlorella hainangensis strain FGG01 18S ribosomal RNA gene, complete sequence | blastn | 33888 | 604 | 0.991721854304636 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Jaagichlorella | Jaagichlorella hainangensis | |
| 26787437 | 26787437 | PRJNA1174207_P_NODE_27921_length_273_cov_1.740000_g27392_i0 | PRJNA1174207 | 27921 | 273 | 1.74 | 4.7502 | Raphidocelis subcapitata | 307507 | Plants | Plants | 150 | 6.01e-44 | NR | GBF94441.1 | 307507 | g27392 | i0 | 75.6 | 9.89010989010989 | 90 | 22 | 98.9 | 0 | 2 | 271 | 75 | 164 | GBF94441.1 40S ribosomal protein SA [Raphidocelis subcapitata] | diamond | 2700 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 28101877 | 28101877 | PRJNA1174207_P_NODE_36465_length_247_cov_1.327586_g35936_i0 | PRJNA1174207 | 36465 | 247 | 1.327586 | 3.27913742 | Chlamydomonadales | 3042 | Plants | Plants | 60.8 | 1.47e-8 | NR | KAJ9515922.1 | 44745 | g35936 | i0 | 40.7 | 3.8502024291498 | 81 | 40 | 98.4 | 1 | 246 | 4 | 47 | 119 | KAJ9515922.1 hypothetical protein QJQ45_016906, partial [Haematococcus lacustris] | diamond | 951 | 61.2 | 0.993464052287582 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 28808707 | 28808707 | PRJNA1174207_P_NODE_34748_length_249_cov_1.750000_g34219_i0 | PRJNA1174207 | 34748 | 249 | 1.75 | 4.3575 | Monoraphidium neglectum | 145388 | Plants | Plants | 94.4 | 1.28e-20 | NR | XP_013899781.1 | 145388 | g34219 | i0 | 59.8 | 1.97590361445783 | 82 | 32 | 97.6 | 1 | 249 | 7 | 197 | 278 | XP_013899781.1 hypothetical protein MNEG_7198 [Monoraphidium neglectum] | diamond | 492 | 94.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 28828084 | 28828084 | PRJNA1174207_P_NODE_40868_length_242_cov_0.911243_g40339_i0 | PRJNA1174207 | 40868 | 242 | 0.911243 | 2.20520806 | Eukaryota | 2759 | Plants | Plants | 60.5 | 1.98e-8 | NR | XP_042924973.1 | 3055 | g40339 | i0 | 56.8 | 1.10330578512397 | 44 | 19 | 54.5 | 0 | 239 | 108 | 167 | 210 | XP_042924973.1 uncharacterized protein CHLRE_04g216902v5 [Chlamydomonas reinhardtii] | diamond | 267 | 60.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 29049364 | 29049364 | PRJNA1174207_P_NODE_16468_length_353_cov_2.375000_g15939_i0 | PRJNA1174207 | 16468 | 353 | 2.375 | 8.38375 | Chlorophyceae | 3166 | Plants | Plants | 144 | 4.76e-41 | NR | WIA41816.1 | 3088 | g15939 | i0 | 63.6 | 1.8356940509915 | 110 | 40 | 93.5 | 0 | 23 | 352 | 35 | 144 | WIA41816.1 hypothetical protein OEZ86_009147 [Tetradesmus obliquus] | diamond | 648 | 144 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 29535228 | 29535228 | PRJNA1174207_P_NODE_37890_length_245_cov_2.133721_g37361_i0 | PRJNA1174207 | 37890 | 245 | 2.133721 | 5.22761645 | Pedinophyceae sp. YPF-7 | 765719 | Plants | Plants | 104 | 1.81e-24 | NR | CAG9466458.1 | 765719 | g37361 | i0 | 66.7 | 0.991836734693878 | 81 | 27 | 99.2 | 0 | 245 | 3 | 106 | 186 | CAG9466458.1 unnamed protein product [Pedinophyceae sp. YPF-701] | diamond | 243 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Pedinophyceae sp. YPF-701 | ||||
| 30072014 | 30072014 | PRJNA1174207_P_NODE_22992_length_296_cov_1.982063_g22463_i0 | PRJNA1174207 | 22992 | 296 | 1.982063 | 5.86690648 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 49.3 | 1.21e-4 | NR | GAX83281.1 | 1157962 | g22463 | i0 | 33.8 | 0.780405405405405 | 77 | 51 | 78 | 0 | 30 | 260 | 33 | 109 | GAX83281.1 hypothetical protein CEUSTIGMA_g10707.t1 [Chlamydomonas eustigma] | diamond | 231 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30344688 | 30344688 | PRJNA1174207_P_NODE_13452_length_398_cov_2.132308_g12924_i0 | PRJNA1174207 | 13452 | 398 | 2.132308 | 8.48658584 | root | 1 | Root_unresolved | Root_unresolved | 183 | 5.0399999999999994e-57 | NR | KAG7667380.1 | 1650286 | g12924 | i0 | 79.6 | 16.4170854271357 | 113 | 22 | 84.4 | 1 | 2 | 337 | 10 | 122 | KAG7667380.1 hypothetical protein KSW81_001112 [Chlorella desiccata (nom. nud.)] | diamond | 6534 | 184 | 0.994565217391304 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris sp. 'desiccata' | |
| 30420012 | 30420012 | PRJNA1174207_P_NODE_20373_length_314_cov_1.132780_g19844_i0 | PRJNA1174207 | 20373 | 314 | 1.13278 | 3.5569292 | Tetradesmus obliquus | 3088 | Plants | Plants | 49.3 | 2.55e-4 | NR | WIA28476.1 | 3088 | g19844 | i0 | 47.7 | 0.85031847133758 | 44 | 23 | 42 | 0 | 297 | 166 | 2 | 45 | WIA28476.1 hypothetical protein OEZ86_011020 [Tetradesmus obliquus] | diamond | 267 | 49.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Tetradesmus | Tetradesmus obliquus | |
| 32095257 | 32095257 | PRJNA1174207_P_NODE_42478_length_234_cov_2.074534_g41949_i0 | PRJNA1174207 | 42478 | 234 | 2.074534 | 4.85440956 | Chlamydomonas schloesseri | 2026947 | Plants | Plants | 71.6 | 2.14e-12 | NR | KAG2436163.1 | 2026947 | g41949 | i0 | 46.7 | 0.961538461538462 | 75 | 36 | 94.9 | 2 | 222 | 1 | 7 | 78 | KAG2436163.1 hypothetical protein HYH02_011667 [Chlamydomonas schloesseri] | diamond | 225 | 71.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas schloesseri |
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);;