RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA415636" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA415636 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
1083271 1083271 PRJNA415636_S_NODE_5781_length_215_cov_0.910714_g5734_i0 PRJNA415636 5781 215 0.910714 1.9580351 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 191 3.85e-44   NTclustered gi|1236613276|gb|KX785362.1| 5894 g5734 i0 100 44.5302325581395 103 0 48 0 1 103 401 503 Tetrahymena canadensis voucher 50099 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence; macronuclear blastn 9574 191 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena canadensis
6796863 6796863 PRJNA415636_S_NODE_5906_length_213_cov_1.530120_g5859_i0 PRJNA415636 5906 213 1.53012 3.2591556 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 230 8.069999999999998e-56   NTclustered gi|829195198|ref|XM_001025389.3| 312017 g5859 i0 97.059 5.60093896713615 136 4 64 0 17 152 321 456 Tetrahymena thermophila SB210 40S ribosomal protein S14 partial mRNA blastn 1193 230 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
9347243 9347243 PRJNA415636_S_NODE_1588_length_351_cov_2.088816_g1541_i0 PRJNA415636 1588 351 2.088816 7.33174416 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.003   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g1541 i0 100 0.327635327635328 30 0 9 0 1 30 12 41 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 115 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
9347244 9347244 PRJNA415636_S_NODE_1848_length_333_cov_2.632867_g1801_i0 PRJNA415636 1848 333 2.632867 8.76744711 Kentrophoros sp. 1 BS-2022 2930470 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.009   NTclustered gi|2261268989|emb|OX095830.1| 2930470 g1801 i0 100 0.423423423423423 29 0 9 0 1 29 10 38 Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) blastn 141 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Kentrophoridae Kentrophoros Kentrophoros sp. 1 BS-2022
10011370 10011370 PRJNA415636_S_NODE_3448_length_263_cov_7.550926_g3401_i0 PRJNA415636 3448 263 7.550926 19.85893538 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 475 1.2e-129   NTclustered gi|1837628855|gb|MN158348.1| 5909 g3401 i0 99.24 99.2433460076046 263 2 100 0 1 263 2922 2660 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 26101 475 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
11286558 11286558 PRJNA415636_S_NODE_6189_length_209_cov_2.191358_g6142_i0 PRJNA415636 6189 209 2.191358 4.57993822 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 387 4.42e-103   NTclustered gi|1172880852|gb|KY864168.1| 5909 g6142 i0 100 99.9712918660287 209 0 100 0 1 209 153 361 Tetrahymena rostrata isolate TR 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 20894 387 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
15721786 15721786 PRJNA415636_S_NODE_813_length_433_cov_3.914508_g766_i0 PRJNA415636 813 433 3.914508 16.94981964 Trachelocercidae sp. 3 BS-2022 2930473 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.012   NTclustered gi|2261268975|emb|OX095823.1| 2930473 g766 i0 100 0.131639722863741 29 0 7 0 1 29 9 37 Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) blastn 57 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Trachelocercidae   Trachelocercidae sp. 3 BS-2022
21485000 21485000 PRJNA415636_S_NODE_2037_length_321_cov_6.153285_g1990_i0 PRJNA415636 2037 321 6.153285 19.75204485 root 1 Root_unresolved Root_unresolved 577 4.02e-160   NTclustered gi|345541658|gb|JN547815.1| 5911 g1990 i0 99.065 73.1183800623053 321 3 100 0 1 321 3487 3807 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 23471 577 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);;