contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA520845" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5591822 | 5591822 | PRJNA520845_P_NODE_133985_length_323_cov_0.928000_g132486_i0 | PRJNA520845 | 133985 | 323 | 0.928 | 2.99744 | Volvox carteri | 3067 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|302841786|ref|XM_002952392.1| | 3068 | g132486 | i0 | 96.875 | 0.0990712074303406 | 32 | 1 | 10 | 0 | 12 | 43 | 3063 | 3094 | Volvox carteri f. nagariensis uncharacterized protein (VOLCADRAFT_93041), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 6865798 | 6865798 | PRJNA520845_P_NODE_134506_length_322_cov_1.277108_g133007_i0 | PRJNA520845 | 134506 | 322 | 1.277108 | 4.11228776 | Monoraphidium neglectum | 145388 | Plants | Plants | 119 | 2.94e-22 | NTclustered | gi|926789080|ref|XM_014047560.1| | 145388 | g133007 | i0 | 97.143 | 1.18944099378882 | 70 | 2 | 22 | 0 | 248 | 317 | 767 | 698 | Monoraphidium neglectum elongation factor EF-2 mRNA | blastn | 383 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 6869253 | 6869253 | PRJNA520845_P_NODE_262386_length_242_cov_0.911243_g260887_i0 | PRJNA520845 | 262386 | 242 | 0.911243 | 2.20520806 | Chlamydomonas sp. TK-1983 | 3056 | Plants | Plants | 178 | 3.45e-40 | NTclustered | gi|174203|gb|K02345.1|CRERRA | 3056 | g260887 | i0 | 94.737 | 0.471074380165289 | 114 | 6 | 47 | 0 | 127 | 240 | 118 | 5 | Chlamydomonas sp. TK-1983 5S ribosomal RNA gene, complete sequence | blastn | 114 | 178 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas sp. TK-1983 | |
| 7489401 | 7489401 | PRJNA520845_P_NODE_159766_length_295_cov_0.896396_g158267_i0 | PRJNA520845 | 159766 | 295 | 0.896396 | 2.6443682 | Eukaryota | 2759 | Plants | Plants | 54.7 | 0.008 | NTclustered | gi|2082248479|ref|XM_043063354.1| | 3055 | g158267 | i0 | 100 | 3.53220338983051 | 29 | 0 | 10 | 0 | 146 | 174 | 2707 | 2679 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g286650v5), mRNA | blastn | 1042 | 54.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9415300 | 9415300 | PRJNA520845_P_NODE_101488_length_369_cov_1.560811_g99989_i0 | PRJNA520845 | 101488 | 369 | 1.560811 | 5.75939259 | Chlorella variabilis | 554065 | Plants | Plants | 196 | 1.53e-45 | NTclustered | gi|552845442|ref|XM_005851291.1| | 554065 | g99989 | i0 | 79.71 | 68.2466124661247 | 276 | 53 | 75 | 3 | 1 | 275 | 274 | 1 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_137537) mRNA, complete cds | blastn | 25183 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 11969934 | 11969934 | PRJNA520845_P_NODE_249030_length_244_cov_1.233918_g247531_i0 | PRJNA520845 | 249030 | 244 | 1.233918 | 3.01075992 | Dunaliella salina | 3046 | Plants | Plants | 233 | 7.319999999999999e-57 | NTclustered | gi|672094965|gb|KM008612.1| | 3046 | g247531 | i0 | 84.016 | 9.31147540983607 | 244 | 37 | 99 | 2 | 1 | 243 | 1126 | 884 | Dunaliella salina strain CCAP19/18 enolase mRNA, complete cds | blastn | 2272 | 233 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 13242816 | 13242816 | PRJNA520845_P_NODE_164431_length_290_cov_1.364055_g162932_i0 | PRJNA520845 | 164431 | 290 | 1.364055 | 3.9557595 | Polytomella sp. Pringsheim 198.80 | 37502 | Plants | Plants | 267 | 8.81e-67 | NTclustered | gi|27527738|emb|AJ416378.1| | 37502 | g162932 | i0 | 86.235 | 21.8241379310345 | 247 | 32 | 85 | 2 | 44 | 289 | 38 | 283 | Polytomella sp. 'Pringsheim 198.80' mRNA for mitochondrial cytochrome c (cyc gene) | blastn | 6329 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Polytomella | Polytomella sp. Pringsheim 198.80 | |
| 15792134 | 15792134 | PRJNA520845_P_NODE_18613_length_899_cov_8.444310_g17371_i0 | PRJNA520845 | 18613 | 899 | 8.44431 | 75.9143469 | Volvox carteri | 3067 | Plants | Plants | 259 | 4.98e-64 | NTclustered | gi|302840791|ref|XM_002951896.1| | 3068 | g17371 | i0 | 77.986 | 3.0789766407119 | 427 | 84 | 47 | 7 | 455 | 876 | 452 | 31 | Volvox carteri f. nagariensis component of cytosolic 80S ribosome and 60S large subunit (rpl19), mRNA | blastn | 2768 | 259 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Volvox | Volvox carteri | |
| 15792803 | 15792803 | PRJNA520845_P_NODE_209753_length_254_cov_1.116022_g208254_i0 | PRJNA520845 | 209753 | 254 | 1.116022 | 2.83469588 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 226 | 1.2799999999999999e-54 | NTclustered | gi|2082268575|ref|XM_001695756.2| | 3055 | g208254 | i0 | 84.348 | 8.3503937007874 | 230 | 36 | 91 | 0 | 25 | 254 | 131 | 360 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_16g672650v5), mRNA | blastn | 2121 | 226 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 17068402 | 17068402 | PRJNA520845_P_NODE_249754_length_244_cov_0.900585_g248255_i0 | PRJNA520845 | 249754 | 244 | 0.900585 | 2.1974274 | Chlorella variabilis | 554065 | Plants | Plants | 274 | 4.31e-69 | NTclustered | gi|552821707|ref|XM_005845861.1| | 554065 | g248255 | i0 | 87.19 | 3.96311475409836 | 242 | 29 | 99 | 2 | 4 | 244 | 822 | 582 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_53648) mRNA, complete cds | blastn | 967 | 274 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 18340147 | 18340147 | PRJNA520845_P_NODE_150155_length_305_cov_0.995690_g148656_i0 | PRJNA520845 | 150155 | 305 | 0.99569 | 3.0368545 | Dunaliella salina | 3046 | Plants | Plants | 246 | 1.22e-60 | NTclustered | gi|2599103|gb|AF028833.1|AF028833 | 3046 | g148656 | i0 | 82.796 | 3.63934426229508 | 279 | 44 | 91 | 4 | 3 | 279 | 293 | 569 | Dunaliella salina 60S ribosomal protein (DSRP1) mRNA, complete cds | blastn | 1110 | 246 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella salina | |
| 18341377 | 18341377 | PRJNA520845_P_NODE_195075_length_266_cov_1.196891_g193576_i0 | PRJNA520845 | 195075 | 266 | 1.196891 | 3.18373006 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 121 | 6.57e-23 | NTclustered | gi|2082247485|ref|XM_001696149.2| | 3055 | g193576 | i0 | 83.206 | 6.73308270676692 | 131 | 22 | 49 | 0 | 29 | 159 | 261 | 391 | Chlamydomonas reinhardtii ribosomal protein S8 (CHLRE_06g272800v5), mRNA | blastn | 1791 | 121 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18341861 | 18341861 | PRJNA520845_P_NODE_212935_length_251_cov_1.320225_g211436_i0 | PRJNA520845 | 212935 | 251 | 1.320225 | 3.31376475 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 233 | 7.569999999999999e-57 | NTclustered | gi|760439386|ref|XM_011398460.1| | 3075 | g211436 | i0 | 84.426 | 21.6135458167331 | 244 | 30 | 96 | 8 | 7 | 246 | 1242 | 1003 | Auxenochlorella protothecoides Fumarate hydratase 2, chloroplastic partial mRNA | blastn | 5425 | 233 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 18344428 | 18344428 | PRJNA520845_P_NODE_74155_length_431_cov_2.284916_g72656_i0 | PRJNA520845 | 74155 | 431 | 2.284916 | 9.84798796 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 52.8 | 0.042 | NTclustered | gi|1358957427|gb|AC276955.1| | 3055 | g72656 | i0 | 100 | 0.129930394431555 | 28 | 0 | 6 | 0 | 295 | 322 | 10645 | 10672 | Chlamydomonas reinhardtii clone VTP473-H09, complete sequence | blastn | 56 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 19613845 | 19613845 | PRJNA520845_P_NODE_124636_length_334_cov_1.770115_g123137_i0 | PRJNA520845 | 124636 | 334 | 1.770115 | 5.9121841 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 63.9 | 1.45e-5 | NTclustered | gi|2082238366|ref|XM_043059241.1| | 3055 | g123137 | i0 | 91.304 | 0.137724550898204 | 46 | 4 | 14 | 0 | 164 | 209 | 1556 | 1511 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_02g081250v5), mRNA | blastn | 46 | 63.9 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22167460 | 22167460 | PRJNA520845_P_NODE_231818_length_248_cov_0.880000_g230319_i0 | PRJNA520845 | 231818 | 248 | 0.88 | 2.1824 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 65.8 | 2.88e-6 | NTclustered | gi|2082255382|ref|XM_043066205.1| | 3055 | g230319 | i0 | 86.667 | 13.3991935483871 | 60 | 7 | 24 | 1 | 32 | 91 | 2125 | 2067 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_09g407400v5), mRNA | blastn | 3323 | 65.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 22788170 | 22788170 | PRJNA520845_P_NODE_111878_length_352_cov_1.193548_g110379_i0 | PRJNA520845 | 111878 | 352 | 1.193548 | 4.20128896 | Eukaryota | 2759 | Plants | Plants | 302 | 2.99e-77 | NTclustered | gi|2082243702|ref|XM_043061450.1| | 3055 | g110379 | i0 | 82.303 | 86.2471590909091 | 356 | 55 | 100 | 8 | 1 | 352 | 1024 | 1375 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g204250v5), mRNA | blastn | 30359 | 305 | 0.99016393442623 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 24063021 | 24063021 | PRJNA520845_P_NODE_102859_length_367_cov_1.047619_g101360_i0 | PRJNA520845 | 102859 | 367 | 1.047619 | 3.84476173 | Eukaryota | 2759 | Plants | Plants | 200 | 1.18e-46 | NTclustered | gi|2082239556|ref|XM_001699745.2| | 3055 | g101360 | i0 | 78.641 | 41.7656675749319 | 309 | 60 | 83 | 5 | 1 | 306 | 388 | 83 | Chlamydomonas reinhardtii ribosomal protein S3 (CHLRE_02g102250v5), mRNA | blastn | 15328 | 200 | 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);;