contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA384462" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 405354 | 405354 | PRJNA384462_S_NODE_6221_length_220_cov_0.888889_g6105_i0 | PRJNA384462 | 6221 | 220 | 0.888889 | 1.9555558 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.2200000000000005e-91 | NTclustered | gi|110277428|gb|DQ662856.1| | 151077 | g6105 | i0 | 95.413 | 18.1954545454545 | 218 | 10 | 99 | 0 | 1 | 218 | 900 | 683 | Chilodonella uncinata heat shock protein 90 gene, partial cds; macronuclear | blastn | 4003 | 348 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 6783004 | 6783004 | PRJNA384462_S_NODE_13286_length_166_cov_0.871795_g13170_i0 | PRJNA384462 | 13286 | 166 | 0.871795 | 1.4471797 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 2.7099999999999998e-74 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g13170 | i0 | 98.193 | 40.4518072289157 | 166 | 3 | 100 | 0 | 1 | 166 | 707 | 872 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 6715 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8728507 | 8728507 | PRJNA384462_S_NODE_1507_length_424_cov_3.282667_g1391_i0 | PRJNA384462 | 1507 | 424 | 3.282667 | 13.91850808 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 171 | 1.0799999999999998e-37 | NTclustered | gi|1763307|gb|U75429.1|ECU75429 | 5936 | g1391 | i0 | 84.706 | 39.5377358490566 | 170 | 26 | 40 | 0 | 232 | 401 | 760 | 591 | Euplotes crassus macronuclear linear DNA, complete sequence, with histone H3 gene, complete cds | blastn | 16764 | 171 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 10609097 | 10609097 | PRJNA384462_S_NODE_11249_length_176_cov_1.165354_g11133_i0 | PRJNA384462 | 11249 | 176 | 1.165354 | 2.05102304 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 213 | 6.44e-51 | NTclustered | gi|829194480|ref|XM_012800280.1| | 312017 | g11133 | i0 | 88.953 | 0.977272727272727 | 172 | 19 | 98 | 0 | 1 | 172 | 534 | 363 | Tetrahymena thermophila SB210 hypothetical protein partial mRNA | blastn | 172 | 213 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 10609154 | 10609154 | PRJNA384462_S_NODE_9269_length_189_cov_1.092857_g9153_i0 | PRJNA384462 | 9269 | 189 | 1.092857 | 2.06549973 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.55e-45 | NTclustered | gi|471230286|ref|XM_004036375.1| | 5932 | g9153 | i0 | 85.263 | 80.978835978836 | 190 | 26 | 100 | 2 | 1 | 189 | 261 | 449 | Ichthyophthirius multifiliis hypothetical protein (IMG5_083250) mRNA, complete cds | blastn | 15305 | 195 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 13159032 | 13159032 | PRJNA384462_S_NODE_12431_length_169_cov_1.091667_g12315_i0 | PRJNA384462 | 12431 | 169 | 1.091667 | 1.84491723 | Polyplastron multivesiculatum | 47894 | SAR_Eukaryotes | SAR_Eukaryotes | 191 | 2.87e-44 | NTclustered | gi|92790169|emb|AJ965270.1| | 47894 | g12315 | i0 | 86.982 | 130.366863905325 | 169 | 22 | 100 | 0 | 1 | 169 | 253 | 85 | Polyplastron multivesiculatum partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) | blastn | 22032 | 191 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Polyplastron | Polyplastron multivesiculatum | ||
| 21477539 | 21477539 | PRJNA384462_S_NODE_4037_length_263_cov_2.962617_g3921_i0 | PRJNA384462 | 4037 | 263 | 2.962617 | 7.79168271 | Oxytrichidae | 57506 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.16e-42 | NTclustered | gi|331686220|gb|HQ432924.1| | 94289 | g3921 | i0 | 80.4 | 34.6844106463878 | 250 | 41 | 94 | 7 | 2 | 247 | 875 | 630 | Sterkiella histriomuscorum strain 310 heat shock protein 70 (hsp70) gene, complete cds; macronuclear | blastn | 9122 | 183 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Sterkiella | Sterkiella histriomuscorum | ||
| 23357419 | 23357419 | PRJNA384462_S_NODE_9419_length_188_cov_0.956835_g9303_i0 | PRJNA384462 | 9419 | 188 | 0.956835 | 1.7988498 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 276 | 8.780000000000001e-70 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g9303 | i0 | 93.085 | 1 | 188 | 13 | 100 | 0 | 1 | 188 | 437 | 624 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 188 | 276 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata |
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);;