contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA380660" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2349566 | 2349566 | PRJNA380660_P_NODE_7582_length_260_cov_2.038961_g7182_i0 | PRJNA380660 | 7582 | 260 | 2.038961 | 5.3012986 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.519999999999998e-128 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g7182 | i0 | 99.231 | 98.6692307692308 | 260 | 2 | 100 | 0 | 1 | 260 | 1486 | 1745 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25654 | 470 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 6779984 | 6779984 | PRJNA380660_P_NODE_4486_length_380_cov_228.387464_g4089_i0 | PRJNA380660 | 4486 | 380 | 228.387464 | 867.8723632 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 9.449999999999999e-48 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g4089 | i0 | 93.431 | 36.3289473684211 | 137 | 9 | 36 | 0 | 179 | 315 | 1148 | 1284 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 13805 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 8055502 | 8055502 | PRJNA380660_P_NODE_2147_length_577_cov_207.430657_g1808_i0 | PRJNA380660 | 2147 | 577 | 207.430657 | 1196.87489089 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.4899999999999999e-47 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g1808 | i0 | 93.431 | 25.3726169844021 | 137 | 9 | 24 | 0 | 179 | 315 | 1148 | 1284 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 14640 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 9330315 | 9330315 | PRJNA380660_P_NODE_1628_length_662_cov_25.099526_g1311_i0 | PRJNA380660 | 1628 | 662 | 25.099526 | 166.15886212 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 411 | 9.44e-110 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g1311 | i0 | 82.136 | 66.3444108761329 | 487 | 79 | 79 | 7 | 22 | 503 | 5873 | 6356 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 43920 | 411 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 10606014 | 10606014 | PRJNA380660_P_NODE_9109_length_223_cov_1.963918_g8709_i0 | PRJNA380660 | 9109 | 223 | 1.963918 | 4.37953714 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 8.23e-81 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g8709 | i0 | 91.964 | 76.6188340807175 | 224 | 16 | 100 | 2 | 1 | 223 | 1120 | 898 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 17086 | 313 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11277446 | 11277446 | PRJNA380660_P_NODE_5529_length_331_cov_2.937086_g5130_i0 | PRJNA380660 | 5529 | 331 | 2.937086 | 9.72175466 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.249999999999999e-145 | NTclustered | gi|1389430796|gb|MH341624.1| | 1654720 | g5130 | i0 | 98.333 | 93.1389728096677 | 300 | 5 | 100 | 0 | 32 | 331 | 47 | 346 | Chilodonella piscicola strain C.piscicola SC small subunit ribosomal RNA gene, partial sequence | blastn | 30829 | 527 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 11880938 | 11880938 | PRJNA380660_P_NODE_2870_length_494_cov_222.763441_g2501_i0 | PRJNA380660 | 2870 | 494 | 222.763441 | 1100.45139854 | Caryotricha minuta | 1004043 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 1.26e-47 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g2501 | i0 | 93.431 | 29.748987854251 | 137 | 9 | 28 | 0 | 90 | 226 | 1148 | 1284 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 14696 | 204 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 13155997 | 13155997 | PRJNA380660_P_NODE_6591_length_291_cov_2.351145_g6191_i0 | PRJNA380660 | 6591 | 291 | 2.351145 | 6.84183195 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 1.07e-115 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g6191 | i0 | 95.522 | 34.254295532646 | 268 | 12 | 100 | 0 | 1 | 268 | 899 | 632 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 9968 | 429 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 22751048 | 22751048 | PRJNA380660_P_NODE_4018_length_406_cov_6.880637_g3623_i0 | PRJNA380660 | 4018 | 406 | 6.880637 | 27.93538622 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3623 | i0 | 98.982 | 94.85960591133 | 393 | 4 | 97 | 0 | 1 | 393 | 2359 | 2751 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 38513 | 704 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;