contig_metadata
8 rows where bioproject = "PRJNA883229" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8512917 | 8512917 | PRJNA883229_P_NODE_7627_length_265_cov_1.625000_g7581_i0 | PRJNA883229 | 7627 | 265 | 1.625 | 4.30625 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.14e-68 | NTclustered | gi|829194699|ref|XM_001025224.3| | 312017 | g7581 | i0 | 87.607 | 0.883018867924528 | 234 | 27 | 88 | 2 | 31 | 263 | 359 | 127 | Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA | blastn | 234 | 270 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8893974 | 8893974 | PRJNA883229_P_NODE_3327_length_359_cov_1.073427_g3281_i0 | PRJNA883229 | 3327 | 359 | 1.073427 | 3.85360293 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 593 | 4.5099999999999985e-165 | NTclustered | gi|1837628855|gb|MN158348.1| | 5909 | g3281 | i0 | 99.691 | 93.7019498607242 | 324 | 1 | 100 | 0 | 1 | 324 | 2628 | 2951 | Tetrahymena rostrata strain TRAUS 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 | 33639 | 593 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena rostrata | ||
| 16162744 | 16162744 | PRJNA883229_P_NODE_6633_length_280_cov_1.111111_g6587_i0 | PRJNA883229 | 6633 | 280 | 1.111111 | 3.1111108 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 1.01e-125 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g6587 | i0 | 96.429 | 56.1928571428571 | 280 | 10 | 100 | 0 | 1 | 280 | 593 | 314 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 15734 | 462 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 27939891 | 27939891 | PRJNA883229_P_NODE_12405_length_248_cov_0.891429_g12359_i0 | PRJNA883229 | 12405 | 248 | 0.891429 | 2.21074392 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 4.15e-40 | NR | XP_001023207.2 | 312017 | g12359 | i0 | 87.7 | 0.979838709677419 | 81 | 10 | 98 | 0 | 3 | 245 | 2 | 82 | XP_001023207.2 60S ribosomal protein L18 [Tetrahymena thermophila SB210] | diamond | 243 | 140 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28602954 | 28602954 | PRJNA883229_P_NODE_15667_length_243_cov_0.917647_g15621_i0 | PRJNA883229 | 15667 | 243 | 0.917647 | 2.22988221 | Halteria grandinella | 5974 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.9e-4 | NR | TNV85598.1 | 5974 | g15621 | i0 | 56.4 | 3.01234567901235 | 39 | 17 | 48.1 | 0 | 1 | 117 | 404 | 442 | TNV85598.1 hypothetical protein FGO68_gene9158 [Halteria grandinella] | diamond | 732 | 49.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella | ||
| 28831699 | 28831699 | PRJNA883229_P_NODE_12188_length_248_cov_0.891429_g12142_i0 | PRJNA883229 | 12188 | 248 | 0.891429 | 2.21074392 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 6.8e-13 | NR | KAL4474832.1 | 5901 | g12142 | i0 | 40.6 | 1.65725806451613 | 69 | 41 | 83.5 | 0 | 207 | 1 | 5 | 73 | KAL4474832.1 hypothetical protein ABPG74_001528 [Tetrahymena malaccensis] | diamond | 411 | 72.8 | 0.994505494505495 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena malaccensis | ||
| 32584859 | 32584859 | PRJNA883229_P_NODE_12899_length_247_cov_0.896552_g12853_i0 | PRJNA883229 | 12899 | 247 | 0.896552 | 2.21448344 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 3.16e-11 | NR | CDW84267.1 | 5949 | g12853 | i0 | 84.2 | 0.923076923076923 | 38 | 6 | 46.2 | 0 | 246 | 133 | 511 | 548 | CDW84267.1 kelch motif family protein [Stylonychia lemnae] | diamond | 228 | 68.6 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 32749999 | 32749999 | PRJNA883229_P_NODE_16080_length_242_cov_1.733728_g16034_i0 | PRJNA883229 | 16080 | 242 | 1.733728 | 4.19562176 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 4.92e-25 | NR | TNV71023.1 | 5974 | g16034 | i0 | 66.7 | 2.80165289256198 | 75 | 25 | 93 | 0 | 13 | 237 | 422 | 496 | TNV71023.1 hypothetical protein FGO68_gene13224 [Halteria grandinella] | diamond | 678 | 107 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Halteriidae | Halteria | Halteria grandinella |
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);;