contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1095825" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 199876 | 199876 | PRJNA1095825_P_NODE_152401_length_315_cov_1.909091_g149338_i0 | PRJNA1095825 | 152401 | 315 | 1.909091 | 6.01363665 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 1.8799999999999995e-138 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g149338 | i0 | 95.833 | 80.5365079365079 | 312 | 13 | 99 | 0 | 2 | 313 | 1075 | 1386 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 25369 | 505 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 200377 | 200377 | PRJNA1095825_P_NODE_214561_length_266_cov_1.404145_g211498_i0 | PRJNA1095825 | 214561 | 266 | 1.404145 | 3.7350257 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 492 | 1.2099999999999999e-134 | NTclustered | gi|1202135013|gb|KY476314.1| | 151077 | g211498 | i0 | 100 | 96.6654135338346 | 266 | 0 | 100 | 0 | 1 | 266 | 13 | 278 | Chilodonella uncinata 18S ribosomal RNA gene, partial sequence | blastn | 25713 | 492 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6577899 | 6577899 | PRJNA1095825_P_NODE_161126_length_307_cov_1.641026_g158063_i0 | PRJNA1095825 | 161126 | 307 | 1.641026 | 5.03794982 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.3e-157 | NTclustered | gi|13194559|gb|AF300281.1|AF300281 | 151077 | g158063 | i0 | 100 | 101.247557003257 | 307 | 0 | 100 | 0 | 1 | 307 | 518 | 824 | Chilodonella uncinata clone 1 18S small subunit ribosomal RNA gene, partial sequence | blastn | 31083 | 568 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6579707 | 6579707 | PRJNA1095825_P_NODE_77686_length_429_cov_3.432584_g74623_i0 | PRJNA1095825 | 77686 | 429 | 3.432584 | 14.72578536 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 763 | 0 | NTclustered | gi|300676714|gb|GQ377691.1| | 151077 | g74623 | i0 | 98.834 | 51.5058275058275 | 429 | 4 | 99 | 1 | 2 | 429 | 450 | 22 | Chilodonella uncinata rps22a (rps22a) mRNA, complete cds | blastn | 22096 | 763 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 7852340 | 7852340 | PRJNA1095825_P_NODE_113227_length_359_cov_2.132867_g110164_i0 | PRJNA1095825 | 113227 | 359 | 2.132867 | 7.65699253 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.79e-169 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g110164 | i0 | 97.207 | 62.3732590529248 | 358 | 10 | 99 | 0 | 1 | 358 | 22 | 379 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 22392 | 606 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9128003 | 9128003 | PRJNA1095825_P_NODE_205408_length_273_cov_1.005000_g202345_i0 | PRJNA1095825 | 205408 | 273 | 1.005 | 2.74365 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.6099999999999996e-133 | NTclustered | gi|347439301|gb|JN111999.1| | 151077 | g202345 | i0 | 98.901 | 13.2747252747253 | 273 | 3 | 100 | 0 | 1 | 273 | 516 | 244 | Chilodonella uncinata strain USA_WH actin gene, partial cds; macronuclear | blastn | 3624 | 488 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 9129072 | 9129072 | PRJNA1095825_P_NODE_42948_length_588_cov_3.246602_g39902_i0 | PRJNA1095825 | 42948 | 588 | 3.246602 | 19.09001976 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1003 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g39902 | i0 | 97.449 | 34.687074829932 | 588 | 15 | 100 | 0 | 1 | 588 | 343 | 930 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 20396 | 1003 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 10403868 | 10403868 | PRJNA1095825_P_NODE_228429_length_256_cov_1.617486_g225366_i0 | PRJNA1095825 | 228429 | 256 | 1.617486 | 4.14076416 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.67e-86 | NTclustered | gi|110645006|gb|DQ665938.1| | 151077 | g225366 | i0 | 92.275 | 7.8828125 | 233 | 18 | 91 | 0 | 1 | 233 | 563 | 795 | Chilodonella uncinata actin gene, partial cds; macronuclear | blastn | 2018 | 331 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 12498157 | 12498157 | PRJNA1095825_P_NODE_122070_length_348_cov_0.974545_g119007_i0 | PRJNA1095825 | 122070 | 348 | 0.974545 | 3.3914166 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 590 | 5.649999999999998e-164 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g119007 | i0 | 97.399 | 7.70977011494253 | 346 | 9 | 99 | 0 | 1 | 346 | 463 | 808 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 2683 | 590 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 23152517 | 23152517 | PRJNA1095825_P_NODE_194419_length_280_cov_1.985507_g191356_i0 | PRJNA1095825 | 194419 | 280 | 1.985507 | 5.5594196 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 398 | 2.8799999999999993e-106 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g191356 | i0 | 97.034 | 43.7607142857143 | 236 | 7 | 84 | 0 | 45 | 280 | 1205 | 970 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 12253 | 398 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23153754 | 23153754 | PRJNA1095825_P_NODE_56239_length_507_cov_3.366359_g53180_i0 | PRJNA1095825 | 56239 | 507 | 3.366359 | 17.06744013 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 815 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g53180 | i0 | 95.661 | 59.8737672583826 | 507 | 22 | 100 | 0 | 1 | 507 | 16 | 522 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30356 | 815 | 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);;