contig_metadata
15 rows where bioproject = "PRJNA454503" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 442669 | 442669 | PRJNA454503_P_NODE_58661_length_210_cov_0.872483_g58332_i0 | PRJNA454503 | 58661 | 210 | 0.872483 | 1.8322143 | Monoraphidium minutum | 39955 | Plants | Plants | 84.3 | 7.62e-20 | NR | KAI8467981.1 | 39955 | g58332 | i0 | 72.5 | 3.64285714285714 | 51 | 14 | 72.9 | 0 | 205 | 53 | 1 | 51 | KAI8467981.1 MAG: ribosomal protein L39e [Monoraphidium minutum] | diamond | 765 | 84.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium minutum | |
| 4269052 | 4269052 | PRJNA454503_P_NODE_12624_length_319_cov_2.282946_g12295_i0 | PRJNA454503 | 12624 | 319 | 2.282946 | 7.28259774 | Eukaryota | 2759 | Plants | Plants | 119 | 1.47e-32 | NR | GIL72205.1 | 1737510 | g12295 | i0 | 65.7 | 2.84952978056426 | 102 | 35 | 95.9 | 0 | 315 | 10 | 3 | 104 | GIL72205.1 hypothetical protein Vretifemale_2583 [Volvox reticuliferus] | diamond | 909 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox reticuliferus | |
| 5545804 | 5545804 | PRJNA454503_P_NODE_19885_length_269_cov_1.254808_g19556_i0 | PRJNA454503 | 19885 | 269 | 1.254808 | 3.37543352 | Eukaryota | 2759 | Plants | Plants | 151 | 2.94e-45 | NR | PNG99168.1 | 47790 | g19556 | i0 | 85.2 | 52.182156133829 | 88 | 13 | 98.1 | 0 | 264 | 1 | 36 | 123 | PNG99168.1 Histone H2A, partial [Tetrabaena socialis] | diamond | 14037 | 151 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Tetrabaenaceae | Tetrabaena | Tetrabaena socialis | |
| 11296625 | 11296625 | PRJNA454503_P_NODE_12509_length_321_cov_0.873077_g12180_i0 | PRJNA454503 | 12509 | 321 | 0.873077 | 2.80257717 | Bryopsis | 3128 | Plants | Plants | 357 | 5.7e-94 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g12180 | i0 | 86.834 | 93.1183800623053 | 319 | 42 | 99 | 0 | 3 | 321 | 674 | 356 | Bryopsis maxima actin gene, partial cds | blastn | 29891 | 357 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 18294396 | 18294396 | PRJNA454503_P_NODE_69055_length_207_cov_0.890411_g68726_i0 | PRJNA454503 | 69055 | 207 | 0.890411 | 1.84315077 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 98.6 | 1.7799999999999995e-23 | NR | XP_011401943.1 | 3075 | g68726 | i0 | 89.5 | 1.68115942028985 | 57 | 6 | 82.6 | 0 | 30 | 200 | 5 | 61 | XP_011401943.1 Proteasome subunit alpha type-2 [Auxenochlorella protothecoides] | diamond | 348 | 98.6 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 19567986 | 19567986 | PRJNA454503_P_NODE_24276_length_252_cov_1.361257_g23947_i0 | PRJNA454503 | 24276 | 252 | 1.361257 | 3.43036764 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 283 | 7.44e-72 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g23947 | i0 | 87.008 | 13.4246031746032 | 254 | 30 | 100 | 3 | 1 | 252 | 39584 | 39836 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 3383 | 283 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 22119492 | 22119492 | PRJNA454503_P_NODE_84998_length_202_cov_0.921986_g84669_i0 | PRJNA454503 | 84998 | 202 | 0.921986 | 1.86241172 | Eukaryota | 2759 | Plants | Plants | 67.4 | 4.07e-11 | NR | KXZ42645.1 | 33097 | g84669 | i0 | 78.4 | 5.4950495049505 | 37 | 8 | 55 | 0 | 112 | 2 | 27 | 63 | KXZ42645.1 hypothetical protein GPECTOR_128g548 [Gonium pectorale] | diamond | 1110 | 67.8 | 0.994100294985251 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 26981164 | 26981164 | PRJNA454503_P_NODE_72882_length_206_cov_0.896552_g72553_i0 | PRJNA454503 | 72882 | 206 | 0.896552 | 1.84689712 | Symbiochloris irregularis | 706552 | Plants | Plants | 74.3 | 1.17e-14 | NR | KAK9810667.1 | 706552 | g72553 | i0 | 54.4 | 2.98543689320388 | 68 | 31 | 99 | 0 | 2 | 205 | 13 | 80 | KAK9810667.1 hypothetical protein WJX73_008788 [Symbiochloris irregularis] | diamond | 615 | 74.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 27661158 | 27661158 | PRJNA454503_P_NODE_45924_length_220_cov_1.459119_g45595_i0 | PRJNA454503 | 45924 | 220 | 1.459119 | 3.2100618 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 1.31e-8 | NR | KAL4855172.1 | 3077 | g45595 | i0 | 48.3 | 6.84545454545455 | 60 | 30 | 80.5 | 1 | 36 | 212 | 98 | 157 | KAL4855172.1 Oil body-associated protein 1A [Chlorella vulgaris] | diamond | 1506 | 60.8 | 0.995065789473684 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 27929032 | 27929032 | PRJNA454503_P_NODE_59325_length_210_cov_0.872483_g58996_i0 | PRJNA454503 | 59325 | 210 | 0.872483 | 1.8322143 | [Myrmecia] bisecta | 41462 | Plants | Plants | 67.4 | 5.05e-11 | NR | KAK9803026.1 | 41462 | g58996 | i0 | 44.8 | 3.92857142857143 | 67 | 37 | 95.7 | 0 | 7 | 207 | 802 | 868 | KAK9803026.1 hypothetical protein WJX72_005333 [[Myrmecia] bisecta] | diamond | 825 | 67.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 28687015 | 28687015 | PRJNA454503_P_NODE_38267_length_229_cov_1.369048_g37938_i0 | PRJNA454503 | 38267 | 229 | 1.369048 | 3.13511992 | Scenedesmus sp. PABB | 2909984 | Plants | Plants | 51.2 | 3.27e-5 | NR | KAF8061359.1 | 2742167 | g37938 | i0 | 50 | 1.36244541484716 | 60 | 21 | 77.3 | 2 | 220 | 44 | 5 | 56 | KAF8061359.1 gghA [Scenedesmus sp. PABB004] | diamond | 312 | 51.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. PABB004 | |
| 30644696 | 30644696 | PRJNA454503_P_NODE_54773_length_211_cov_0.866667_g54444_i0 | PRJNA454503 | 54773 | 211 | 0.866667 | 1.82866737 | [Myrmecia] bisecta | 41462 | Plants | Plants | 81.3 | 5.83e-18 | NR | KAK9811884.1 | 41462 | g54444 | i0 | 50.7 | 0.95260663507109 | 67 | 32 | 93.8 | 1 | 205 | 8 | 26 | 92 | KAK9811884.1 hypothetical protein WJX72_011786 [[Myrmecia] bisecta] | diamond | 201 | 81.3 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Myrmecia | [Myrmecia] bisecta | |
| 30819080 | 30819080 | PRJNA454503_P_NODE_75034_length_205_cov_0.902778_g74705_i0 | PRJNA454503 | 75034 | 205 | 0.902778 | 1.8506949 | Eukaryota | 2759 | Plants | Plants | 104 | 4.51e-25 | NR | KAK2075724.1 | 3111 | g74705 | i0 | 67.6 | 20.8829268292683 | 68 | 22 | 99.5 | 0 | 204 | 1 | 22 | 89 | KAK2075724.1 26S proteasome non-ATPase regulatory subunit 7 B [Prototheca wickerhamii] | diamond | 4281 | 104 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Prototheca | Prototheca wickerhamii | |
| 30882175 | 30882175 | PRJNA454503_P_NODE_72474_length_206_cov_0.896552_g72145_i0 | PRJNA454503 | 72474 | 206 | 0.896552 | 1.84689712 | Chlamydomonadales | 3042 | Plants | Plants | 70.5 | 3.81e-12 | NR | XP_001703012.1 | 3055 | g72145 | i0 | 55.2 | 8.78155339805825 | 67 | 27 | 96.1 | 2 | 198 | 1 | 154 | 218 | XP_001703012.1 uncharacterized protein CHLRE_12g514650v5 [Chlamydomonas reinhardtii] | diamond | 1809 | 71.2 | 0.990168539325843 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 32825806 | 32825806 | PRJNA454503_P_NODE_82120_length_203_cov_0.915493_g81791_i0 | PRJNA454503 | 82120 | 203 | 0.915493 | 1.85845079 | Picochlorum sp. BPE23 | 2696299 | Plants | Plants | 58.5 | 2.31e-8 | NR | KAI8109338.1 | 2696299 | g81791 | i0 | 48.4 | 1.89162561576355 | 64 | 33 | 94.6 | 0 | 3 | 194 | 114 | 177 | KAI8109338.1 hypothetical protein M9434_000622 [Picochlorum sp. BPE23] | diamond | 384 | 58.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Picochlorum | Picochlorum sp. BPE23 |
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);;