contig_metadata
8 rows where bioproject = "PRJNA526367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3046918 | 3046918 | PRJNA526367_P_NODE_34203_length_209_cov_13.262500_g33993_i0 | PRJNA526367 | 34203 | 209 | 13.2625 | 27.718625 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 351 | 1.61e-92 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g33993 | i0 | 98.02 | 55.6315789473684 | 202 | 4 | 97 | 0 | 1 | 202 | 3448 | 3247 | 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 | 11627 | 351 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 3665039 | 3665039 | PRJNA526367_P_NODE_41623_length_180_cov_3.610687_g41413_i0 | PRJNA526367 | 41623 | 180 | 3.610687 | 6.4992366 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 8.68e-40 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g41413 | i0 | 96.262 | 1.78333333333333 | 107 | 4 | 59 | 0 | 74 | 180 | 3082 | 2976 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 321 | 176 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 3665064 | 3665064 | PRJNA526367_P_NODE_43763_length_176_cov_6.692913_g43553_i0 | PRJNA526367 | 43763 | 176 | 6.692913 | 11.77952688 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 8.04e-75 | NTclustered | gi|1802599793|gb|MT001202.1| | 41631 | g43553 | i0 | 98.214 | 95.5340909090909 | 168 | 2 | 95 | 1 | 3 | 169 | 1402 | 1235 | Colpoda sp. strain HFCC1281 small subunit ribosomal RNA gene, partial sequence | blastn | 16814 | 292 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 4942025 | 4942025 | PRJNA526367_P_NODE_41424_length_180_cov_5.732824_g41214_i0 | PRJNA526367 | 41424 | 180 | 5.732824 | 10.3190832 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.36e-82 | NTclustered | gi|1802599794|gb|MT001203.1| | 41631 | g41214 | i0 | 100 | 95.6888888888889 | 172 | 0 | 96 | 0 | 7 | 178 | 738 | 909 | Colpoda sp. strain HFCC848 small subunit ribosomal RNA gene, partial sequence | blastn | 17224 | 318 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 5599998 | 5599998 | PRJNA526367_P_NODE_50225_length_167_cov_1.728814_g50015_i0 | PRJNA526367 | 50225 | 167 | 1.728814 | 2.88711938 | Euplotes woodruffi | 5942 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.75e-69 | NTclustered | gi|1233819913|gb|KX516605.1| | 5942 | g50015 | i0 | 97.516 | 32.3592814371258 | 161 | 2 | 96 | 2 | 1 | 160 | 1808 | 1649 | Euplotes woodruffi isolate Z1 large subunit ribosomal RNA gene, partial sequence | blastn | 5404 | 274 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes woodruffi | ||
| 13249798 | 13249798 | PRJNA526367_P_NODE_34231_length_209_cov_4.950000_g34021_i0 | PRJNA526367 | 34231 | 209 | 4.95 | 10.3455 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 3.47e-94 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g34021 | i0 | 98.995 | 95.8516746411483 | 199 | 2 | 95 | 0 | 8 | 206 | 378 | 576 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 20033 | 357 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 14524903 | 14524903 | PRJNA526367_P_NODE_39712_length_183_cov_5.850746_g39502_i0 | PRJNA526367 | 39712 | 183 | 5.850746 | 10.70686518 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.81e-76 | NTclustered | gi|2651357791|gb|PP174306.1| | 41631 | g39502 | i0 | 97.688 | 65.4972677595628 | 173 | 4 | 95 | 0 | 4 | 176 | 3591 | 3419 | 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 | 11986 | 298 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 18347869 | 18347869 | PRJNA526367_P_NODE_61735_length_156_cov_2.766355_g61525_i0 | PRJNA526367 | 61735 | 156 | 2.766355 | 4.3155138 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 265 | 1.52e-66 | NTclustered | gi|1073548544|gb|KU219950.1| | 5932 | g61525 | i0 | 98.667 | 97.8974358974359 | 150 | 1 | 96 | 1 | 1 | 149 | 2240 | 2091 | Ichthyophthirius multifiliis isolate Ich.BR 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 15272 | 265 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis |
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);;