contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA635397" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3705319 | 3705319 | PRJNA635397_P_NODE_22163_length_341_cov_1.716418_g21709_i0 | PRJNA635397 | 22163 | 341 | 1.716418 | 5.85298538 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 8.41e-48 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g21709 | i0 | 97.479 | 1.83870967741935 | 119 | 3 | 35 | 0 | 223 | 341 | 3082 | 2964 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 627 | 204 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 4433386 | 4433386 | PRJNA635397_P_NODE_24984_length_320_cov_0.894737_g24530_i0 | PRJNA635397 | 24984 | 320 | 0.894737 | 2.8631584 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.59e-89 | NTclustered | gi|390195606|gb|JX112363.1| | 151077 | g24530 | i0 | 85.938 | 38.990625 | 320 | 45 | 100 | 0 | 1 | 320 | 556 | 237 | Chilodonella uncinata strain USA_SC2 beta-tubulin (Btub) gene, partial cds; macronuclear | blastn | 12477 | 342 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5709168 | 5709168 | PRJNA635397_P_NODE_17445_length_391_cov_2.459119_g16991_i0 | PRJNA635397 | 17445 | 391 | 2.459119 | 9.61515529 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 6.54e-149 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g16991 | i0 | 91.56 | 10.4398976982097 | 391 | 33 | 100 | 0 | 1 | 391 | 504 | 114 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 4082 | 540 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12085328 | 12085328 | PRJNA635397_P_NODE_41330_length_249_cov_0.886364_g40876_i0 | PRJNA635397 | 41330 | 249 | 0.886364 | 2.20704636 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.1399999999999996e-37 | NTclustered | gi|662862632|gb|KJ000271.1| | 151077 | g40876 | i0 | 91.129 | 1.55020080321285 | 124 | 11 | 50 | 0 | 35 | 158 | 674 | 797 | Chilodonella uncinata strain USA_SC2 clone P4 protein kinase domain containing protein gene, partial cds; macronuclear | blastn | 386 | 169 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15908297 | 15908297 | PRJNA635397_P_NODE_15273_length_424_cov_2.307692_g14819_i0 | PRJNA635397 | 15273 | 424 | 2.307692 | 9.78461408 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 623 | 6.9e-174 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g14819 | i0 | 93.16 | 60.5188679245283 | 424 | 29 | 100 | 0 | 1 | 424 | 460 | 37 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 25660 | 623 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 16456414 | 16456414 | PRJNA635397_P_NODE_33373_length_274_cov_2.094527_g32919_i0 | PRJNA635397 | 33373 | 274 | 2.094527 | 5.73900398 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.53e-125 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g32919 | i0 | 98.106 | 60.492700729927 | 264 | 5 | 96 | 0 | 8 | 271 | 503 | 240 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16575 | 460 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 19732148 | 19732148 | PRJNA635397_P_NODE_17616_length_389_cov_1.955696_g17162_i0 | PRJNA635397 | 17616 | 389 | 1.955696 | 7.60765744 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 575 | 1.7799999999999995e-159 | NTclustered | gi|158347525|gb|EU047814.1| | 151077 | g17162 | i0 | 93.316 | 100.056555269923 | 389 | 26 | 100 | 0 | 1 | 389 | 2 | 390 | Chilodonella uncinata clone Shared_P1 beta-tubulin gene, partial cds; macronuclear | blastn | 38922 | 575 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 24831833 | 24831833 | PRJNA635397_P_NODE_16800_length_400_cov_2.183486_g16346_i0 | PRJNA635397 | 16800 | 400 | 2.183486 | 8.733944 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 632 | 1.0799999999999996e-176 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g16346 | i0 | 95.238 | 10.15 | 399 | 19 | 99 | 0 | 2 | 400 | 424 | 26 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 4060 | 632 | 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);;