RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA1073712" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA1073712 · 11 ✖

analysis 1

  • blastn · 11 ✖

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
1462185 1462185 PRJNA1073712_P_NODE_8222_length_280_cov_1.304348_g8139_i0 PRJNA1073712 8222 280 1.304348 3.6521744 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 305 1.79e-78   NTclustered gi|829196136|ref|XM_001025866.3| 312017 g8139 i0 87.547 0.946428571428571 265 31 94 2 17 280 510 247 Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA blastn 265 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
2291519 2291519 PRJNA1073712_P_NODE_14742_length_245_cov_0.895349_g14659_i0 PRJNA1073712 14742 245 0.895349 2.19360505 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 403 5.299999999999998e-108   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g14659 i0 96.327 68.9795918367347 245 9 100 0 1 245 214 458 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 16900 403 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2738179 2738179 PRJNA1073712_P_NODE_16463_length_242_cov_0.911243_g16380_i0 PRJNA1073712 16463 242 0.911243 2.20520806 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 193 1.23e-44   NTclustered gi|829185314|ref|XM_001031847.2| 312017 g16380 i0 92.537 0.553719008264463 134 10 55 0 109 242 720 587 Tetrahymena thermophila SB210 60S ribosomal protein L7 partial mRNA blastn 134 193 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
3566803 3566803 PRJNA1073712_P_NODE_4223_length_351_cov_1.158273_g4140_i0 PRJNA1073712 4223 351 1.158273 4.06553823 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 405 2.21e-108   NTclustered gi|3861467|emb|AJ012585.1| 5911 g4140 i0 88.788 5.51851851851852 330 37 94 0 11 340 3135 2806 Tetrahymena thermophila macronuclear gene encoding ribosomal protein L3, exons 1-2 blastn 1937 405 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8669413 8669413 PRJNA1073712_P_NODE_6147_length_309_cov_1.889831_g6064_i0 PRJNA1073712 6147 309 1.889831 5.83957779 Caryotricha 500583 SAR_Eukaryotes SAR_Eukaryotes 195 4.53e-45   NTclustered gi|759083508|gb|KM222125.1| 1004043 g6064 i0 94.444 41.0453074433657 126 7 41 0 175 300 1281 1156 Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence blastn 12683 195 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha minuta
9944337 9944337 PRJNA1073712_P_NODE_13728_length_246_cov_1.554913_g13645_i0 PRJNA1073712 13728 246 1.554913 3.82508598 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 305 1.54e-78   NTclustered gi|315570322|tpg|BK007923.1| 5911 g13645 i0 89.024 2.99593495934959 246 27 100 0 1 246 183 428 TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS16e mRNA, complete cds blastn 737 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11666264 11666264 PRJNA1073712_P_NODE_17030_length_241_cov_0.916667_g16947_i0 PRJNA1073712 17030 241 0.916667 2.20916747 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 211 3.38e-50   NTclustered gi|229594318|ref|XM_001030083.3| 312017 g16947 i0 84.404 0.904564315352697 218 31 90 3 4 219 217 1 Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA blastn 218 211 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
12941326 12941326 PRJNA1073712_P_NODE_13811_length_246_cov_0.890173_g13728_i0 PRJNA1073712 13811 246 0.890173 2.18982558 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 348 2.53e-91   NTclustered gi|829153590|ref|XM_001010934.3| 312017 g13728 i0 92.245 0.995934959349594 245 19 99 0 1 245 263 19 Tetrahymena thermophila SB210 transcription factor BTF3a partial mRNA blastn 245 348 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
18039323 18039323 PRJNA1073712_P_NODE_7615_length_287_cov_1.014019_g7532_i0 PRJNA1073712 7615 287 1.014019 2.91023453 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 270 6.7299999999999984e-68   NTclustered gi|829194699|ref|XM_001025224.3| 312017 g7532 i0 84.962 0.926829268292683 266 40 93 0 15 280 1 266 Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA blastn 266 270 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
19313276 19313276 PRJNA1073712_P_NODE_12836_length_248_cov_0.880000_g12753_i0 PRJNA1073712 12836 248 0.88 2.1824 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 259 1.23e-64   NTclustered gi|118385632|ref|XM_001025944.1| 312017 g12753 i0 85.484 1 248 36 100 0 1 248 666 419 Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA blastn 248 259 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24413452 24413452 PRJNA1073712_P_NODE_11220_length_251_cov_0.865169_g11137_i0 PRJNA1073712 11220 251 0.865169 2.17157419 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 331 2.6100000000000006e-86   NTclustered gi|829164593|ref|XM_972055.3| 312017 g11137 i0 90.438 1 251 24 100 0 1 251 2131 2381 Tetrahymena thermophila SB210 cytoplasmic-like aconitate hydratase partial mRNA blastn 251 331 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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