contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA1118794" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 230875 | 230875 | PRJNA1118794_P_NODE_53601_length_249_cov_0.875000_g52851_i0 | PRJNA1118794 | 53601 | 249 | 0.875 | 2.17875 | Mantoniella tinhauana | 3097027 | Plants | Plants | 215 | 2.72e-51 | NTclustered | gi|2735153280|gb|CP140065.1| | 3097027 | g52851 | i0 | 83.333 | 62.7630522088353 | 234 | 37 | 94 | 2 | 17 | 249 | 408673 | 408905 | Mantoniella tinhauana isolate LFS chromosome 4 | blastn | 15628 | 215 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Mantoniella | Mantoniella tinhauana | ||
| 1505717 | 1505717 | PRJNA1118794_P_NODE_60742_length_246_cov_0.890173_g59992_i0 | PRJNA1118794 | 60742 | 246 | 0.890173 | 2.18982558 | Kirchneriella aperta | 117505 | Plants | Plants | 52.8 | 0.022 | NTclustered | gi|1008861801|ref|NC_029676.1| | 117505 | g59992 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 205 | 232 | 21802 | 21775 | Kirchneriella aperta strain SAG 2004 chloroplast, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Kirchneriella | Kirchneriella aperta | |
| 2781323 | 2781323 | PRJNA1118794_P_NODE_43343_length_261_cov_2.861702_g42593_i0 | PRJNA1118794 | 43343 | 261 | 2.861702 | 7.46904222 | Balticola zimbabwiensis | 51690 | Plants | Plants | 117 | 8.32e-22 | NTclustered | gi|6120015|gb|AF183475.1| | 51690 | g42593 | i0 | 91.765 | 31.4406130268199 | 85 | 3 | 32 | 4 | 179 | 261 | 1903 | 1821 | Balticola zimbabwiensis strain UTEX LB 1758 28S ribosomal RNA gene, partial sequence | blastn | 8206 | 117 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Balticola | Balticola zimbabwiensis | |
| 2781341 | 2781341 | PRJNA1118794_P_NODE_44903_length_258_cov_1.610811_g44153_i0 | PRJNA1118794 | 44903 | 258 | 1.610811 | 4.15589238 | Volvox carteri | 3067 | Plants | Plants | 137 | 6.300000000000001e-28 | NTclustered | gi|302843775|ref|XM_002953383.1| | 3068 | g44153 | i0 | 83.562 | 20.562015503876 | 146 | 24 | 57 | 0 | 82 | 227 | 65 | 210 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_105955), partial mRNA | blastn | 5305 | 137 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 5333512 | 5333512 | PRJNA1118794_P_NODE_23445_length_320_cov_1.518219_g22695_i0 | PRJNA1118794 | 23445 | 320 | 1.518219 | 4.8583008 | Gloeomonas rubrifilum | 158506 | Plants | Plants | 56.5 | 0.002 | NTclustered | gi|1375380782|dbj|LC360481.1| | 158506 | g22695 | i0 | 100 | 0.18125 | 30 | 0 | 9 | 0 | 109 | 138 | 1458 | 1487 | Gloeomonas rubrifilum SAG 3.85 gene for 26S ribosomal RNA, partial sequence | blastn | 58 | 56.5 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Gloeomonas | Gloeomonas rubrifilum | |
| 6608653 | 6608653 | PRJNA1118794_P_NODE_31966_length_287_cov_1.383178_g31216_i0 | PRJNA1118794 | 31966 | 287 | 1.383178 | 3.96972086 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 54.7 | 0.007 | NTclustered | gi|760442864|ref|XM_011400199.1| | 3075 | g31216 | i0 | 83.929 | 0.195121951219512 | 56 | 9 | 20 | 0 | 212 | 267 | 1184 | 1129 | Auxenochlorella protothecoides Heat shock protein 90-2 partial mRNA | blastn | 56 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 6608802 | 6608802 | PRJNA1118794_P_NODE_43846_length_260_cov_2.139037_g43096_i0 | PRJNA1118794 | 43846 | 260 | 2.139037 | 5.5614962 | Phyllosiphon coccidium | 1837062 | Plants | Plants | 324 | 4.55e-84 | NTclustered | gi|2473928268|ref|NC_072900.1| | 1837062 | g43096 | i0 | 89.189 | 89.6115384615385 | 259 | 28 | 99 | 0 | 2 | 260 | 123251 | 122993 | Phyllosiphon coccidium clone S213 chloroplast, complete genome | blastn | 23299 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Phyllosiphon | Phyllosiphon coccidium | |
| 6609058 | 6609058 | PRJNA1118794_P_NODE_67086_length_243_cov_1.800000_g66336_i0 | PRJNA1118794 | 67086 | 243 | 1.8 | 4.374 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 139 | 1.63e-28 | NTclustered | gi|545355296|ref|XM_005643393.1| | 574566 | g66336 | i0 | 80.435 | 82.4609053497942 | 184 | 34 | 75 | 2 | 61 | 243 | 1732 | 1550 | Coccomyxa subellipsoidea C-169 heat shock protein 70 mRNA | blastn | 20038 | 139 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 7402803 | 7402803 | PRJNA1118794_P_NODE_36346_length_276_cov_3.931034_g35596_i0 | PRJNA1118794 | 36346 | 276 | 3.931034 | 10.84965384 | Opisthokonta | 33154 | Plants | Plants | 99 | 3.21e-16 | NTclustered | gi|612395756|ref|XM_007513336.1| | 41875 | g35596 | i0 | 80.303 | 1.98913043478261 | 132 | 24 | 47 | 2 | 48 | 178 | 41 | 171 | Bathycoccus prasinos 40S ribosomal protein S29 (Bathy04g01450), partial mRNA | blastn | 549 | 100 | 0.99 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Bathycoccaceae | Bathycoccus | Bathycoccus prasinos | ||
| 9158540 | 9158540 | PRJNA1118794_P_NODE_4408_length_676_cov_4.645108_g3690_i0 | PRJNA1118794 | 4408 | 676 | 4.645108 | 31.40093008 | Chlamydomonas incerta | 51695 | Plants | Plants | 396 | 2.7e-105 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g3690 | i0 | 79.89 | 6.30621301775148 | 547 | 104 | 80 | 6 | 96 | 639 | 572 | 29 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 4263 | 396 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 9953270 | 9953270 | PRJNA1118794_P_NODE_9148_length_466_cov_3.356234_g8400_i0 | PRJNA1118794 | 9148 | 466 | 3.356234 | 15.64005044 | Eukaryota | 2759 | Plants | Plants | 233 | 1.5099999999999998e-56 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g8400 | i0 | 78.689 | 42.0944206008584 | 366 | 67 | 78 | 10 | 89 | 450 | 190 | 548 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 19616 | 233 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 10434465 | 10434465 | PRJNA1118794_P_NODE_63669_length_245_cov_0.895349_g62919_i0 | PRJNA1118794 | 63669 | 245 | 0.895349 | 2.19360505 | Capsosiphon fulvescens | 205396 | Plants | Plants | 298 | 2.57e-76 | NTclustered | gi|1514830526|gb|MH790907.1| | 205396 | g62919 | i0 | 89.121 | 103.416326530612 | 239 | 26 | 98 | 0 | 2 | 240 | 3746 | 3984 | Capsosiphon fulvescens clone 5+6_typeB chloroplast sequence | blastn | 25337 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulotrichales | Ulotrichaceae | Capsosiphon | Capsosiphon fulvescens | |
| 14259433 | 14259433 | PRJNA1118794_P_NODE_19632_length_341_cov_1.130597_g18882_i0 | PRJNA1118794 | 19632 | 341 | 1.130597 | 3.85533577 | Polulichloris maxima | 2704661 | Plants | Plants | 479 | 1.25e-130 | NTclustered | gi|2473928686|ref|NC_072905.1| | 2704661 | g18882 | i0 | 92.082 | 149.445747800587 | 341 | 25 | 99 | 2 | 1 | 339 | 126269 | 125929 | Polulichloris maxima clone L123 chloroplast, complete genome | blastn | 50961 | 479 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Polulichloris | Polulichloris maxima | |
| 14259887 | 14259887 | PRJNA1118794_P_NODE_55852_length_248_cov_0.880000_g55102_i0 | PRJNA1118794 | 55852 | 248 | 0.88 | 2.1824 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 62.1 | 3.73e-5 | NTclustered | gi|545365919|ref|XM_005647835.1| | 574566 | g55102 | i0 | 95 | 2.41129032258065 | 40 | 1 | 16 | 1 | 56 | 94 | 447 | 408 | Coccomyxa subellipsoidea C-169 hypothetical protein partial mRNA | blastn | 598 | 62.1 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 15533166 | 15533166 | PRJNA1118794_P_NODE_27193_length_304_cov_1.129870_g26443_i0 | PRJNA1118794 | 27193 | 304 | 1.12987 | 3.4348048 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 180 | 1.25e-40 | NTclustered | gi|760437194|ref|XM_011397364.1| | 3075 | g26443 | i0 | 83 | 7.45394736842105 | 200 | 32 | 65 | 2 | 49 | 247 | 439 | 241 | Auxenochlorella protothecoides 40S ribosomal protein S3a partial mRNA | blastn | 2266 | 180 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18876564 | 18876564 | PRJNA1118794_P_NODE_16515_length_363_cov_1.058621_g15765_i0 | PRJNA1118794 | 16515 | 363 | 1.058621 | 3.84279423 | Eukaryota | 2759 | Plants | Plants | 161 | 5.479999999999998e-35 | NTclustered | gi|2082249559|ref|XM_043063790.1| | 3055 | g15765 | i0 | 81.683 | 38.2176308539945 | 202 | 29 | 55 | 8 | 116 | 313 | 155 | 352 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g310700v5), mRNA | blastn | 13873 | 161 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 20631760 | 20631760 | PRJNA1118794_P_NODE_35637_length_278_cov_1.639024_g34887_i0 | PRJNA1118794 | 35637 | 278 | 1.639024 | 4.55648672 | Micromonas commoda | 296587 | Plants | Plants | 108 | 5.38e-19 | NTclustered | gi|255072416|ref|XM_002499837.1| | 296587 | g34887 | i0 | 91.139 | 14.8345323741007 | 79 | 7 | 28 | 0 | 10 | 88 | 327 | 249 | Micromonas commoda predicted protein mRNA | blastn | 4124 | 108 | 1 | Eukaryota | Viridiplantae | Chlorophyta | Mamiellophyceae | Mamiellales | Mamiellaceae | Micromonas | Micromonas commoda | ||
| 21907339 | 21907339 | PRJNA1118794_P_NODE_18338_length_349_cov_1.673913_g17588_i0 | PRJNA1118794 | 18338 | 349 | 1.673913 | 5.84195637 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 263 | 1.4e-65 | NTclustered | gi|2082238339|ref|XM_001701832.2| | 3055 | g17588 | i0 | 81.703 | 76.4928366762178 | 317 | 56 | 91 | 2 | 1 | 316 | 1203 | 888 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g080600v5), mRNA | blastn | 26696 | 263 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22701816 | 22701816 | PRJNA1118794_P_NODE_16738_length_361_cov_1.055556_g15988_i0 | PRJNA1118794 | 16738 | 361 | 1.055556 | 3.81055716 | Ulva | 3118 | Plants | Plants | 52.8 | 0.034 | NTclustered | gi|2895119976|gb|PV023352.1| | 83797 | g15988 | i0 | 100 | 0.310249307479224 | 28 | 0 | 8 | 0 | 324 | 351 | 66290 | 66317 | Ulva taeniata mitochondrion, complete genome | blastn | 112 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Ulvales | Ulvaceae | Ulva | Ulva taeniata | |
| 24457287 | 24457287 | PRJNA1118794_P_NODE_71380_length_242_cov_0.911243_g70630_i0 | PRJNA1118794 | 71380 | 242 | 0.911243 | 2.20520806 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 278 | 3.3e-70 | NTclustered | gi|2082235498|ref|XM_001700320.2| | 3055 | g70630 | i0 | 87.764 | 76.0619834710744 | 237 | 29 | 98 | 0 | 1 | 237 | 51 | 287 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g002300v5), mRNA | blastn | 18407 | 278 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii |
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);;