contig_metadata
22 rows where bioproject = "PRJEB73599" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2270629 | 2270629 | PRJEB73599_P_NODE_7122_length_215_cov_3.586022_g6835_i0 | PRJEB73599 | 7122 | 215 | 3.586022 | 7.7099473 | Chlorophyceae | 3166 | Plants | Plants | 364 | 2.139999999999999e-96 | NTclustered | gi|15281674|gb|AF395514.1| | 106201 | g6835 | i0 | 97.209 | 99.9906976744186 | 215 | 6 | 100 | 0 | 1 | 215 | 1465 | 1679 | Tetraspora sp. UTEX-LB 234 strain UTEX LB 234 26S ribosomal RNA gene, partial sequence | blastn | 21498 | 364 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Tetrasporales | Tetrasporaceae | Tetraspora | Tetraspora sp. UTEX-LB 234 | |
| 2685230 | 2685230 | PRJEB73599_P_NODE_1603_length_588_cov_3.228980_g1382_i0 | PRJEB73599 | 1603 | 588 | 3.22898 | 18.9864024 | Hafniomonas laevis | 436124 | Plants | Plants | 324 | 1.12e-83 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1382 | i0 | 82.368 | 42.1292517006803 | 397 | 46 | 92 | 12 | 1 | 382 | 135027 | 134640 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 24772 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 3961277 | 3961277 | PRJEB73599_P_NODE_3964_length_348_cov_2.686520_g3677_i0 | PRJEB73599 | 3964 | 348 | 2.68652 | 9.3490896 | Hafniomonas laevis | 436124 | Plants | Plants | 473 | 5.94e-129 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g3677 | i0 | 94.481 | 112.324712643678 | 308 | 16 | 89 | 1 | 40 | 347 | 136949 | 137255 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 39089 | 473 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 5237709 | 5237709 | PRJEB73599_P_NODE_2045_length_517_cov_3.536885_g1793_i0 | PRJEB73599 | 2045 | 517 | 3.536885 | 18.28569545 | Hafniomonas laevis | 436124 | Plants | Plants | 494 | 7e-135 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1793 | i0 | 84.211 | 131.056092843327 | 532 | 58 | 99 | 14 | 2 | 517 | 134506 | 135027 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 67756 | 494 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 9062430 | 9062430 | PRJEB73599_P_NODE_2248_length_492_cov_2.492441_g1989_i0 | PRJEB73599 | 2248 | 492 | 2.492441 | 12.26280972 | Hafniomonas laevis | 436124 | Plants | Plants | 634 | 3.749999999999999e-177 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g1989 | i0 | 91.045 | 144.591463414634 | 469 | 42 | 95 | 0 | 24 | 492 | 133000 | 132532 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 71139 | 634 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 9062431 | 9062431 | PRJEB73599_P_NODE_2428_length_473_cov_2.157658_g2161_i0 | PRJEB73599 | 2428 | 473 | 2.157658 | 10.20572234 | Symbiochloris irregularis | 706552 | Plants | Plants | 188 | 4.82e-52 | NR | KAK9789544.1 | 706552 | g2161 | i0 | 69.9 | 0.780126849894292 | 123 | 37 | 78 | 0 | 2 | 370 | 932 | 1054 | KAK9789544.1 hypothetical protein WJX73_004313 [Symbiochloris irregularis] | diamond | 369 | 188 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Symbiochloris | Symbiochloris irregularis | |
| 9062489 | 9062489 | PRJEB73599_P_NODE_9288_length_166_cov_1.635036_g9001_i0 | PRJEB73599 | 9288 | 166 | 1.635036 | 2.71415976 | Hafniomonas laevis | 436124 | Plants | Plants | 235 | 1.2899999999999998e-57 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g9001 | i0 | 95.302 | 9.44578313253012 | 149 | 6 | 91 | 1 | 1 | 148 | 130761 | 130909 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 1568 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 11198814 | 11198814 | PRJEB73599_P_NODE_7369_length_207_cov_4.747191_g7082_i0 | PRJEB73599 | 7369 | 207 | 4.747191 | 9.82668537 | Hydrodictyaceae | 3103 | Plants | Plants | 150 | 6.24e-32 | NTclustered | gi|21040380|gb|AF183479.2| | 3105 | g7082 | i0 | 79.907 | 27.1304347826087 | 214 | 35 | 100 | 8 | 1 | 207 | 3241 | 3029 | Pediastrum duplex strain UTEX LB 1364 28S ribosomal RNA gene, partial sequence | blastn | 5616 | 150 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pediastrum | Pediastrum duplex | |
| 11198820 | 11198820 | PRJEB73599_P_NODE_9049_length_170_cov_2.099291_g8762_i0 | PRJEB73599 | 9049 | 170 | 2.099291 | 3.5687947 | Chlorophyceae | 3166 | Plants | Plants | 180 | 6.25e-41 | NTclustered | gi|9438172|gb|AF277656.1| | 132190 | g8762 | i0 | 91.538 | 78.8705882352941 | 130 | 11 | 76 | 0 | 41 | 170 | 433 | 304 | Pseudoschroederia antillarum culture SAG:15.86 strain SAG B 15.86 28S ribosomal RNA gene, partial sequence | blastn | 13408 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Schroederiaceae | Pseudoschroederia | Pseudoschroederia antillarum | |
| 12474464 | 12474464 | PRJEB73599_P_NODE_7670_length_199_cov_5.000000_g7383_i0 | PRJEB73599 | 7670 | 199 | 5 | 9.95 | Chlamydomonadaceae | 3051 | Plants | Plants | 272 | 1.2199999999999999e-68 | NTclustered | gi|66864302|gb|DQ015757.1| | 158507 | g7383 | i0 | 93.048 | 43.6482412060301 | 187 | 12 | 93 | 1 | 14 | 199 | 3228 | 3042 | Oogamochlamys gigantea strain SAG 44.91 26S ribosomal RNA gene, partial sequence | blastn | 8686 | 274 | 0.992700729927007 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Oogamochlamys | Oogamochlamys gigantea | |
| 12888713 | 12888713 | PRJEB73599_P_NODE_2751_length_440_cov_3.963504_g2474_i0 | PRJEB73599 | 2751 | 440 | 3.963504 | 17.4394176 | Hafniomonas laevis | 436124 | Plants | Plants | 518 | 3.4899999999999996e-142 | NTclustered | gi|959124445|ref|NC_028583.1| | 436124 | g2474 | i0 | 93.642 | 126.170454545455 | 346 | 22 | 95 | 0 | 3 | 348 | 135515 | 135170 | Hafniomonas laevis culture-collection NIES:257 chloroplast, complete genome | blastn | 55515 | 518 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Hafniomonas | Hafniomonas laevis | |
| 12888745 | 12888745 | PRJEB73599_P_NODE_5611_length_265_cov_3.394068_g5324_i0 | PRJEB73599 | 5611 | 265 | 3.394068 | 8.9942802 | Stephanosphaera pluvialis | 51712 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|952954307|gb|KT625385.1| | 51712 | g5324 | i0 | 100 | 20.0377358490566 | 30 | 0 | 11 | 0 | 236 | 265 | 2202 | 2173 | Stephanosphaera pluvialis clone contig-65e chloroplast, partial genome | blastn | 5310 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Stephanosphaera | Stephanosphaera pluvialis | |
| 15437662 | 15437662 | PRJEB73599_P_NODE_5113_length_286_cov_11.684825_g4826_i0 | PRJEB73599 | 5113 | 286 | 11.684825 | 33.4185995 | Pseudopediastrum boryanum | 55410 | Plants | Plants | 438 | 1.7399999999999996e-118 | NTclustered | gi|1388162763|gb|MF276983.1| | 55410 | g4826 | i0 | 94.406 | 131.269230769231 | 286 | 15 | 100 | 1 | 1 | 286 | 95722 | 95438 | Pseudopediastrum boryanum chloroplast, complete genome | blastn | 37543 | 438 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Hydrodictyaceae | Pseudopediastrum | Pseudopediastrum boryanum | |
| 16298160 | 16298160 | PRJEB73599_P_NODE_7613_length_201_cov_2.110465_g7326_i0 | PRJEB73599 | 7613 | 201 | 2.110465 | 4.24203465 | Chlamydomonadales | 3042 | Plants | Plants | 263 | 7.419999999999999e-66 | NTclustered | gi|397121|emb|X68924.1| | 133709 | g7326 | i0 | 95.21 | 129.124378109453 | 167 | 7 | 83 | 1 | 2 | 167 | 570 | 404 | Chloroplast Chlamydomonas sp. 66.72 rrnL gene, exon 2 | blastn | 25954 | 265 | 0.992452830188679 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. 66.72 | |
| 17986785 | 17986785 | PRJEB73599_P_NODE_6995_length_219_cov_3.147368_g6708_i0 | PRJEB73599 | 6995 | 219 | 3.147368 | 6.89273592 | Chlamydomonas sp. UWO 241 | 1653778 | Plants | Plants | 265 | 2.29e-66 | NTclustered | gi|822624806|gb|KP313859.1| | 1653778 | g6708 | i0 | 88.584 | 35.9315068493151 | 219 | 24 | 100 | 1 | 1 | 219 | 6382 | 6165 | Chlamydomonas sp. UWO 241 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7869 | 265 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. UWO 241 | |
| 24361037 | 24361037 | PRJEB73599_P_NODE_9140_length_168_cov_4.028777_g8853_i0 | PRJEB73599 | 9140 | 168 | 4.028777 | 6.76834536 | Corbierea radiosa | 51318 | Plants | Plants | 305 | 9.81e-79 | NTclustered | gi|18654306|gb|L42987.1|RTCCPRGOLB | 51318 | g8853 | i0 | 100 | 133.642857142857 | 165 | 0 | 98 | 0 | 4 | 168 | 1717 | 1553 | Carteria radiosa large subunit ribosomal RNA gene, complete sequence; chloroplast gene for chloroplast product | blastn | 22452 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Corbierea | Corbierea radiosa | |
| 27627367 | 27627367 | PRJEB73599_P_NODE_7224_length_212_cov_2.398907_g6937_i0 | PRJEB73599 | 7224 | 212 | 2.398907 | 5.08568284 | root | 1 | Root_unresolved | Root_unresolved | 76.3 | 3.83e-14 | NR | XP_002954858.1 | 3068 | g6937 | i0 | 65.4 | 50.1367924528302 | 52 | 18 | 73.6 | 0 | 212 | 57 | 702 | 753 | XP_002954858.1 uncharacterized protein VOLCADRAFT_76494 [Volvox carteri f. nagariensis] | diamond | 10629 | 76.6 | 0.996083550913838 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 27816861 | 27816861 | PRJEB73599_P_NODE_5184_length_284_cov_1.898039_g4897_i0 | PRJEB73599 | 5184 | 284 | 1.898039 | 5.39043076 | Eukaryota | 2759 | Plants | Plants | 96.3 | 9.53e-21 | NR | PRW20411.1 | 3076 | g4897 | i0 | 70.7 | 11.0492957746479 | 58 | 17 | 61.3 | 0 | 176 | 3 | 648 | 705 | PRW20411.1 elongation factor EF-3 isoform B [Chlorella sorokiniana] | diamond | 3138 | 97.1 | 0.991761071060762 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28581781 | 28581781 | PRJEB73599_P_NODE_7067_length_217_cov_1.936170_g6780_i0 | PRJEB73599 | 7067 | 217 | 1.93617 | 4.2014889 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 69.3 | 2.8e-12 | NR | KAK3256391.1 | 36881 | g6780 | i0 | 57.4 | 0.746543778801843 | 54 | 22 | 74.7 | 1 | 1 | 162 | 54 | 106 | KAK3256391.1 hypothetical protein CYMTET_34473 [Cymbomonas tetramitiformis] | diamond | 162 | 69.3 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 29869005 | 29869005 | PRJEB73599_P_NODE_2851_length_431_cov_2.223881_g2572_i0 | PRJEB73599 | 2851 | 431 | 2.223881 | 9.58492711 | Eukaryota | 2759 | Plants | Plants | 114 | 2.82e-26 | NR | KAI3438154.1 | 3077 | g2572 | i0 | 52.3 | 2.26914153132251 | 109 | 51 | 75.2 | 1 | 326 | 3 | 313 | 421 | KAI3438154.1 hypothetical protein D9Q98_000592 [Chlorella vulgaris] | diamond | 978 | 114 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris | |
| 30350615 | 30350615 | PRJEB73599_P_NODE_7372_length_207_cov_2.882022_g7085_i0 | PRJEB73599 | 7372 | 207 | 2.882022 | 5.96578554 | Cymbomonas tetramitiformis | 36881 | Plants | Plants | 62 | 3.5e-10 | NR | KAK3254765.1 | 36881 | g7085 | i0 | 58.1 | 0.898550724637681 | 62 | 25 | 88.4 | 1 | 185 | 3 | 7 | 68 | KAK3254765.1 hypothetical protein CYMTET_36031 [Cymbomonas tetramitiformis] | diamond | 186 | 62 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Pyramimonadophyceae | Pyramimonadales | Pyramimonadaceae | Cymbomonas | Cymbomonas tetramitiformis | ||
| 31297989 | 31297989 | PRJEB73599_P_NODE_7395_length_207_cov_1.325843_g7108_i0 | PRJEB73599 | 7395 | 207 | 1.325843 | 2.74449501 | Trebouxia sp. C | 2796353 | Plants | Plants | 99.8 | 5.68e-23 | NR | KAL0049813.1 | 2905655 | g7108 | i0 | 62.7 | 1.94202898550725 | 67 | 25 | 97.1 | 0 | 203 | 3 | 207 | 273 | KAL0049813.1 hypothetical protein WJX82_010375 [Trebouxia sp. C0006] | diamond | 402 | 99.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);;