contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA751877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726381 | 726381 | PRJNA751877_P_NODE_24201_length_249_cov_0.875000_g24079_i0 | PRJNA751877 | 24201 | 249 | 0.875 | 2.17875 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 119 | 2.19e-22 | NTclustered | gi|2082246007|ref|XM_001700625.2| | 3055 | g24079 | i0 | 79.191 | 2.33734939759036 | 173 | 34 | 69 | 2 | 1 | 172 | 1516 | 1687 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_05g234639v5), mRNA | blastn | 582 | 119 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4555042 | 4555042 | PRJNA751877_P_NODE_3024_length_511_cov_2.264840_g2902_i0 | PRJNA751877 | 3024 | 511 | 2.26484 | 11.5733324 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 326 | 2.67e-84 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g2902 | i0 | 82.759 | 70.4598825831703 | 377 | 53 | 73 | 11 | 141 | 511 | 857 | 487 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 36005 | 326 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 5830141 | 5830141 | PRJNA751877_P_NODE_3085_length_507_cov_5.983871_g2963_i0 | PRJNA751877 | 3085 | 507 | 5.983871 | 30.33822597 | Monoraphidium neglectum | 145388 | Plants | Plants | 339 | 3.4e-88 | NTclustered | gi|926773763|ref|XM_014039902.1| | 145388 | g2963 | i0 | 79.641 | 60.1439842209073 | 501 | 78 | 96 | 22 | 13 | 501 | 489 | 1 | Monoraphidium neglectum 60S ribosomal protein L19-2 mRNA | blastn | 30493 | 339 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 7105335 | 7105335 | PRJNA751877_P_NODE_7766_length_377_cov_1.213816_g7644_i0 | PRJNA751877 | 7766 | 377 | 1.213816 | 4.57608632 | Monoraphidium neglectum | 145388 | Plants | Plants | 272 | 2.53e-68 | NTclustered | gi|926795717|ref|XM_014050538.1| | 145388 | g7644 | i0 | 83 | 74.1220159151194 | 300 | 51 | 80 | 0 | 15 | 314 | 360 | 61 | Monoraphidium neglectum 40S ribosomal protein S20-1 mRNA | blastn | 27944 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum | |
| 10128710 | 10128710 | PRJNA751877_P_NODE_14548_length_302_cov_1.344978_g14426_i0 | PRJNA751877 | 14548 | 302 | 1.344978 | 4.06183356 | Chlamydomonas | 3052 | Plants | Plants | 167 | 9.619999999999998e-37 | NTclustered | gi|2082236646|ref|XM_001689961.2| | 3055 | g14426 | i0 | 84.795 | 33.0364238410596 | 171 | 20 | 56 | 6 | 118 | 285 | 556 | 389 | Chlamydomonas reinhardtii ribosomal protein L11 (CHLRE_01g027000v5), mRNA | blastn | 9977 | 167 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 18578302 | 18578302 | PRJNA751877_P_NODE_5635_length_418_cov_1.339130_g5513_i0 | PRJNA751877 | 5635 | 418 | 1.33913 | 5.5975634 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 305 | 2.8e-78 | NTclustered | gi|2082235498|ref|XM_001700320.2| | 3055 | g5513 | i0 | 83.186 | 76.8421052631579 | 339 | 51 | 80 | 6 | 83 | 418 | 509 | 174 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_01g002300v5), mRNA | blastn | 32120 | 305 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23679127 | 23679127 | PRJNA751877_P_NODE_13999_length_307_cov_1.316239_g13877_i0 | PRJNA751877 | 13999 | 307 | 1.316239 | 4.04085373 | Auxenochlorella protothecoides | 3075 | Plants | Plants | 156 | 2.12e-33 | NTclustered | gi|760437580|ref|XM_011397557.1| | 3075 | g13877 | i0 | 79.556 | 1.9771986970684 | 225 | 40 | 72 | 5 | 19 | 240 | 285 | 64 | Auxenochlorella protothecoides Transcription factor BTF3 partial mRNA | blastn | 607 | 156 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 23679508 | 23679508 | PRJNA751877_P_NODE_4179_length_460_cov_2.744186_g4057_i0 | PRJNA751877 | 4179 | 460 | 2.744186 | 12.6232556 | Monoraphidium neglectum | 145388 | Plants | Plants | 255 | 3.17e-63 | NTclustered | gi|926778303|ref|XM_014042172.1| | 145388 | g4057 | i0 | 78.019 | 66.7326086956522 | 414 | 85 | 89 | 5 | 7 | 417 | 435 | 25 | Monoraphidium neglectum 40S ribosomal protein S18 mRNA | blastn | 30697 | 255 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Sphaeropleales | Selenastraceae | Monoraphidium | Monoraphidium neglectum |
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);;