contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA177642" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365436 | 365436 | PRJNA177642_P_NODE_15641_length_183_cov_2.012987_g14416_i0 | PRJNA177642 | 15641 | 183 | 2.012987 | 3.68376621 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 267 | 5.109999999999999e-67 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14416 | i0 | 92.896 | 3 | 183 | 13 | 100 | 0 | 1 | 183 | 445 | 627 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 549 | 267 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6157847 | 6157847 | PRJNA177642_P_NODE_14225_length_218_cov_1.634921_g13000_i0 | PRJNA177642 | 14225 | 218 | 1.634921 | 3.56412778 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 278 | 2.92e-70 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g13000 | i0 | 98.113 | 3.64220183486239 | 159 | 3 | 73 | 0 | 1 | 159 | 2924 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 794 | 278 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 8707891 | 8707891 | PRJNA177642_P_NODE_5527_length_604_cov_3.186087_g4450_i0 | PRJNA177642 | 5527 | 604 | 3.186087 | 19.24396548 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 2.869999999999999e-159 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4450 | i0 | 97.067 | 54.8791390728477 | 341 | 10 | 98 | 0 | 264 | 604 | 2345 | 2005 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 33147 | 580 | 0.991379310344828 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11844021 | 11844021 | PRJNA177642_P_NODE_15410_length_188_cov_1.169811_g14185_i0 | PRJNA177642 | 15410 | 188 | 1.169811 | 2.19924468 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.72e-75 | NTclustered | gi|347439295|gb|JN111996.1| | 151077 | g14185 | i0 | 94.681 | 96.8351063829787 | 188 | 10 | 100 | 0 | 1 | 188 | 556 | 369 | Chilodonella uncinata strain USA_SC2 alpha-tubulin (atub) gene, partial cds; macronuclear | blastn | 18205 | 292 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16357511 | 16357511 | PRJNA177642_P_NODE_13253_length_264_cov_4.123404_g12028_i0 | PRJNA177642 | 13253 | 264 | 4.123404 | 10.88578656 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 477 | 3.359999999999999e-130 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g12028 | i0 | 99.242 | 14.1931818181818 | 264 | 2 | 100 | 0 | 1 | 264 | 1775 | 1512 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3747 | 477 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18906585 | 18906585 | PRJNA177642_P_NODE_18595_length_162_cov_1.082707_g17370_i0 | PRJNA177642 | 18595 | 162 | 1.082707 | 1.75398534 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g17370 | i0 | 100 | 26.962962962963 | 162 | 0 | 100 | 0 | 1 | 162 | 1209 | 1370 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 4368 | 300 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 22042309 | 22042309 | PRJNA177642_P_NODE_7558_length_459_cov_1.527907_g6371_i0 | PRJNA177642 | 7558 | 459 | 1.527907 | 7.01309313 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 2.4299999999999997e-69 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g6371 | i0 | 93.085 | 36.7712418300654 | 188 | 13 | 41 | 0 | 271 | 458 | 97 | 284 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 16878 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24007062 | 24007062 | PRJNA177642_P_NODE_10999_length_334_cov_2.219672_g9774_i0 | PRJNA177642 | 10999 | 334 | 2.219672 | 7.41370448 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 1.36e-50 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g9774 | i0 | 99.16 | 55.7904191616766 | 119 | 0 | 68 | 1 | 1 | 118 | 1656 | 1538 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18634 | 213 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;