contig_metadata
7 rows where bioproject = "PRJNA797655" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2062345 | 2062345 | PRJNA797655_S_NODE_262722_length_153_cov_4.018182_g262117_i0 | PRJNA797655 | 262722 | 153 | 4.018182 | 6.14781846 | uncultured Lunachloris | 3049186 | Plants | Plants | 204 | 3.2699999999999995e-48 | NTclustered | gi|2515376804|gb|OR101661.1| | 3049186 | g262117 | i0 | 90.85 | 95.2745098039216 | 153 | 13 | 100 | 1 | 1 | 153 | 1134 | 1285 | Uncultured Lunachloris clone mgcl22_AM31 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 14577 | 204 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | uncultured Lunachloris | ||||
| 8440120 | 8440120 | PRJNA797655_S_NODE_277887_length_150_cov_2.495327_g277282_i0 | PRJNA797655 | 277887 | 150 | 2.495327 | 3.7429905 | Nannochloris normandinae | 926285 | Plants | Plants | 267 | 4.009999999999999e-67 | NTclustered | gi|922575245|gb|JQ921007.1| | 926285 | g277282 | i0 | 98.675 | 106.846666666667 | 151 | 1 | 100 | 1 | 1 | 150 | 607 | 457 | Nannochloris normandinae strain SAG 9.82 23S large subunit ribosomal RNA gene, partial sequence; chloroplast | blastn | 16027 | 267 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Nannochloris | Nannochloris normandinae | |
| 17365366 | 17365366 | PRJNA797655_S_NODE_277394_length_150_cov_4.934579_g276789_i0 | PRJNA797655 | 277394 | 150 | 4.934579 | 7.4018685 | Pleurastrosarcina brevispinosa | 163096 | Plants | Plants | 272 | 8.609999999999998e-69 | NTclustered | gi|698349064|gb|KM462875.1| | 163096 | g276789 | i0 | 99.333 | 113.933333333333 | 150 | 1 | 100 | 0 | 1 | 150 | 56285 | 56136 | Chlorosarcina brevispinosa culture-collection UTEX:1176 chloroplast, partial genome | blastn | 17090 | 272 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Pleurastrosarcina | Pleurastrosarcina brevispinosa | |||
| 25444325 | 25444325 | PRJNA797655_S_NODE_73280_length_276_cov_3.553648_g72675_i0 | PRJNA797655 | 73280 | 276 | 3.553648 | 9.80806848 | Eukaryota | 2759 | Plants | Plants | 52.8 | 0.025 | NTclustered | gi|2627911945|ref|NC_084269.1| | 1745963 | g72675 | i0 | 96.875 | 0.217391304347826 | 32 | 0 | 12 | 1 | 47 | 78 | 228750 | 228780 | Hydrocytium acuminatum strain SAG 40.91 chloroplast, complete genome | blastn | 60 | 52.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Chlorococcaceae | Hydrocytium | Hydrocytium acuminatum | |
| 27275231 | 27275231 | PRJNA797655_S_NODE_95383_length_250_cov_4.082126_g94778_i0 | PRJNA797655 | 95383 | 250 | 4.082126 | 10.205315 | Chlorella ohadii | 2649997 | Plants | Plants | 42 | 0.0363 | NR | KAI7836672.1 | 2649997 | g94778 | i0 | 46.5 | 0.516 | 43 | 22 | 51.6 | 1 | 40 | 168 | 47 | 88 | KAI7836672.1 hypothetical protein COHA_009448 [Chlorella ohadii] | diamond | 129 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella ohadii | |
| 30875387 | 30875387 | PRJNA797655_S_NODE_209874_length_174_cov_1.984733_g209269_i0 | PRJNA797655 | 209874 | 174 | 1.984733 | 3.45343542 | Micractinium tetrahymenae | 2728915 | Plants | Plants | 42 | 0.0284 | NR | KAL4457459.1 | 2728915 | g209269 | i0 | 43.1 | 0.879310344827586 | 51 | 27 | 84.5 | 1 | 150 | 4 | 333 | 383 | KAL4457459.1 hypothetical protein ABPG75_012324 [Micractinium tetrahymenae] | diamond | 153 | 42 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Micractinium | Micractinium tetrahymenae | |
| 31665679 | 31665679 | PRJNA797655_S_NODE_263717_length_153_cov_1.745455_g263112_i0 | PRJNA797655 | 263717 | 153 | 1.745455 | 2.67054615 | Gonium pectorale | 33097 | Plants | Plants | 41.2 | 0.0371 | NR | KXZ49562.1 | 33097 | g263112 | i0 | 59.4 | 0.627450980392157 | 32 | 13 | 62.7 | 0 | 100 | 5 | 130 | 161 | KXZ49562.1 hypothetical protein GPECTOR_20g417 [Gonium pectorale] | diamond | 96 | 41.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chlamydomonadales | Volvocaceae | Gonium | Gonium pectorale |
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);;