contig_metadata
7 rows where bioproject = "PRJNA283169", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14400744 | 14400744 | PRJNA283169_P_NODE_2512_length_260_cov_2.862559_g2450_i0 | PRJNA283169 | 2512 | 260 | 2.862559 | 7.4426534 | Lembadion sp. FG-2015 | 1607877 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.7e-91 | NTclustered | gi|759083556|gb|KM222173.1| | 1607877 | g2450 | i0 | 98.969 | 73.0153846153846 | 194 | 2 | 75 | 0 | 45 | 238 | 370 | 177 | Lembadion sp. FG-2015 voucher FYB2013031305 large subunit ribosomal RNA gene, partial sequence | blastn | 18984 | 348 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion sp. FG-2015 | ||
| 15086600 | 15086600 | PRJNA283169_P_NODE_3812_length_214_cov_0.878788_g3749_i0 | PRJNA283169 | 3812 | 214 | 0.878788 | 1.88060632 | Lembadion | 54107 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 7.83e-81 | NTclustered | gi|7839503|gb|AF255358.1| | 54108 | g3749 | i0 | 98.857 | 83.3271028037383 | 175 | 2 | 100 | 0 | 1 | 175 | 373 | 199 | Lembadion bullinum small subunit ribosomal RNA gene, partial sequence | blastn | 17832 | 313 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Lembadionidae | Lembadion | Lembadion bullinum | ||
| 18223505 | 18223505 | PRJNA283169_S_NODE_2295_length_188_cov_1.050360_g2281_i0 | PRJNA283169 | 2295 | 188 | 1.05036 | 1.9746768 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 8.780000000000001e-70 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g2281 | i0 | 93.085 | 2.91489361702128 | 188 | 13 | 100 | 0 | 1 | 188 | 67 | 254 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 548 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 30042495 | 30042495 | PRJNA283169_P_NODE_4831_length_193_cov_1.430556_g4768_i0 | PRJNA283169 | 4831 | 193 | 1.430556 | 2.76097308 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 62.8 | 1.6e-9 | NR | OMJ90620.1 | 5963 | g4768 | i0 | 50.8 | 0.979274611398964 | 63 | 31 | 97.9 | 0 | 3 | 191 | 857 | 919 | OMJ90620.1 hypothetical protein SteCoe_7019 [Stentor coeruleus] | diamond | 189 | 62.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31274777 | 31274777 | PRJNA283169_P_NODE_3555_length_220_cov_1.204678_g3492_i0 | PRJNA283169 | 3555 | 220 | 1.204678 | 2.6502916 | Stentor coeruleus | 5963 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 2.25e-11 | NR | OMJ92231.1 | 5963 | g3492 | i0 | 42.1 | 1.03636363636364 | 76 | 37 | 94.1 | 1 | 11 | 217 | 737 | 812 | OMJ92231.1 hypothetical protein SteCoe_4999 [Stentor coeruleus] | diamond | 228 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31654175 | 31654175 | PRJNA283169_P_NODE_1917_length_294_cov_1.432653_g1855_i0 | PRJNA283169 | 1917 | 294 | 1.432653 | 4.21199982 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 3.2e-6 | NR | CDW77831.1 | 5949 | g1855 | i0 | 48.1 | 0.530612244897959 | 52 | 27 | 53.1 | 0 | 215 | 60 | 552 | 603 | CDW77831.1 probable atp-dependent rna helicase ddx46-like [Stylonychia lemnae] | diamond | 156 | 55.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32445563 | 32445563 | PRJNA283169_P_NODE_3379_length_226_cov_1.101695_g3316_i0 | PRJNA283169 | 3379 | 226 | 1.101695 | 2.4898307 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 1.69e-24 | NR | XP_004031019.1 | 5932 | g3316 | i0 | 77.8 | 0.836283185840708 | 63 | 14 | 83.6 | 0 | 1 | 189 | 51 | 113 | XP_004031019.1 ribosomal protein, putative [Ichthyophthirius multifiliis] | diamond | 189 | 102 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;