contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1263632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 363739 | 363739 | PRJNA1263632_P_NODE_6301_length_252_cov_2.027933_g6283_i0 | PRJNA1263632 | 6301 | 252 | 2.027933 | 5.11039116 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.49e-123 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g6283 | i0 | 99.206 | 96.8492063492064 | 252 | 2 | 100 | 0 | 1 | 252 | 1454 | 1203 | Vorticella sp. 4 JG-2011 clone 2 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 | 24406 | 455 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 1638495 | 1638495 | PRJNA1263632_P_NODE_2882_length_360_cov_1.397213_g2864_i0 | PRJNA1263632 | 2882 | 360 | 1.397213 | 5.0299668 | Loxophyllum shini | 1346494 | SAR_Eukaryotes | SAR_Eukaryotes | 571 | 2.1199999999999995e-158 | NTclustered | gi|375305428|gb|JF975388.1| | 1346494 | g2864 | i0 | 95.278 | 100.086111111111 | 360 | 17 | 100 | 0 | 1 | 360 | 1386 | 1027 | Loxophyllum shini isolate PHB2007053101 28S ribosomal RNA gene, partial sequence | blastn | 36031 | 571 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Pleurostomatida | Litonotidae | Loxophyllum | Loxophyllum shini | ||
| 2914484 | 2914484 | PRJNA1263632_P_NODE_6923_length_248_cov_1.748571_g6905_i0 | PRJNA1263632 | 6923 | 248 | 1.748571 | 4.33645608 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 451 | 1.89e-122 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g6905 | i0 | 99.595 | 52.5483870967742 | 247 | 1 | 99 | 0 | 1 | 247 | 3012 | 3258 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 13032 | 451 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 4882022 | 4882022 | PRJNA1263632_P_NODE_3864_length_315_cov_2.826446_g3846_i0 | PRJNA1263632 | 3864 | 315 | 2.826446 | 8.9033049 | Ophryoscolecidae | 47890 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 1.55e-94 | NTclustered | gi|860929|emb|Z49849.1| | 40636 | g3846 | i0 | 87.662 | 24.5333333333333 | 308 | 38 | 98 | 0 | 1 | 308 | 122 | 429 | Entodinium sp. gene for alpha-tubulin (partial) | blastn | 7728 | 359 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Entodiniomorphida | Ophryoscolecidae | Entodinium | Entodinium sp. | ||
| 5467098 | 5467098 | PRJNA1263632_P_NODE_6305_length_252_cov_1.720670_g6287_i0 | PRJNA1263632 | 6305 | 252 | 1.72067 | 4.3360884 | Vorticella sp. 1 | 2979179 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 6.89e-127 | NTclustered | gi|2304601489|gb|OP458310.1| | 2979179 | g6287 | i0 | 100 | 94.6468253968254 | 252 | 0 | 100 | 0 | 1 | 252 | 1461 | 1712 | Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence | blastn | 23851 | 466 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 1 | ||
| 5467165 | 5467165 | PRJNA1263632_P_NODE_8485_length_241_cov_0.880952_g8467_i0 | PRJNA1263632 | 8485 | 241 | 0.880952 | 2.12309432 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 8.7e-106 | NTclustered | gi|347439301|gb|JN111999.1| | 151077 | g8467 | i0 | 96.266 | 12.8423236514523 | 241 | 9 | 100 | 0 | 1 | 241 | 409 | 169 | Chilodonella uncinata strain USA_WH actin gene, partial cds; macronuclear | blastn | 3095 | 396 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 8706790 | 8706790 | PRJNA1263632_P_NODE_2487_length_384_cov_2.347267_g2469_i0 | PRJNA1263632 | 2487 | 384 | 2.347267 | 9.01350528 | Sessilida | 1974272 | SAR_Eukaryotes | SAR_Eukaryotes | 704 | 0 | NTclustered | gi|363412153|gb|JN120227.1| | 60850 | g2469 | i0 | 99.74 | 100.005208333333 | 384 | 1 | 100 | 0 | 1 | 384 | 947 | 564 | Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence | blastn | 38402 | 704 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella convallaria | ||
| 9982101 | 9982101 | PRJNA1263632_P_NODE_2688_length_372_cov_3.096990_g2670_i0 | PRJNA1263632 | 2688 | 372 | 3.09699 | 11.5208028 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 616 | 9.999999999999999e-172 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2670 | i0 | 96.505 | 89.2016129032258 | 372 | 13 | 100 | 0 | 1 | 372 | 10 | 381 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 33183 | 616 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10567719 | 10567719 | PRJNA1263632_P_NODE_1169_length_554_cov_1.130977_g1151_i0 | PRJNA1263632 | 1169 | 554 | 1.130977 | 6.26561258 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 894 | 0 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g1151 | i0 | 95.841 | 54.8808664259928 | 553 | 23 | 99 | 0 | 2 | 554 | 590 | 38 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 30404 | 894 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 11257321 | 11257321 | PRJNA1263632_P_NODE_6309_length_252_cov_1.653631_g6291_i0 | PRJNA1263632 | 6309 | 252 | 1.653631 | 4.16715012 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.94e-122 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g6291 | i0 | 98.81 | 80.3174603174603 | 252 | 3 | 100 | 0 | 1 | 252 | 2401 | 2652 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 20240 | 449 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 15081627 | 15081627 | PRJNA1263632_P_NODE_8332_length_241_cov_1.125000_g8314_i0 | PRJNA1263632 | 8332 | 241 | 1.125 | 2.71125 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 174 | 4.4399999999999997e-39 | NTclustered | gi|10792|emb|X12768.1| | 5908 | g8314 | i0 | 82.99 | 64.9875518672199 | 194 | 31 | 80 | 2 | 1 | 193 | 1265 | 1457 | Tetrahymena pyriformis beta-tubulin gene 1 (beta-TT1) | blastn | 15662 | 174 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 15666712 | 15666712 | PRJNA1263632_P_NODE_7993_length_243_cov_0.905882_g7975_i0 | PRJNA1263632 | 7993 | 243 | 0.905882 | 2.20129326 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 165 | 2.6999999999999997e-36 | NTclustered | gi|584458848|gb|KJ159074.1| | 5949 | g7975 | i0 | 79.915 | 87.2633744855967 | 234 | 39 | 95 | 8 | 14 | 243 | 1157 | 928 | Stylonychia lemnae histone variant H3.1 (HIS31) gene, complete cds; macronuclear | blastn | 21205 | 165 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 18215442 | 18215442 | PRJNA1263632_P_NODE_4275_length_301_cov_1.561404_g4257_i0 | PRJNA1263632 | 4275 | 301 | 1.561404 | 4.69982604 | Dasytricha ruminantium | 40806 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 5.2599999999999996e-99 | NTclustered | gi|92790149|emb|AJ965260.1| | 40806 | g4257 | i0 | 89.037 | 128.083056478405 | 301 | 33 | 100 | 0 | 1 | 301 | 359 | 659 | Dasytricha ruminantium partial mRNA for Polyubiqutin 4 (polyubiqutin 4 gene) | blastn | 38553 | 374 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Dasytricha | Dasytricha ruminantium | ||
| 22040286 | 22040286 | PRJNA1263632_P_NODE_1098_length_570_cov_2.438632_g1080_i0 | PRJNA1263632 | 1098 | 570 | 2.438632 | 13.9002024 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 931 | 0 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g1080 | i0 | 96.14 | 80.4684210526316 | 570 | 22 | 100 | 0 | 1 | 570 | 1491 | 2060 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 45867 | 931 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 22040307 | 22040307 | PRJNA1263632_P_NODE_1718_length_458_cov_1.797403_g1700_i0 | PRJNA1263632 | 1718 | 458 | 1.797403 | 8.23210574 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 433 | 1.3599999999999999e-116 | NTclustered | gi|2386234047|ref|XM_001435408.2| | 5888 | g1700 | i0 | 84.545 | 66.2117903930131 | 440 | 64 | 96 | 4 | 21 | 458 | 629 | 192 | Paramecium tetraurelia uncharacterized protein (GSPATT00036831001), mRNA | blastn | 30325 | 433 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 22730836 | 22730836 | PRJNA1263632_P_NODE_2758_length_368_cov_2.542373_g2740_i0 | PRJNA1263632 | 2758 | 368 | 2.542373 | 9.35593264 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 339 | 2.3999999999999997e-88 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2740 | i0 | 97.949 | 59.0570652173913 | 195 | 4 | 53 | 0 | 1 | 195 | 2888 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 21733 | 339 | 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);;