contig_metadata
6 rows where bioproject = "PRJNA1227535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2322279 | 2322279 | PRJNA1227535_P_NODE_24802_length_249_cov_1.500000_g24678_i0 | PRJNA1227535 | 24802 | 249 | 1.5 | 3.735 | Trebouxia | 13786 | Plants | Plants | 460 | 3.16e-125 | NTclustered | gi|189909382|gb|EU725860.1| | 13787 | g24678 | i0 | 100 | 125.843373493976 | 249 | 0 | 100 | 0 | 1 | 249 | 854 | 1102 | Trebouxia asymmetrica strain SAG 48.88 23S large subunit ribosomal RNA (rrnL) gene, partial sequence; chloroplast | blastn | 31335 | 460 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia asymmetrica | |
| 9263450 | 9263450 | PRJNA1227535_P_NODE_2828_length_413_cov_1.702941_g2705_i0 | PRJNA1227535 | 2828 | 413 | 1.702941 | 7.03314633 | uncultured Trebouxia photobiont | 285713 | Plants | Plants | 601 | 3.14e-167 | NTclustered | gi|1273623725|gb|KY033354.1| | 285713 | g2705 | i0 | 93.187 | 99.5544794188862 | 411 | 24 | 99 | 4 | 1 | 408 | 6807 | 6398 | Uncultured Trebouxia photobiont voucher Lendemer 46119 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 | 41116 | 601 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | uncultured Trebouxia photobiont | |
| 24561670 | 24561670 | PRJNA1227535_P_NODE_3840_length_366_cov_2.296928_g3717_i0 | PRJNA1227535 | 3840 | 366 | 2.296928 | 8.40675648 | Hormotilopsis gelatinosa | 56008 | Plants | Plants | 291 | 6.759999999999999e-74 | NTclustered | gi|586587046|gb|KC817003.1| | 56008 | g3717 | i0 | 86.567 | 80.6530054644809 | 268 | 30 | 73 | 5 | 1 | 266 | 1206 | 1469 | Hormotilopsis gelatinosa strain UTEX B104 28S ribosomal RNA gene, partial sequence | blastn | 29519 | 291 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Chlorophyceae | Chaetopeltidales | Chaetopeltidaceae | Hormotilopsis | Hormotilopsis gelatinosa | |
| 30313226 | 30313226 | PRJNA1227535_P_NODE_11652_length_287_cov_1.004673_g11529_i0 | PRJNA1227535 | 11652 | 287 | 1.004673 | 2.88341151 | Chlorella | 3071 | Plants | Plants | 45.8 | 0.00542 | NR | PRW60203.1 | 3076 | g11529 | i0 | 55.6 | 0.752613240418119 | 36 | 16 | 37.6 | 0 | 144 | 251 | 594 | 629 | PRW60203.1 DNA repair RAD50 isoform A [Chlorella sorokiniana] | diamond | 216 | 45.8 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella sorokiniana | |
| 31937554 | 31937554 | PRJNA1227535_P_NODE_24937_length_249_cov_0.886364_g24813_i0 | PRJNA1227535 | 24937 | 249 | 0.886364 | 2.20704636 | Trebouxia sp. A1-2 | 2608996 | Plants | Plants | 72 | 2.07e-12 | NR | KAA6421501.1 | 2608996 | g24813 | i0 | 56.7 | 0.72289156626506 | 60 | 26 | 72.3 | 0 | 37 | 216 | 85 | 144 | KAA6421501.1 MAG: hypothetical protein FRX49_08445 [Trebouxia sp. A1-2] | diamond | 180 | 72 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Trebouxiales | Trebouxiaceae | Trebouxia | Trebouxia sp. A1-2 | |
| 32790689 | 32790689 | PRJNA1227535_P_NODE_18900_length_262_cov_1.650794_g18776_i0 | PRJNA1227535 | 18900 | 262 | 1.650794 | 4.32508028 | Chlorella vulgaris | 3077 | Plants | Plants | 46.2 | 0.00275 | NR | KAL4854672.1 | 3077 | g18776 | i0 | 76 | 0.286259541984733 | 25 | 6 | 28.6 | 0 | 6 | 80 | 224 | 248 | KAL4854672.1 Major capsid protein [Chlorella vulgaris] | diamond | 75 | 46.2 | 1 | Eukaryota | core chlorophytes | Viridiplantae | Chlorophyta | Trebouxiophyceae | Chlorellales | Chlorellaceae | Chlorella | Chlorella vulgaris |
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);;