contig_metadata
6 rows where bioproject = "PRJNA1237888" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4877904 | 4877904 | PRJNA1237888_S_NODE_4524_length_193_cov_1.958333_g4474_i0 | PRJNA1237888 | 4524 | 193 | 1.958333 | 3.77958269 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 161 | 2.6499999999999996e-35 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g4474 | i0 | 90.909 | 1.88082901554404 | 121 | 10 | 62 | 1 | 1 | 120 | 2962 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 363 | 161 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 5450150 | 5450150 | PRJNA1237888_S_NODE_6045_length_169_cov_0.875000_g5995_i0 | PRJNA1237888 | 6045 | 169 | 0.875 | 1.47875 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 6.0699999999999995e-56 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g5995 | i0 | 91.667 | 8.02366863905325 | 168 | 10 | 98 | 3 | 1 | 165 | 3396 | 3562 | Colpoda sp. isolate CIL1 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 | 1356 | 230 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 17627551 | 17627551 | PRJNA1237888_S_NODE_2454_length_259_cov_1.728571_g2404_i0 | PRJNA1237888 | 2454 | 259 | 1.728571 | 4.47699889 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 7.16e-122 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2404 | i0 | 98.062 | 98.2934362934363 | 258 | 5 | 99 | 0 | 1 | 258 | 2313 | 2056 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25458 | 449 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24001834 | 24001834 | PRJNA1237888_S_NODE_559_length_517_cov_3.047009_g510_i0 | PRJNA1237888 | 559 | 517 | 3.047009 | 15.75303653 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 671 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g510 | i0 | 93.231 | 83.7214700193424 | 458 | 27 | 89 | 4 | 60 | 517 | 1953 | 1500 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 43284 | 671 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 24572932 | 24572932 | PRJNA1237888_S_NODE_3340_length_222_cov_1.560694_g3290_i0 | PRJNA1237888 | 3340 | 222 | 1.560694 | 3.46474068 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.96e-75 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g3290 | i0 | 97.126 | 67.9864864864865 | 174 | 5 | 78 | 0 | 49 | 222 | 1569 | 1396 | Colpoda sp. isolate CIL1 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 | 15093 | 294 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 25275948 | 25275948 | PRJNA1237888_S_NODE_3700_length_212_cov_0.950920_g3650_i0 | PRJNA1237888 | 3700 | 212 | 0.95092 | 2.0159504 | Pseudochilodonopsis | 1170555 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.6499999999999996e-87 | NTclustered | gi|906358594|gb|KR611083.2| | 1170556 | g3650 | i0 | 97.927 | 85.1839622641509 | 193 | 4 | 91 | 0 | 20 | 212 | 610 | 802 | Pseudochilodonopsis fluviatilis isolate QZS2013071501 small subunit ribosomal RNA gene, partial sequence | blastn | 18059 | 335 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Pseudochilodonopsis | Pseudochilodonopsis fluviatilis |
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);;