contig_metadata
15 rows where bioproject = "PRJNA767802" and tax_phylum = "Chlorophyta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5848764 | 5848764 | PRJNA767802_P_NODE_7445_length_279_cov_2.386957_g7372_i0 | PRJNA767802 | 7445 | 279 | 2.386957 | 6.65961003 | Ulothrix zonata | 43941 | Plants | Plants | 510 | 3.5299999999999996e-140 | NTclustered | gi|530445654|emb|HE860533.1| | 43941 | g7372 | i0 | 99.642 | 99.8709677419355 | 279 | 1 | 100 | 0 | 1 | 279 | 37 | 315 | Ulothrix zonata partial 28S rRNA gene, isolate Q19 | blastn | 27864 | 510 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Ulothrix | Ulothrix zonata | |
| 7123927 | 7123927 | PRJNA767802_P_NODE_5166_length_360_cov_2.051447_g5093_i0 | PRJNA767802 | 5166 | 360 | 2.051447 | 7.3852092 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 169 | 8.12e-51 | NR | GAX77325.1 | 1157962 | g5093 | i0 | 68.1 | 6.94166666666667 | 119 | 38 | 99.2 | 0 | 359 | 3 | 86 | 204 | GAX77325.1 hypothetical protein CEUSTIGMA_g4771.t1 [Chlamydomonas eustigma] | diamond | 2499 | 169 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 7123954 | 7123954 | PRJNA767802_P_NODE_9706_length_231_cov_5.763736_g9633_i0 | PRJNA767802 | 9706 | 231 | 5.763736 | 13.31423016 | Desmochloris halophila | 138176 | Plants | Plants | 305 | 1.43e-78 | NTclustered | gi|371782086|emb|HE610118.1| | 138176 | g9633 | i0 | 92.891 | 92.2121212121212 | 211 | 14 | 91 | 1 | 1 | 211 | 2792 | 2583 | Desmochloris halophila 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain UTEX 2073 | blastn | 21301 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Chlorocystidales | Chlorocystidaceae | Desmochloris | Desmochloris halophila | |
| 10949311 | 10949311 | PRJNA767802_P_NODE_7849_length_269_cov_2.040909_g7776_i0 | PRJNA767802 | 7849 | 269 | 2.040909 | 5.49004521 | Sarcinofilum mucosum | 141643 | Plants | Plants | 444 | 3.48e-120 | NTclustered | gi|1197510887|ref|NC_034709.1| | 141643 | g7776 | i0 | 96.992 | 127.07063197026 | 266 | 5 | 100 | 2 | 4 | 269 | 147462 | 147200 | Trichosarcina mucosa culture SAG:4.90 chloroplast, complete genome | blastn | 34182 | 444 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Sarcinofilaceae | Sarcinofilum | Sarcinofilum mucosum | |
| 13498959 | 13498959 | PRJNA767802_P_NODE_4651_length_388_cov_5.477876_g4578_i0 | PRJNA767802 | 4651 | 388 | 5.477876 | 21.25415888 | Ulva sp. EE2 | 707363 | Plants | Plants | 254 | 9.47e-63 | NTclustered | gi|284177801|gb|GQ421591.1| | 707363 | g4578 | i0 | 84.646 | 7.19587628865979 | 254 | 39 | 65 | 0 | 22 | 275 | 686 | 939 | Ulva sp. EE2 glyceraldehyde-3-phosphate dehydrogenase (GapA) mRNA, partial cds | blastn | 2792 | 254 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva sp. EE2 | |
| 17783670 | 17783670 | PRJNA767802_P_NODE_5454_length_346_cov_1.730640_g5381_i0 | PRJNA767802 | 5454 | 346 | 1.73064 | 5.9880144 | Cephaleuros | 173369 | Plants | Plants | 147 | 1.46e-30 | NTclustered | gi|2210642948|gb|ON040817.1| | 173370 | g5381 | i0 | 87.402 | 36.7052023121387 | 127 | 16 | 37 | 0 | 130 | 256 | 227 | 353 | Cephaleuros parasiticus isolate Osm7 large subunit ribosomal RNA gene, partial sequence | blastn | 12700 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Trentepohliales | Trentepohliaceae | Cephaleuros | Cephaleuros parasiticus | |
| 19057826 | 19057826 | PRJNA767802_P_NODE_7715_length_272_cov_2.076233_g7642_i0 | PRJNA767802 | 7715 | 272 | 2.076233 | 5.64735376 | Eukaryota | 2759 | Plants | Plants | 113 | 1.13e-20 | NTclustered | gi|2082259818|ref|XM_001690833.2| | 3055 | g7642 | i0 | 80 | 2.67647058823529 | 160 | 27 | 58 | 5 | 52 | 208 | 440 | 597 | Chlamydomonas reinhardtii ribosomal protein L18 (CHLRE_12g512600v5), mRNA | blastn | 728 | 113 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 26809723 | 26809723 | PRJNA767802_P_NODE_3661_length_454_cov_12.479012_g3588_i0 | PRJNA767802 | 3661 | 454 | 12.479012 | 56.65471448 | Eukaryota | 2759 | Plants | Plants | 100 | 2e-21 | NR | KAJ9533911.1 | 44745 | g3588 | i0 | 49.1 | 20.9801762114537 | 116 | 57 | 76.7 | 2 | 12 | 359 | 1322 | 1435 | KAJ9533911.1 hypothetical protein QJQ45_027003 [Haematococcus lacustris] | diamond | 9525 | 100 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris | |
| 27031147 | 27031147 | PRJNA767802_P_NODE_2002_length_642_cov_3.588533_g1940_i0 | PRJNA767802 | 2002 | 642 | 3.588533 | 23.03838186 | Eukaryota | 2759 | Plants | Plants | 71.6 | 9.28e-11 | NR | GBG00524.1 | 307507 | g1940 | i0 | 34.9 | 2.9392523364486 | 126 | 58 | 48.6 | 4 | 630 | 319 | 17 | 140 | GBG00524.1 hypothetical protein Rsub_13363 [Raphidocelis subcapitata] | diamond | 1887 | 72 | 0.994444444444444 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Raphidocelis | Raphidocelis subcapitata | |
| 27242822 | 27242822 | PRJNA767802_P_NODE_7603_length_275_cov_1.911504_g7530_i0 | PRJNA767802 | 7603 | 275 | 1.911504 | 5.256636 | Chlorella vulgaris | 3077 | Plants | Plants | 79 | 1.01e-14 | NR | KAL4858726.1 | 3077 | g7530 | i0 | 46.3 | 10.9963636363636 | 82 | 44 | 89.5 | 0 | 3 | 248 | 251 | 332 | KAL4858726.1 Uncharacterized protein ACK3TF_001123 [Chlorella vulgaris] | diamond | 3024 | 79 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27779902 | 27779902 | PRJNA767802_P_NODE_5184_length_359_cov_3.774194_g5111_i0 | PRJNA767802 | 5184 | 359 | 3.774194 | 13.54935646 | Monoraphidium neglectum | 145388 | Plants | Plants | 73.2 | 1.68e-12 | NR | XP_013904743.1 | 145388 | g5111 | i0 | 65.2 | 1.1949860724234 | 46 | 16 | 38.4 | 0 | 142 | 279 | 34 | 79 | XP_013904743.1 SNW domain-containing protein 1, partial [Monoraphidium neglectum] | diamond | 429 | 73.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 27978785 | 27978785 | PRJNA767802_P_NODE_4585_length_392_cov_2.924198_g4512_i0 | PRJNA767802 | 4585 | 392 | 2.924198 | 11.46285616 | Eukaryota | 2759 | Plants | Plants | 83.2 | 5.55e-17 | NR | KAG2502050.1 | 47281 | g4512 | i0 | 65.6 | 3.50510204081633 | 61 | 17 | 46.7 | 1 | 177 | 359 | 119 | 175 | KAG2502050.1 hypothetical protein HYH03_000544 [Edaphochlamys debaryana] | diamond | 1374 | 83.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Edaphochlamys | Edaphochlamys debaryana | ||
| 30401244 | 30401244 | PRJNA767802_P_NODE_12633_length_195_cov_1.397260_g12560_i0 | PRJNA767802 | 12633 | 195 | 1.39726 | 2.724657 | Chlamydomonas eustigma | 1157962 | Plants | Plants | 56.2 | 3.14e-8 | NR | GAX73977.1 | 1157962 | g12560 | i0 | 93.3 | 0.461538461538462 | 30 | 2 | 46.2 | 0 | 2 | 91 | 76 | 105 | GAX73977.1 hypothetical protein CEUSTIGMA_g1427.t1 [Chlamydomonas eustigma] | diamond | 90 | 56.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas eustigma | |
| 30938048 | 30938048 | PRJNA767802_P_NODE_12174_length_200_cov_1.615894_g12101_i0 | PRJNA767802 | 12174 | 200 | 1.615894 | 3.231788 | Coccomyxa viridis | 1274662 | Plants | Plants | 54.7 | 5.75e-7 | NR | CAK0785728.1 | 1274662 | g12101 | i0 | 47.8 | 0.69 | 46 | 24 | 69 | 0 | 63 | 200 | 109 | 154 | CAK0785728.1 hypothetical protein CVIRNUC_008939 [Coccomyxa viridis] | diamond | 138 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa viridis | ||
| 32234859 | 32234859 | PRJNA767802_P_NODE_10018_length_226_cov_1.728814_g9945_i0 | PRJNA767802 | 10018 | 226 | 1.728814 | 3.90711964 | Trebouxia sp. C | 2796353 | Plants | Plants | 97.8 | 8.23e-24 | NR | KAL0051287.1 | 2905655 | g9945 | i0 | 81.7 | 5.57522123893805 | 60 | 11 | 79.6 | 0 | 21 | 200 | 101 | 160 | KAL0051287.1 hypothetical protein WJX82_004969 [Trebouxia sp. C0006] | diamond | 1260 | 97.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. C0006 |
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);;