contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA800090" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2074964 | 2074964 | PRJNA800090_P_NODE_48742_length_515_cov_1.221973_g46562_i0 | PRJNA800090 | 48742 | 515 | 1.221973 | 6.29316095 | Chlamydomonas incerta | 51695 | Plants | Plants | 387 | 1.22e-102 | NTclustered | gi|74272606|gb|DQ122868.1| | 51695 | g46562 | i0 | 81.957 | 51.4582524271845 | 460 | 79 | 89 | 4 | 22 | 479 | 29 | 486 | Chlamydomonas incerta 40S ribosomal protein S3 mRNA, complete cds | blastn | 26501 | 387 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas incerta | |
| 4627107 | 4627107 | PRJNA800090_P_NODE_25724_length_773_cov_1.386364_g23753_i0 | PRJNA800090 | 25724 | 773 | 1.386364 | 10.71659372 | Chlorella variabilis | 554065 | Plants | Plants | 477 | 1.0799999999999996e-129 | NTclustered | gi|552830805|ref|XM_005847928.1| | 554065 | g23753 | i0 | 78.755 | 82.1280724450194 | 739 | 138 | 94 | 14 | 1 | 725 | 907 | 174 | Chlorella variabilis hypothetical protein (RACK1) mRNA, complete cds | blastn | 63485 | 477 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 8452209 | 8452209 | PRJNA800090_P_NODE_51207_length_499_cov_1.241860_g49025_i0 | PRJNA800090 | 51207 | 499 | 1.24186 | 6.1968814 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 252 | 4.4799999999999995e-62 | NTclustered | gi|2082260161|ref|XM_001690941.2| | 3055 | g49025 | i0 | 79.301 | 36.2444889779559 | 372 | 68 | 74 | 8 | 85 | 453 | 193 | 558 | Chlamydomonas reinhardtii ribosomal protein S23 (CHLRE_12g504200v5), mRNA | blastn | 18086 | 252 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 9725430 | 9725430 | PRJNA800090_P_NODE_145808_length_260_cov_1.528796_g143623_i0 | PRJNA800090 | 145808 | 260 | 1.528796 | 3.9748696 | Monoraphidium neglectum | 145388 | Plants | Plants | 111 | 3.85e-20 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g143623 | i0 | 77.717 | 11.0615384615385 | 184 | 39 | 70 | 2 | 1 | 183 | 237 | 55 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 2876 | 111 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 11001338 | 11001338 | PRJNA800090_P_NODE_150389_length_256_cov_0.898396_g148204_i0 | PRJNA800090 | 150389 | 256 | 0.898396 | 2.29989376 | Dunaliella tertiolecta | 3047 | Plants | Plants | 185 | 2.2e-42 | NTclustered | gi|534958|emb|X66036.1| | 3047 | g148204 | i0 | 79.845 | 78.4609375 | 258 | 48 | 100 | 4 | 1 | 256 | 418 | 163 | D.tertiolecta mRNA for S11 ribosomal protein | blastn | 20086 | 185 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Dunaliellaceae | Dunaliella | Dunaliella tertiolecta | |
| 13974344 | 13974344 | PRJNA800090_P_NODE_158151_length_248_cov_2.173184_g155966_i0 | PRJNA800090 | 158151 | 248 | 2.173184 | 5.38949632 | Bryopsis | 3128 | Plants | Plants | 298 | 2.61e-76 | NTclustered | gi|969822372|gb|KT950953.1| | 3129 | g155966 | i0 | 89.121 | 92.8508064516129 | 239 | 26 | 96 | 0 | 8 | 246 | 650 | 412 | Bryopsis maxima actin gene, partial cds | blastn | 23027 | 298 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Bryopsidaceae | Bryopsis | Bryopsis maxima | |
| 16100490 | 16100490 | PRJNA800090_P_NODE_172893_length_236_cov_0.874251_g170708_i0 | PRJNA800090 | 172893 | 236 | 0.874251 | 2.06323236 | Coccomyxa subellipsoidea | 248742 | Plants | Plants | 171 | 5.6e-38 | NTclustered | gi|545376104|ref|XM_005652106.1| | 574566 | g170708 | i0 | 79.832 | 19.7966101694915 | 238 | 44 | 100 | 4 | 1 | 236 | 391 | 626 | Coccomyxa subellipsoidea C-169 methionine adenosyltransferase partial mRNA | blastn | 4672 | 171 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Coccomyxaceae | Coccomyxa | Coccomyxa subellipsoidea | ||
| 21199383 | 21199383 | PRJNA800090_P_NODE_128397_length_280_cov_1.383886_g126212_i0 | PRJNA800090 | 128397 | 280 | 1.383886 | 3.8748808 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 195 | 4.05e-45 | NTclustered | gi|2082241923|ref|XM_001697441.2| | 3055 | g126212 | i0 | 80.632 | 22.7571428571429 | 253 | 47 | 90 | 2 | 2 | 253 | 1042 | 791 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_03g160500v5), mRNA | blastn | 6372 | 195 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23750239 | 23750239 | PRJNA800090_P_NODE_155079_length_251_cov_1.604396_g152894_i0 | PRJNA800090 | 155079 | 251 | 1.604396 | 4.02703396 | Chlorella variabilis | 554065 | Plants | Plants | 78.7 | 3.75e-10 | NTclustered | gi|552847345|ref|XM_005851779.1| | 554065 | g152894 | i0 | 82.955 | 1.37051792828685 | 88 | 13 | 35 | 2 | 155 | 241 | 525 | 439 | Chlorella variabilis hypothetical protein (CHLNCDRAFT_133342) mRNA, complete cds | blastn | 344 | 78.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella variabilis | |
| 23750660 | 23750660 | PRJNA800090_P_NODE_174179_length_235_cov_0.879518_g171994_i0 | PRJNA800090 | 174179 | 235 | 0.879518 | 2.0668673 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 195 | 3.31e-45 | NTclustered | gi|2082237163|ref|XM_043058766.1| | 3055 | g171994 | i0 | 83.575 | 69.3787234042553 | 207 | 34 | 88 | 0 | 14 | 220 | 417 | 211 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g039250v5), mRNA | blastn | 16304 | 195 | 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);;