contig_metadata
9 rows where bioproject = "PRJNA529241", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8767541 | 8767541 | PRJNA529241_P_NODE_107067_length_212_cov_2.411429_g104745_i0 | PRJNA529241 | 107067 | 212 | 2.411429 | 5.11222948 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 9.67e-105 | NTclustered | gi|1802599786|gb|MT001195.1| | 41631 | g104745 | i0 | 100 | 100.047169811321 | 212 | 0 | 100 | 0 | 1 | 212 | 744 | 533 | Colpoda sp. strain HFCC1289 small subunit ribosomal RNA gene, partial sequence | blastn | 21210 | 392 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11319787 | 11319787 | PRJNA529241_P_NODE_74769_length_246_cov_1.459330_g72447_i0 | PRJNA529241 | 74769 | 246 | 1.45933 | 3.5899518 | Colpoda | 5979 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.74e-122 | NTclustered | gi|1802599789|gb|MT001198.1| | 41631 | g72447 | i0 | 99.593 | 100.069105691057 | 246 | 1 | 100 | 0 | 1 | 246 | 72 | 317 | Colpoda sp. strain HFCC1224 small subunit ribosomal RNA gene, partial sequence | blastn | 24617 | 449 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 11980013 | 11980013 | PRJNA529241_P_NODE_461370_length_153_cov_1.655172_g459048_i0 | PRJNA529241 | 461370 | 153 | 1.655172 | 2.53241316 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 8.84e-69 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g459048 | i0 | 98.693 | 93.156862745098 | 153 | 2 | 100 | 0 | 1 | 153 | 1610 | 1762 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 14253 | 272 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 18350430 | 18350430 | PRJNA529241_P_NODE_171475_length_176_cov_1.733813_g169153_i0 | PRJNA529241 | 171475 | 176 | 1.733813 | 3.05151088 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.98e-80 | NTclustered | gi|2651357788|gb|PP174303.1| | 41631 | g169153 | i0 | 98.295 | 99.5454545454545 | 176 | 3 | 100 | 0 | 1 | 176 | 2825 | 3000 | 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 | 17520 | 309 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 20902880 | 20902880 | PRJNA529241_P_NODE_407337_length_172_cov_1.644444_g405015_i0 | PRJNA529241 | 407337 | 172 | 1.644444 | 2.82844368 | Tetrahymena sp. FN-2012 | 1217406 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.2899999999999999e-82 | NTclustered | gi|400269896|gb|JX271898.1| | 1217406 | g405015 | i0 | 100 | 98.7732558139535 | 172 | 0 | 100 | 0 | 1 | 172 | 549 | 378 | Tetrahymena sp. FN-2012 strain HFCC700 28S large subunit ribosomal RNA gene, partial sequence | blastn | 16989 | 318 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. FN-2012 | ||
| 28608549 | 28608549 | PRJNA529241_P_NODE_300207_length_173_cov_3.536765_g297885_i0 | PRJNA529241 | 300207 | 173 | 3.536765 | 6.11860345 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 0.00117 | NR | OMJ86890.1 | 5963 | g297885 | i0 | 79.2 | 0.832369942196532 | 24 | 5 | 41.6 | 0 | 98 | 169 | 198 | 221 | OMJ86890.1 hypothetical protein SteCoe_11529 [Stentor coeruleus] | diamond | 144 | 45.8 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Stentoridae | Stentor | Stentor coeruleus | ||
| 31942154 | 31942154 | PRJNA529241_P_NODE_101197_length_217_cov_1.450000_g98875_i0 | PRJNA529241 | 101197 | 217 | 1.45 | 3.1465 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.014 | NR | KAL4460608.1 | 2486642 | g98875 | i0 | 33.8 | 1.963133640553 | 71 | 45 | 95.4 | 1 | 216 | 10 | 60 | 130 | KAL4460608.1 hypothetical protein ABPG72_004035 [Tetrahymena utriculariae] | diamond | 426 | 43.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 31942282 | 31942282 | PRJNA529241_P_NODE_526157_length_151_cov_3.736842_g523835_i0 | PRJNA529241 | 526157 | 151 | 3.736842 | 5.64263142 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 45.8 | 8.17e-4 | NR | CAI2377331.1 | 5936 | g523835 | i0 | 60 | 0.596026490066225 | 30 | 12 | 59.6 | 0 | 92 | 3 | 94 | 123 | CAI2377331.1 unnamed protein product [Moneuplotes crassus] | diamond | 90 | 45.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 32400760 | 32400760 | PRJNA529241_P_NODE_516619_length_151_cov_4.105263_g514297_i0 | PRJNA529241 | 516619 | 151 | 4.105263 | 6.19894713 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 80.9 | 1.3e-16 | NR | XP_004034656.1 | 5932 | g514297 | i0 | 75.5 | 1.94701986754967 | 49 | 12 | 97.4 | 0 | 150 | 4 | 204 | 252 | XP_004034656.1 hypothetical protein IMG5_116410 [Ichthyophthirius multifiliis] | diamond | 294 | 81.6 | 0.991421568627451 | 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);;