contig_metadata
6 rows where bioproject = "PRJNA980839", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4786040 | 4786040 | PRJNA980839_P_NODE_169764_length_270_cov_2.553299_g165980_i0 | PRJNA980839 | 169764 | 270 | 2.553299 | 6.8939073 | Nolandia orientalis | 1607835 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.27e-114 | NTclustered | gi|759083538|gb|KM222155.1| | 1607835 | g165980 | i0 | 95.167 | 99.9925925925926 | 269 | 13 | 99 | 0 | 1 | 269 | 888 | 620 | Nolandia orientalis voucher PXM2010102401 large subunit ribosomal RNA gene, partial sequence | blastn | 26998 | 425 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Nolandia | Nolandia orientalis | ||
| 17537673 | 17537673 | PRJNA980839_P_NODE_49494_length_611_cov_3.661710_g45759_i0 | PRJNA980839 | 49494 | 611 | 3.66171 | 22.3730481 | Coleps hirtus | 60000 | SAR_Eukaryotes | SAR_Eukaryotes | 1066 | 0 | NTclustered | gi|328684911|gb|HM122027.1| | 394492 | g45759 | i0 | 98.2 | 65.9230769230769 | 611 | 9 | 100 | 1 | 1 | 611 | 623 | 15 | Coleps hirtus hirtus isolate SNK09101903 macronuclear | blastn | 40279 | 1066 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 21672111 | 21672111 | PRJNA980839_P_NODE_119597_length_325_cov_1.833333_g115813_i0 | PRJNA980839 | 119597 | 325 | 1.833333 | 5.95833225 | Coleps | 6003 | SAR_Eukaryotes | SAR_Eukaryotes | 601 | 2.4199999999999993e-167 | NTclustered | gi|1825575437|gb|MT253687.1| | 60000 | g115813 | i0 | 100 | 99.4953846153846 | 325 | 0 | 100 | 0 | 1 | 325 | 28 | 352 | Coleps hirtus strain CCAP 1613/14 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 32336 | 601 | 1 | Eukaryota | Sar | Ciliophora | Prostomatea | Prorodontida | Colepidae | Coleps | Coleps hirtus | ||
| 25183763 | 25183763 | PRJNA980839_P_NODE_158520_length_280_cov_1.077295_g154736_i0 | PRJNA980839 | 158520 | 280 | 1.077295 | 3.016426 | Blepharisma stoltei | 1481888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2643439136|emb|OX456574.1| | 1481888 | g154736 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 142 | 169 | 16674 | 16701 | Blepharisma stoltei strain ATCC30299 genome assembly, organelle: mitochondrion | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 28485141 | 28485141 | PRJNA980839_P_NODE_225186_length_244_cov_0.900585_g221402_i0 | PRJNA980839 | 225186 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.2 | 1.36e-7 | NR | OMJ66985.1 | 5963 | g221402 | i0 | 79.4 | 2.92622950819672 | 34 | 7 | 41.8 | 0 | 239 | 138 | 298 | 331 | OMJ66985.1 hypothetical protein SteCoe_35983 [Stentor coeruleus] | diamond | 714 | 58.5 | 0.994871794871795 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 28769185 | 28769185 | PRJNA980839_P_NODE_205467_length_249_cov_0.875000_g201683_i0 | PRJNA980839 | 205467 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 55.1 | 1.5e-6 | NR | CDW72625.1 | 5949 | g201683 | i0 | 38.3 | 2.67469879518072 | 81 | 48 | 97.6 | 1 | 245 | 3 | 185 | 263 | CDW72625.1 UNKNOWN [Stylonychia lemnae] | diamond | 666 | 55.5 | 0.992792792792793 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;