contig_metadata
6 rows where bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6077496 | 6077496 | PRJNA986547_P_NODE_8085_length_253_cov_6.050000_g8003_i0 | PRJNA986547 | 8085 | 253 | 6.05 | 15.3065 | Opisthonecta sp. FG-2015 | 1607889 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.94e-122 | NTclustered | gi|759083562|gb|KM222179.1| | 1607889 | g8003 | i0 | 99.2 | 90.7430830039526 | 250 | 2 | 99 | 0 | 1 | 250 | 183 | 432 | Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence | blastn | 22958 | 451 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Opisthonectidae | Opisthonecta | Opisthonecta sp. FG-2015 | ||
| 9902248 | 9902248 | PRJNA986547_P_NODE_10888_length_244_cov_1.783626_g10806_i0 | PRJNA986547 | 10888 | 244 | 1.783626 | 4.35204744 | Rimostrombidium veniliae | 702563 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 9.139999999999999e-81 | NTclustered | gi|759083337|gb|KM221993.1| | 702563 | g10806 | i0 | 90.041 | 99.2868852459016 | 241 | 24 | 99 | 0 | 1 | 241 | 321 | 561 | Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds | blastn | 24226 | 313 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Choreotrichida | Strobilidiidae | Rimostrombidium | Rimostrombidium veniliae | ||
| 23926596 | 23926596 | PRJNA986547_P_NODE_10259_length_246_cov_1.260116_g10177_i0 | PRJNA986547 | 10259 | 246 | 1.260116 | 3.09988536 | Leptoamphisiella vermis | 692523 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 5.56e-78 | NTclustered | gi|399146156|gb|JQ736707.1| | 692523 | g10177 | i0 | 88.98 | 102.056910569106 | 245 | 27 | 99 | 0 | 2 | 246 | 493 | 249 | Leptoamphisiella vermis isolate 061224 alpha-tubulin gene, partial cds; macronuclear | blastn | 25106 | 303 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Pseudoamphisiellida | Leptoamphisiella | Leptoamphisiella vermis | |||
| 27664382 | 27664382 | PRJNA986547_P_NODE_16224_length_207_cov_4.507463_g16142_i0 | PRJNA986547 | 16224 | 207 | 4.507463 | 9.33044841 | Heterotrichea | 194287 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.82e-29 | NR | OMJ84556.1 | 5963 | g16142 | i0 | 79.7 | 6.97101449275362 | 69 | 14 | 100 | 0 | 207 | 1 | 410 | 478 | OMJ84556.1 hypothetical protein SteCoe_14295 [Stentor coeruleus] | diamond | 1443 | 119 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 27727713 | 27727713 | PRJNA986547_P_NODE_9064_length_249_cov_3.926136_g8982_i0 | PRJNA986547 | 9064 | 249 | 3.926136 | 9.77607864 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 1.67e-8 | NR | CAG9318551.1 | 1481888 | g8982 | i0 | 44.3 | 6.24096385542169 | 79 | 41 | 95.2 | 2 | 247 | 11 | 222 | 297 | CAG9318551.1 unnamed protein product [Blepharisma stoltei] | diamond | 1554 | 61.2 | 0.993464052287582 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Blepharismidae | Blepharisma | Blepharisma stoltei | ||
| 27784814 | 27784814 | PRJNA986547_P_NODE_15304_length_215_cov_9.154930_g15222_i0 | PRJNA986547 | 15304 | 215 | 9.15493 | 19.6830995 | Paramecium sonneborni | 65129 | SAR_Eukaryotes | SAR_Eukaryotes | 47.4 | 2.06e-4 | NR | CAD8066873.1 | 65129 | g15222 | i0 | 43.4 | 0.73953488372093 | 53 | 29 | 74 | 1 | 56 | 214 | 27 | 78 | CAD8066873.1 unnamed protein product [Paramecium sonneborni] | diamond | 159 | 47.4 | 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);;