contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA315314" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065389 | 1065389 | PRJNA315314_S_NODE_3901_length_404_cov_5.293333_g3580_i0 | PRJNA315314 | 3901 | 404 | 5.293333 | 21.38506532 | Chlorellaceae | 35461 | Plants | Plants | 78.7 | 6.39e-10 | NTclustered | gi|741870561|ref|NC_026009.1| | 3075 | g3580 | i0 | 90 | 0.923267326732673 | 60 | 6 | 15 | 0 | 144 | 203 | 32383 | 32324 | Auxenochlorella protothecoides mitochondrion, complete genome | blastn | 373 | 78.7 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Auxenochlorella | Auxenochlorella protothecoides | |
| 2931677 | 2931677 | PRJNA315314_S_NODE_6383_length_319_cov_8.675862_g6062_i0 | PRJNA315314 | 6383 | 319 | 8.675862 | 27.67599978 | Marsupiomonas pelliculata | 1034818 | Plants | Plants | 196 | 1.31e-45 | NTclustered | gi|371782105|emb|HE610137.1| | 1034818 | g6062 | i0 | 81.481 | 81.012539184953 | 243 | 41 | 76 | 4 | 78 | 319 | 2441 | 2202 | Marsupiomonas pelliculata partial 28S rRNA gene, strain PLY 441 | blastn | 25843 | 196 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Pedinophyceae | Marsupiomonadales | Marsupiomonadaceae | Marsupiomonas | Marsupiomonas pelliculata | |
| 4893069 | 4893069 | PRJNA315314_S_NODE_11464_length_239_cov_135.009524_g11143_i0 | PRJNA315314 | 11464 | 239 | 135.009524 | 322.67276236 | Chlamydomonas | 3052 | Plants | Plants | 414 | 2.38e-111 | NTclustered | gi|167047969|gb|EU410621.1| | 3055 | g11143 | i0 | 97.908 | 100.28870292887 | 239 | 5 | 100 | 0 | 1 | 239 | 1924 | 1686 | Chlamydomonas reinhardtii 26S ribosomal RNA gene, partial sequence | blastn | 23969 | 414 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 4893197 | 4893197 | PRJNA315314_S_NODE_31684_length_151_cov_16.811475_g31363_i0 | PRJNA315314 | 31684 | 151 | 16.811475 | 25.38532725 | Choricystis | 41299 | Plants | Plants | 128 | 1.9899999999999999e-25 | NTclustered | gi|328349685|emb|FN298929.1| | 41300 | g31363 | i0 | 93.103 | 76.6225165562914 | 87 | 6 | 58 | 0 | 65 | 151 | 2192 | 2106 | Choricystis sp. TP-2009 18S rRNA gene (partial), ITS1, 5.8S rRNA gene, ITS2 and 28S rRNA gene (partial), strain SAG 211-40c | blastn | 11570 | 128 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Choricystis | Choricystis parasitica | |||
| 6168136 | 6168136 | PRJNA315314_S_NODE_25305_length_166_cov_16.408759_g24984_i0 | PRJNA315314 | 25305 | 166 | 16.408759 | 27.23853994 | Chlamydomonas | 3052 | Plants | Plants | 307 | 2.69e-79 | NTclustered | gi|422779560|gb|JX839535.1| | 3055 | g24984 | i0 | 100 | 98.7530120481928 | 166 | 0 | 100 | 0 | 1 | 166 | 481 | 316 | Chlamydomonas reinhardtii strain CC-621 28S ribosomal RNA gene, partial sequence | blastn | 16393 | 307 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 7443191 | 7443191 | PRJNA315314_S_NODE_20566_length_182_cov_8.228758_g20245_i0 | PRJNA315314 | 20566 | 182 | 8.228758 | 14.97633956 | Eukaryota | 2759 | Plants | Plants | 60.2 | 9.25e-5 | NTclustered | gi|2306645722|gb|OK189530.1| | 121088 | g20245 | i0 | 94.872 | 7.26373626373626 | 39 | 1 | 21 | 1 | 19 | 56 | 66846 | 66808 | Ostreobium quekettii voucher Chloroplast genome chloroplast, complete genome | blastn | 1322 | 60.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Ulvophyceae | Bryopsidales | Ostreobiaceae | Ostreobium | Ostreobium quekettii | |
| 18232471 | 18232471 | PRJNA315314_S_NODE_21115_length_180_cov_3.509934_g20794_i0 | PRJNA315314 | 21115 | 180 | 3.509934 | 6.3178812 | Chlorosarcinopsis eremi | 332213 | Plants | Plants | 82.4 | 1.95e-11 | NTclustered | gi|1642525901|ref|NC_042250.1| | 332213 | g20794 | i0 | 83.333 | 2.06666666666667 | 90 | 13 | 53 | 2 | 65 | 154 | 131318 | 131405 | Chlorosarcinopsis eremi culture UTEX:1186 chloroplast, complete genome | blastn | 372 | 82.4 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlorosarcinales | Chlorosarcinaceae | Chlorosarcinopsis | Chlorosarcinopsis eremi | |
| 22057311 | 22057311 | PRJNA315314_S_NODE_2178_length_534_cov_3.516832_g1887_i0 | PRJNA315314 | 2178 | 534 | 3.516832 | 18.77988288 | Chlamydomonas reinhardtii | 3055 | Plants | Plants | 324 | 1.01e-83 | NTclustered | gi|2082248650|ref|XM_043063418.1| | 3055 | g1887 | i0 | 77.944 | 84.6910112359551 | 535 | 106 | 99 | 11 | 1 | 529 | 329 | 857 | Chlamydomonas reinhardtii uncharacterized protein (CHLRE_06g290950v5), mRNA | blastn | 45225 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlamydomonadaceae | Chlamydomonas | Chlamydomonas reinhardtii | |
| 23332886 | 23332886 | PRJNA315314_S_NODE_24619_length_168_cov_393.834532_g24298_i0 | PRJNA315314 | 24619 | 168 | 393.834532 | 661.64201376 | Haematococcus lacustris | 44745 | Plants | Plants | 248 | 1.68e-61 | NTclustered | gi|1279575454|gb|MF683078.1| | 44745 | g24298 | i0 | 93.452 | 288.291666666667 | 168 | 9 | 100 | 2 | 1 | 168 | 3634 | 3799 | Haematococcus lacustris 16S ribosomal RNA gene, partial sequence; tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 48433 | 248 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Haematococcaceae | Haematococcus | Haematococcus lacustris |
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);;