contig_metadata
21 rows where bioproject = "PRJNA683902" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 665250 | 665250 | PRJNA683902_S_NODE_20681_length_232_cov_2.702564_g20237_i0 | PRJNA683902 | 20681 | 232 | 2.702564 | 6.26994848 | Jenufa minuta | 993092 | Plants | Plants | 429 | 8.2e-116 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g20237 | i0 | 100 | 85.4396551724138 | 232 | 0 | 100 | 0 | 1 | 232 | 104901 | 104670 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 19822 | 429 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 665349 | 665349 | PRJNA683902_S_NODE_32281_length_170_cov_3.225564_g31837_i0 | PRJNA683902 | 32281 | 170 | 3.225564 | 5.4834588 | Jenufa minuta | 993092 | Plants | Plants | 315 | 1.64e-81 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g31837 | i0 | 100 | 165.952941176471 | 170 | 0 | 100 | 0 | 1 | 170 | 104132 | 103963 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 28212 | 315 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 2450817 | 2450817 | PRJNA683902_S_NODE_28762_length_183_cov_4.554795_g28318_i0 | PRJNA683902 | 28762 | 183 | 4.554795 | 8.33527485 | root | 1 | Root_unresolved | Root_unresolved | 339 | 1.07e-88 | NTclustered | gi|1714003650|gb|MN243923.1| | 3079 | g28318 | i0 | 100 | 100.153005464481 | 183 | 0 | 100 | 0 | 1 | 183 | 683 | 865 | Chlorella sp. isolate CAVR01 small subunit ribosomal RNA gene, partial sequence | blastn | 18328 | 339 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sp. | |
| 4493143 | 4493143 | PRJNA683902_S_NODE_16204_length_285_cov_3.923387_g15760_i0 | PRJNA683902 | 16204 | 285 | 3.923387 | 11.18165295 | Jenufa minuta | 993092 | Plants | Plants | 527 | 3.59e-145 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g15760 | i0 | 100 | 145.185964912281 | 285 | 0 | 100 | 0 | 1 | 285 | 103412 | 103128 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 41378 | 527 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 5768897 | 5768897 | PRJNA683902_S_NODE_24485_length_206_cov_1.319527_g24041_i0 | PRJNA683902 | 24485 | 206 | 1.319527 | 2.71822562 | Chlorophyta | 3041 | Plants | Plants | 97.8 | 4e-23 | NR | KAF6263477.1 | 2650976 | g24041 | i0 | 67.6 | 2.97087378640777 | 68 | 22 | 99 | 0 | 205 | 2 | 164 | 231 | KAF6263477.1 60S ribosomal protein L7 [Scenedesmus sp. NREL 46B-D3] | diamond | 612 | 97.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Scenedesmaceae | Scenedesmus | Scenedesmus sp. NREL 46B-D3 | |
| 7043980 | 7043980 | PRJNA683902_S_NODE_29166_length_181_cov_10.847222_g28722_i0 | PRJNA683902 | 29166 | 181 | 10.847222 | 19.63347182 | Aphanochaete magnum | 104531 | Plants | Plants | 268 | 1.3999999999999999e-67 | NTclustered | gi|6119989|gb|AF183449.1| | 104531 | g28722 | i0 | 93.37 | 100.038674033149 | 181 | 12 | 100 | 0 | 1 | 181 | 1789 | 1609 | Aphanochaete magnum strain UTEX B 1909 28S ribosomal RNA gene, partial sequence | blastn | 18107 | 268 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetophorales | Aphanochaetaceae | Aphanochaete | Aphanochaete magnum | |
| 7044020 | 7044020 | PRJNA683902_S_NODE_33766_length_165_cov_4.265625_g33322_i0 | PRJNA683902 | 33766 | 165 | 4.265625 | 7.03828125 | Jenufa minuta | 993092 | Plants | Plants | 305 | 9.59e-79 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g33322 | i0 | 100 | 129.212121212121 | 165 | 0 | 100 | 0 | 1 | 165 | 103821 | 103985 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 21320 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 9593829 | 9593829 | PRJNA683902_S_NODE_17068_length_272_cov_6.097872_g16624_i0 | PRJNA683902 | 17068 | 272 | 6.097872 | 16.58621184 | Micractinium reisseri | 532145 | Plants | Plants | 147 | 1.11e-30 | NTclustered | gi|297501471|dbj|AB506071.1| | 532145 | g16624 | i0 | 90.265 | 34.8308823529412 | 113 | 10 | 41 | 1 | 9 | 120 | 6453 | 6341 | Micractinium reisseri genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, clone: 2 | blastn | 9474 | 147 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium reisseri | |
| 12144713 | 12144713 | PRJNA683902_S_NODE_31490_length_173_cov_2.000000_g31046_i0 | PRJNA683902 | 31490 | 173 | 2 | 3.46 | uncultured Chloroidium | 1267198 | Plants | Plants | 270 | 3.69e-68 | NTclustered | gi|2515376813|gb|OR101670.1| | 1267198 | g31046 | i0 | 95.294 | 94.9248554913295 | 170 | 8 | 98 | 0 | 1 | 170 | 1147 | 1316 | Uncultured Chloroidium clone gcl123_AM09 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 | 16422 | 270 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | uncultured Chloroidium | |||
| 13419250 | 13419250 | PRJNA683902_S_NODE_25571_length_199_cov_5.098765_g25127_i0 | PRJNA683902 | 25571 | 199 | 5.098765 | 10.14654235 | Jenufa minuta | 993092 | Plants | Plants | 368 | 1.51e-97 | NTclustered | gi|325484952|gb|HM563744.1| | 993092 | g25127 | i0 | 100 | 96.9748743718593 | 199 | 0 | 100 | 0 | 1 | 199 | 660 | 858 | Jenufa minuta culture-collection CAUP<CZH>:H 8102 18S ribosomal RNA gene, partial sequence | blastn | 19298 | 368 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 14694277 | 14694277 | PRJNA683902_S_NODE_28572_length_184_cov_2.993197_g28128_i0 | PRJNA683902 | 28572 | 184 | 2.993197 | 5.50748248 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 200 | 5.3e-47 | NTclustered | gi|1360638125|gb|AC277041.1| | 574566 | g28128 | i0 | 87.719 | 13.3478260869565 | 171 | 21 | 93 | 0 | 14 | 184 | 39766 | 39596 | Coccomyxa subellipsoidea C-169 clone FAHX05-A01, complete sequence | blastn | 2456 | 200 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 14694318 | 14694318 | PRJNA683902_S_NODE_33192_length_167_cov_3.123077_g32748_i0 | PRJNA683902 | 33192 | 167 | 3.123077 | 5.21553859 | Chlamydomonadales | 3042 | Plants | Plants | 75.9 | 1.96e-14 | NR | KXZ53664.1 | 33097 | g32748 | i0 | 71.1 | 4.63473053892216 | 45 | 13 | 80.8 | 0 | 165 | 31 | 263 | 307 | KXZ53664.1 hypothetical protein GPECTOR_6g581 [Gonium pectorale] | diamond | 774 | 76.3 | 0.99475753604194 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale | |
| 18517577 | 18517577 | PRJNA683902_S_NODE_8775_length_532_cov_4.688889_g8352_i0 | PRJNA683902 | 8775 | 532 | 4.688889 | 24.94488948 | Jenufa minuta | 993092 | Plants | Plants | 773 | 0 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g8352 | i0 | 92.804 | 135.906015037594 | 542 | 26 | 100 | 9 | 1 | 532 | 103376 | 103914 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 72302 | 773 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 19027231 | 19027231 | PRJNA683902_S_NODE_29515_length_180_cov_2.314685_g29071_i0 | PRJNA683902 | 29515 | 180 | 2.314685 | 4.166433 | Coccomyxa | 41891 | Plants | Plants | 220 | 3.96e-53 | NTclustered | gi|1360638129|gb|AC277064.1| | 574566 | g29071 | i0 | 88.889 | 100.205555555556 | 180 | 19 | 100 | 1 | 1 | 180 | 1704 | 1526 | Coccomyxa subellipsoidea C-169 clone FAHX137-B20, complete sequence | blastn | 18037 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 24127600 | 24127600 | PRJNA683902_S_NODE_35079_length_162_cov_1.216000_g34635_i0 | PRJNA683902 | 35079 | 162 | 1.216 | 1.96992 | Ulotrichales | 31306 | Plants | Plants | 272 | 9.51e-69 | NTclustered | gi|557844178|gb|KF144222.1| | 160070 | g34635 | i0 | 97.484 | 98.1481481481482 | 159 | 4 | 98 | 0 | 3 | 161 | 658 | 816 | Tupiella akineta isolate WB20 18S ribosomal RNA gene, partial sequence | blastn | 15900 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Tupiellaceae | Tupiella | Tupiella akineta | |
| 24891382 | 24891382 | PRJNA683902_S_NODE_23080_length_214_cov_4.118644_g22636_i0 | PRJNA683902 | 23080 | 214 | 4.118644 | 8.81389816 | Jenufa minuta | 993092 | Plants | Plants | 390 | 3.519999999999999e-104 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g22636 | i0 | 99.533 | 110.060747663551 | 214 | 1 | 100 | 0 | 1 | 214 | 102917 | 103130 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 23553 | 390 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 24891434 | 24891434 | PRJNA683902_S_NODE_29800_length_179_cov_1.922535_g29356_i0 | PRJNA683902 | 29800 | 179 | 1.922535 | 3.44133765 | Jenufa minuta | 993092 | Plants | Plants | 307 | 2.9300000000000005e-79 | NTclustered | gi|959124355|ref|NC_028582.1| | 993092 | g29356 | i0 | 97.753 | 100.68156424581 | 178 | 4 | 99 | 0 | 2 | 179 | 93582 | 93405 | Jenufa minuta culture-collection CAUP:H 8102 chloroplast, complete genome | blastn | 18022 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Jenufa | Jenufa minuta | |||
| 27788846 | 27788846 | PRJNA683902_S_NODE_31144_length_174_cov_2.357664_g30700_i0 | PRJNA683902 | 31144 | 174 | 2.357664 | 4.10233536 | Eukaryota | 2759 | Plants | Plants | 44.3 | 0.00192 | NR | PRW34016.1 | 3076 | g30700 | i0 | 79.2 | 4.94827586206897 | 24 | 5 | 41.4 | 0 | 172 | 101 | 120 | 143 | PRW34016.1 60S ribosomal L23A [Chlorella sorokiniana] | diamond | 861 | 44.7 | 0.991051454138702 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 28609696 | 28609696 | PRJNA683902_S_NODE_27667_length_188_cov_5.834437_g27223_i0 | PRJNA683902 | 27667 | 188 | 5.834437 | 10.96874156 | Chlamydomonas | 3052 | Plants | Plants | 47 | 5.8e-4 | NR | XP_042923264.1 | 3055 | g27223 | i0 | 40.4 | 1.81914893617021 | 57 | 32 | 91 | 1 | 3 | 173 | 566 | 620 | XP_042923264.1 uncharacterized protein CHLRE_07g358001v5 [Chlamydomonas reinhardtii] | diamond | 342 | 47 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 29556741 | 29556741 | PRJNA683902_S_NODE_37290_length_156_cov_1.966387_g36846_i0 | PRJNA683902 | 37290 | 156 | 1.966387 | 3.06756372 | Eukaryota | 2759 | Plants | Plants | 46.2 | 5.59e-4 | NR | KAF5836938.1 | 3046 | g36846 | i0 | 51 | 6.26923076923077 | 49 | 22 | 90.4 | 1 | 150 | 10 | 7 | 55 | KAF5836938.1 ribosomal protein L10a component of cytosolic 80S ribosome and 60S large subunit [Dunaliella salina] | diamond | 978 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 31104709 | 31104709 | PRJNA683902_S_NODE_8795_length_531_cov_2.619433_g8372_i0 | PRJNA683902 | 8795 | 531 | 2.619433 | 13.90918923 | Chlorophyta | 3041 | Plants | Plants | 231 | 1.74e-66 | NR | PRW20811.1 | 3076 | g8372 | i0 | 69.6 | 7.41242937853107 | 148 | 45 | 83.6 | 0 | 529 | 86 | 172 | 319 | PRW20811.1 Receptor of activated kinase C component of 40S small ribosomal subunit isoform C [Chlorella sorokiniana] | diamond | 3936 | 232 | 0.995689655172414 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana |
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);;