contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1215813" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 331622 | 331622 | PRJNA1215813_P_NODE_2041_length_519_cov_1.921525_g1961_i0 | PRJNA1215813 | 2041 | 519 | 1.921525 | 9.97271475 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 948 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g1961 | i0 | 99.615 | 58.5529865125241 | 519 | 2 | 100 | 0 | 1 | 519 | 536 | 18 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30389 | 948 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 4158806 | 4158806 | PRJNA1215813_P_NODE_6304_length_311_cov_1.310924_g6224_i0 | PRJNA1215813 | 6304 | 311 | 1.310924 | 4.07697364 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 497 | 3.11e-136 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g6224 | i0 | 95.498 | 86.2057877813505 | 311 | 14 | 100 | 0 | 1 | 311 | 3452 | 3762 | Colpoda sp. isolate JGP15 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 26810 | 497 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 4158830 | 4158830 | PRJNA1215813_P_NODE_8104_length_275_cov_2.316832_g8024_i0 | PRJNA1215813 | 8104 | 275 | 2.316832 | 6.371288 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 508 | 1.2499999999999999e-139 | NTclustered | gi|347439301|gb|JN111999.1| | 151077 | g8024 | i0 | 100 | 13.2836363636364 | 275 | 0 | 100 | 0 | 1 | 275 | 525 | 251 | Chilodonella uncinata strain USA_WH actin gene, partial cds; macronuclear | blastn | 3653 | 508 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6709600 | 6709600 | PRJNA1215813_P_NODE_5546_length_329_cov_4.539062_g5466_i0 | PRJNA1215813 | 5546 | 329 | 4.539062 | 14.93351398 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 608 | 1.4599999999999995e-169 | NTclustered | gi|2223186636|gb|MW310239.1| | 151077 | g5466 | i0 | 100 | 95.3677811550152 | 329 | 0 | 100 | 0 | 1 | 329 | 12 | 340 | Chilodonella uncinata isolate 20200709 small subunit ribosomal RNA gene, partial sequence | blastn | 31376 | 608 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11810478 | 11810478 | PRJNA1215813_P_NODE_6510_length_307_cov_1.000000_g6430_i0 | PRJNA1215813 | 6510 | 307 | 1 | 3.07 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 3.65e-11 | NTclustered | gi|471232437|ref|XM_004037270.1| | 5932 | g6430 | i0 | 92.857 | 0.182410423452769 | 56 | 4 | 18 | 0 | 205 | 260 | 101 | 46 | Ichthyophthirius multifiliis hypothetical protein (IMG5_056040) mRNA, complete cds | blastn | 56 | 82.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 12524504 | 12524504 | PRJNA1215813_P_NODE_3710_length_395_cov_6.487578_g3630_i0 | PRJNA1215813 | 3710 | 395 | 6.487578 | 25.6259331 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 316 | 1.21e-81 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3630 | i0 | 97.814 | 51.9670886075949 | 183 | 4 | 46 | 0 | 213 | 395 | 3082 | 2900 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20527 | 316 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 12524509 | 12524509 | PRJNA1215813_P_NODE_7110_length_293_cov_1.418182_g7030_i0 | PRJNA1215813 | 7110 | 293 | 1.418182 | 4.15527326 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 531 | 2.86e-146 | NTclustered | gi|1442777303|gb|MH715344.1| | 41631 | g7030 | i0 | 99.317 | 100.194539249147 | 293 | 2 | 100 | 0 | 1 | 293 | 10 | 302 | Colpoda sp. isolate HSP-001 small subunit ribosomal RNA gene, partial sequence | blastn | 29357 | 536 | 0.990671641791045 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 13085403 | 13085403 | PRJNA1215813_P_NODE_3091_length_430_cov_2.061625_g3011_i0 | PRJNA1215813 | 3091 | 430 | 2.061625 | 8.8649875 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 795 | 0 | NTclustered | gi|301014695|gb|GQ377692.1| | 151077 | g3011 | i0 | 100 | 18.506976744186 | 430 | 0 | 100 | 0 | 1 | 430 | 17 | 446 | Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence | blastn | 7958 | 795 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 15073411 | 15073411 | PRJNA1215813_P_NODE_1292_length_643_cov_14.478947_g1215_i0 | PRJNA1215813 | 1292 | 643 | 14.478947 | 93.09962921 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 1037 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1215 | i0 | 95.794 | 62.8786936236392 | 642 | 27 | 99 | 0 | 1 | 642 | 651 | 10 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 40431 | 1037 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 18183426 | 18183426 | PRJNA1215813_P_NODE_995_length_720_cov_2.384853_g922_i0 | PRJNA1215813 | 995 | 720 | 2.384853 | 17.1709416 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 1319 | 0 | NTclustered | gi|110644972|gb|DQ665918.1| | 151077 | g922 | i0 | 99.722 | 99.1833333333333 | 720 | 2 | 100 | 0 | 1 | 720 | 723 | 4 | Chilodonella uncinata clone 1 beta-tubulin gene, partial cds | blastn | 71412 | 1319 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19457826 | 19457826 | PRJNA1215813_P_NODE_5516_length_330_cov_1.509728_g5436_i0 | PRJNA1215813 | 5516 | 330 | 1.509728 | 4.9821024 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 610 | 4.09e-170 | NTclustered | gi|300521444|gb|GQ377690.1| | 151077 | g5436 | i0 | 100 | 4.13333333333333 | 330 | 0 | 100 | 0 | 1 | 330 | 286 | 615 | Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence | blastn | 1364 | 610 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 19457887 | 19457887 | PRJNA1215813_P_NODE_9256_length_253_cov_1.300000_g9176_i0 | PRJNA1215813 | 9256 | 253 | 1.3 | 3.289 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 448 | 2.5099999999999998e-121 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g9176 | i0 | 100 | 48.0830039525692 | 242 | 0 | 96 | 0 | 1 | 242 | 964 | 1205 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 12165 | 448 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23283938 | 23283938 | PRJNA1215813_P_NODE_3359_length_414_cov_1.829912_g3279_i0 | PRJNA1215813 | 3359 | 414 | 1.829912 | 7.57583568 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 5.35e-155 | NTclustered | gi|21632109|gb|AY041125.1| | 151077 | g3279 | i0 | 100 | 81.3840579710145 | 303 | 0 | 73 | 0 | 1 | 303 | 303 | 1 | Chilodonella uncinata clone 5 alpha-tubulin gene, partial cds | blastn | 33693 | 560 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 23997900 | 23997900 | PRJNA1215813_P_NODE_10939_length_247_cov_2.241379_g10859_i0 | PRJNA1215813 | 10939 | 247 | 2.241379 | 5.53620613 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.05e-124 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g10859 | i0 | 100 | 100.380566801619 | 247 | 0 | 100 | 0 | 1 | 247 | 2803 | 2557 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 24794 | 457 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24558001 | 24558001 | PRJNA1215813_P_NODE_8360_length_270_cov_9.091371_g8280_i0 | PRJNA1215813 | 8360 | 270 | 9.091371 | 24.5467017 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 483 | 7.409999999999998e-132 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g8280 | i0 | 98.889 | 100.625925925926 | 270 | 3 | 100 | 0 | 1 | 270 | 667 | 936 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 27169 | 483 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha |
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);;