contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA630877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1879277 | 1879277 | PRJNA630877_S_NODE_106822_length_212_cov_2.345029_g87685_i0 | PRJNA630877 | 106822 | 212 | 2.345029 | 4.97146148 | Prasiola crispa | 173492 | Plants | Plants | 291 | 3.63e-74 | NTclustered | gi|806639636|gb|KR017749.1| | 173492 | g87685 | i0 | 94.241 | 126.849056603774 | 191 | 9 | 90 | 2 | 22 | 211 | 751 | 940 | Prasiola crispa clone Contig2 chloroplast sequence | blastn | 26892 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Prasiolaceae | Prasiola | Prasiola crispa | |
| 3154000 | 3154000 | PRJNA630877_S_NODE_94843_length_240_cov_3.698492_g75706_i0 | PRJNA630877 | 94843 | 240 | 3.698492 | 8.8763808 | Pseudochlorella signiensis | 173497 | Plants | Plants | 333 | 6.88e-87 | NTclustered | gi|725650714|ref|NC_025529.1| | 173497 | g75706 | i0 | 94.444 | 109.975 | 216 | 12 | 90 | 0 | 1 | 216 | 150054 | 150269 | Pabia signiensis culture-collection SAG:7.90 chloroplast, complete genome | blastn | 26394 | 333 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Pseudochlorella | Pseudochlorella signiensis | |
| 8256283 | 8256283 | PRJNA630877_S_NODE_74487_length_323_cov_2.684397_g55350_i0 | PRJNA630877 | 74487 | 323 | 2.684397 | 8.67060231 | Chloroidium ellipsoideum | 63676 | Plants | Plants | 361 | 4.4399999999999997e-95 | NTclustered | gi|294358549|gb|GU732422.1| | 63676 | g55350 | i0 | 87.037 | 92.9349845201238 | 324 | 37 | 100 | 5 | 1 | 323 | 291 | 610 | Pseudochlorella sp. CCAP 211/1A isolate YSR03 28S ribosomal RNA gene, partial sequence | blastn | 30018 | 361 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 10080212 | 10080212 | PRJNA630877_S_NODE_150708_length_157_cov_3.568966_g131571_i0 | PRJNA630877 | 150708 | 157 | 3.568966 | 5.60327662 | Trebouxiophyceae | 75966 | Plants | Plants | 235 | 1.2e-57 | NTclustered | gi|746948124|ref|NC_025531.1| | 33092 | g131571 | i0 | 94.156 | 128.03821656051 | 154 | 9 | 98 | 0 | 4 | 157 | 145895 | 146048 | Koliella longiseta culture-collection UTEX:339 chloroplast, complete genome | blastn | 20102 | 235 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Koliellaceae | Koliella | Koliella longiseta | |
| 11355112 | 11355112 | PRJNA630877_S_NODE_104429_length_217_cov_2.278409_g85292_i0 | PRJNA630877 | 104429 | 217 | 2.278409 | 4.94414753 | Trebouxiophyceae | 75966 | Plants | Plants | 401 | 1.6499999999999994e-107 | NTclustered | gi|359385262|emb|FR865676.1| | 3082 | g85292 | i0 | 100 | 100.004608294931 | 217 | 0 | 100 | 0 | 1 | 217 | 275 | 59 | 'Chlorella' saccharophila genomic DNA containing 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection CCAP 211/57 | blastn | 21701 | 401 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium saccharophilum | |
| 11355117 | 11355117 | PRJNA630877_S_NODE_122089_length_187_cov_1.931507_g102952_i0 | PRJNA630877 | 122089 | 187 | 1.931507 | 3.61191809 | Trebouxiophyceae | 75966 | Plants | Plants | 324 | 3.07e-84 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g102952 | i0 | 97.861 | 100.631016042781 | 187 | 4 | 100 | 0 | 1 | 187 | 4509 | 4695 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 18818 | 324 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris | |
| 17181113 | 17181113 | PRJNA630877_S_NODE_102454_length_221_cov_4.750000_g83317_i0 | PRJNA630877 | 102454 | 221 | 4.75 | 10.4975 | Stichococcus sp. | 29647 | Plants | Plants | 409 | 1.0100000000000001e-109 | NTclustered | gi|1518373087|gb|MK201750.1| | 29647 | g83317 | i0 | 100 | 100.16742081448 | 221 | 0 | 100 | 0 | 1 | 221 | 1014 | 794 | Stichococcus sp. strain KZ-5-1-1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 22137 | 409 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus sp. | |
| 22829176 | 22829176 | PRJNA630877_S_NODE_101678_length_223_cov_1.873626_g82541_i0 | PRJNA630877 | 101678 | 223 | 1.873626 | 4.17818598 | Chloroidium | 1034479 | Plants | Plants | 385 | 1.72e-102 | NTclustered | gi|1169296931|gb|KY364701.1| | 63676 | g82541 | i0 | 97.758 | 100.013452914798 | 223 | 5 | 100 | 0 | 1 | 223 | 3894 | 4116 | Chloroidium ellipsoideum 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 22303 | 385 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Watanabeales | Watanabeaceae | Chloroidium | Chloroidium ellipsoideum | |
| 24829383 | 24829383 | PRJNA630877_S_NODE_90860_length_252_cov_3.672986_g71723_i0 | PRJNA630877 | 90860 | 252 | 3.672986 | 9.25592472 | Stichococcus bacillaris | 37433 | Plants | Plants | 220 | 5.919999999999999e-53 | NTclustered | gi|371782093|emb|HE610125.1| | 37433 | g71723 | i0 | 97.656 | 7.53968253968254 | 128 | 3 | 51 | 0 | 1 | 128 | 7055 | 7182 | Stichococcus bacillaris 18S rRNA gene (partial), 5.8S rRNA gene, 28S rRNA gene (partial), ITS1 and ITS2, strain SAG 379-2 | blastn | 1900 | 220 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Prasiolales | Stichococcaceae | Stichococcus | Stichococcus bacillaris |
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);;