contig_metadata
6 rows where bioproject = "PRJNA773778", tax_clade = "Sar" and tax_phylum = "Ciliophora"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026932 | 2026932 | PRJNA773778_S_NODE_25162_length_302_cov_3.462882_g25012_i0 | PRJNA773778 | 25162 | 302 | 3.462882 | 10.45790364 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.028 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g25012 | i0 | 100 | 0.0927152317880795 | 28 | 0 | 9 | 0 | 1 | 28 | 11 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 4579430 | 4579430 | PRJNA773778_S_NODE_35544_length_264_cov_2.811518_g35394_i0 | PRJNA773778 | 35544 | 264 | 2.811518 | 7.42240752 | Kentrophoros sp. 1 BS-2022 | 2930470 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.007 | NTclustered | gi|2261268989|emb|OX095830.1| | 2930470 | g35394 | i0 | 100 | 0.534090909090909 | 29 | 0 | 11 | 0 | 1 | 29 | 10 | 38 | Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) | blastn | 141 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Karyorelictea | Protostomatida | Kentrophoridae | Kentrophoros | Kentrophoros sp. 1 BS-2022 | ||
| 13505338 | 13505338 | PRJNA773778_S_NODE_5351_length_539_cov_5.169528_g5202_i0 | PRJNA773778 | 5351 | 539 | 5.169528 | 27.86375592 | Mesodinium rubrum | 704171 | SAR_Eukaryotes | SAR_Eukaryotes | 953 | 0 | NTclustered | gi|1386676391|gb|MG018339.1| | 704171 | g5202 | i0 | 98.696 | 80.9628942486085 | 537 | 7 | 99 | 0 | 3 | 539 | 2207 | 1671 | Mesodinium rubrum isolate DK2009 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 43639 | 953 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Cyclotrichida | Mesodiniidae | Mesodinium | Mesodinium rubrum | ||
| 19058959 | 19058959 | PRJNA773778_S_NODE_24035_length_307_cov_4.247863_g23885_i0 | PRJNA773778 | 24035 | 307 | 4.247863 | 13.04093941 | root | 1 | Root_unresolved | Root_unresolved | 556 | 4.98e-154 | NTclustered | gi|345541658|gb|JN547815.1| | 5911 | g23885 | i0 | 99.349 | 75.6775244299674 | 307 | 2 | 100 | 0 | 1 | 307 | 3498 | 3804 | Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence | blastn | 23233 | 556 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19878082 | 19878082 | PRJNA773778_S_NODE_38176_length_256_cov_4.109290_g38026_i0 | PRJNA773778 | 38176 | 256 | 4.10929 | 10.5197824 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 446 | 9.139999999999999e-121 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g38026 | i0 | 98.047 | 98.2421875 | 256 | 5 | 100 | 0 | 1 | 256 | 1341 | 1086 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 25150 | 446 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 30306595 | 30306595 | PRJNA773778_S_NODE_45452_length_244_cov_3.602339_g45302_i0 | PRJNA773778 | 45452 | 244 | 3.602339 | 8.78970716 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 2.2e-8 | NR | CAD8072686.1 | 65129 | g45302 | i0 | 67.3 | 1.80737704918033 | 49 | 16 | 60.2 | 0 | 154 | 8 | 43 | 91 | CAD8072686.1 unnamed protein product [Paramecium sonneborni] | diamond | 441 | 60.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium sonneborni |
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);;