RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA675331", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 19 ✖

tax_clade 1

  • Sar · 19 ✖

bioproject 1

  • PRJNA675331 · 19 ✖

tax_kingdom 0

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
3198598 3198598 PRJNA675331_P_NODE_11523_length_297_cov_1.370536_g11351_i0 PRJNA675331 11523 297 1.370536 4.07049192 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 385 2.3999999999999996e-102   NTclustered gi|67462291|gb|DQ062087.1| 329142 g11351 i0 90.169 30.2558922558923 295 29 99 0 1 295 318 24 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 8986 385 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
3198695 3198695 PRJNA675331_P_NODE_3603_length_494_cov_1.194774_g3432_i0 PRJNA675331 3603 494 1.194774 5.90218356 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 647 0   NTclustered gi|67462291|gb|DQ062087.1| 329142 g3432 i0 90.303 88.5121457489878 495 46 100 2 1 494 775 282 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 43725 647 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
7026463 7026463 PRJNA675331_P_NODE_8306_length_340_cov_1.116105_g8134_i0 PRJNA675331 8306 340 1.116105 3.794757 Rimostrombidium veniliae 702563 SAR_Eukaryotes SAR_Eukaryotes 381 3.609999999999999e-101   NTclustered gi|759083337|gb|KM221993.1| 702563 g8134 i0 86.982 97.4941176470588 338 44 99 0 1 338 584 921 Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds blastn 33148 381 1 Eukaryota Sar   Ciliophora Spirotrichea Choreotrichida Strobilidiidae Rimostrombidium Rimostrombidium veniliae
20294875 20294875 PRJNA675331_P_NODE_17556_length_254_cov_1.005525_g17384_i0 PRJNA675331 17556 254 1.005525 2.5540335 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 154 1.38e-41   NR AED86993.1 5949 g17384 i0 90.4 0.980314960629921 83 8 98 0 5 253 293 375 AED86993.1 heat shock protein 70 [Stylonychia lemnae] diamond 249 154 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
23600572 23600572 PRJNA675331_P_NODE_21479_length_245_cov_0.895349_g21307_i0 PRJNA675331 21479 245 0.895349 2.19360505 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 326 1.18e-84   NTclustered gi|67462291|gb|DQ062087.1| 329142 g21307 i0 90.612 16.7673469387755 245 23 100 0 1 245 411 167 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 4108 326 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
26701901 26701901 PRJNA675331_P_NODE_1461_length_751_cov_5.806785_g1303_i0 PRJNA675331 1461 751 5.806785 43.60895535 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 77.4 8.44e-13   NR CAD8131000.1 65129 g1303 i0 33.1 0.495339547270306 124 81 49.1 2 88 456 113 235 CAD8131000.1 unnamed protein product [Paramecium sonneborni] diamond 372 77.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
27050391 27050391 PRJNA675331_P_NODE_23582_length_242_cov_0.911243_g23410_i0 PRJNA675331 23582 242 0.911243 2.20520806 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0365   NR CAG9314163.1 1481888 g23410 i0 29 1.15289256198347 93 51 96.7 2 238 5 356 448 CAG9314163.1 unnamed protein product [Blepharisma stoltei] diamond 279 42.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
27208124 27208124 PRJNA675331_P_NODE_22782_length_243_cov_0.905882_g22610_i0 PRJNA675331 22782 243 0.905882 2.20129326 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 56.2 6.71e-7   NR CAD8169608.1 43137 g22610 i0 32.1 1 81 53 97.5 1 1 237 477 557 CAD8169608.1 unnamed protein product [Paramecium octaurelia] diamond 243 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
28262109 28262109 PRJNA675331_P_NODE_19106_length_249_cov_1.306818_g18934_i0 PRJNA675331 19106 249 1.306818 3.25397682 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0081   NR CAI2363261.1 5936 g18934 i0 80 2.78313253012048 25 5 30.1 0 76 2 94 118 CAI2363261.1 unnamed protein product [Moneuplotes crassus] diamond 693 44.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28356900 28356900 PRJNA675331_P_NODE_6626_length_376_cov_1.016502_g6454_i0 PRJNA675331 6626 376 1.016502 3.82204752 root 1 Root_unresolved Root_unresolved 66.2 7.93e-10   NR XP_001009631.1 312017 g6454 i0 34.5 3.78989361702128 113 63 83 2 50 361 71 181 XP_001009631.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 1425 66.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28976824 28976824 PRJNA675331_P_NODE_21068_length_246_cov_0.890173_g20896_i0 PRJNA675331 21068 246 0.890173 2.18982558 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.32e-11   NR CDW72111.1 5949 g20896 i0 40.5 0.902439024390244 74 44 90.2 0 241 20 1617 1690 CDW72111.1 UNKNOWN [Stylonychia lemnae] diamond 222 68.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29103139 29103139 PRJNA675331_P_NODE_24088_length_241_cov_0.916667_g23916_i0 PRJNA675331 24088 241 0.916667 2.20916747 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 109 3.03e-28   NR TNV75793.1 5974 g23916 i0 70 0.871369294605809 70 16 87.1 1 32 241 37 101 TNV75793.1 hypothetical protein FGO68_gene5231 [Halteria grandinella] diamond 210 109 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
29260667 29260667 PRJNA675331_P_NODE_20369_length_247_cov_0.885057_g20197_i0 PRJNA675331 20369 247 0.885057 2.18609079 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.08e-8   NR CAI2362582.1 5936 g20197 i0 40.2 0.995951417004049 82 47 97.2 1 3 242 306 387 CAI2362582.1 unnamed protein product [Moneuplotes crassus] diamond 246 60.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29513294 29513294 PRJNA675331_P_NODE_19250_length_249_cov_0.875000_g19078_i0 PRJNA675331 19250 249 0.875 2.17875 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 123 8.369999999999999e-32   NR CDW75132.1 5949 g19078 i0 63.8 0.963855421686747 80 29 96.4 0 9 248 246 325 CDW75132.1 beta--glucan-binding [Stylonychia lemnae] diamond 240 123 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30567328 30567328 PRJNA675331_P_NODE_18913_length_250_cov_0.870056_g18741_i0 PRJNA675331 18913 250 0.870056 2.17514 Sporadotrichida 693921 SAR_Eukaryotes SAR_Eukaryotes 111 4.53e-27   NR CDW78117.1 5949 g18741 i0 60.8 2.88 79 31 94.8 0 250 14 281 359 CDW78117.1 developmentally-regulated gtp-binding protein 2 [Stylonychia lemnae] diamond 720 111 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30745430 30745430 PRJNA675331_P_NODE_18814_length_250_cov_0.870056_g18642_i0 PRJNA675331 18814 250 0.870056 2.17514 Oxytricha sp. LPJ-2 99928 SAR_Eukaryotes SAR_Eukaryotes 157 6.12e-45   NR AAY67879.1 329142 g18642 i0 98.8 1.992 83 1 99.6 0 2 250 257 339 AAY67879.1 heat shock protein 70, partial [Oxytricha sp. LPJ-2005] diamond 498 157 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
30777116 30777116 PRJNA675331_P_NODE_15514_length_268_cov_1.184615_g15342_i0 PRJNA675331 15514 268 1.184615 3.1747682 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 79.3 4.46e-15   NR CAG9315317.1 1481888 g15342 i0 65.5 2.75373134328358 55 19 61.6 0 165 1 8 62 CAG9315317.1 unnamed protein product [Blepharisma stoltei] diamond 738 79.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31757059 31757059 PRJNA675331_P_NODE_22137_length_244_cov_0.900585_g21965_i0 PRJNA675331 22137 244 0.900585 2.1974274 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.4e-5   NR XP_001031493.1 312017 g21965 i0 38.7 1.90573770491803 75 41 92.2 1 4 228 127 196 XP_001031493.1 EF-hand protein [Tetrahymena thermophila SB210] diamond 465 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32768458 32768458 PRJNA675331_P_NODE_22640_length_243_cov_0.905882_g22468_i0 PRJNA675331 22640 243 0.905882 2.20129326 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 65.5 3.63e-10   NR TNV74890.1 5974 g22468 i0 46.4 0.691358024691358 56 30 69.1 0 169 2 390 445 TNV74890.1 hypothetical protein FGO68_gene13970 [Halteria grandinella] diamond 168 65.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;