RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA826497" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA826497 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
2503757 2503757 PRJNA826497_S_NODE_7902_length_200_cov_6.113772_g7862_i0 PRJNA826497 7902 200 6.113772 12.227544 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 364 1.96e-96   NTclustered gi|2624665746|gb|OR878271.1| 210825 g7862 i0 99.5 94.095 200 1 100 0 1 200 653 852 Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence blastn 18819 364 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Glaucomidae Glaucoma Glaucoma scintillans
9748693 9748693 PRJNA826497_S_NODE_6508_length_211_cov_14.348315_g6468_i0 PRJNA826497 6508 211 14.348315 30.27494465 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.005   NTclustered gi|471228422|ref|XM_004035045.1| 5932 g6468 i0 100 0.137440758293839 29 0 14 0 67 95 1136 1164 Ichthyophthirius multifiliis hypothetical protein (IMG5_106200) mRNA, complete cds blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
14848713 14848713 PRJNA826497_S_NODE_4772_length_230_cov_2.472081_g4732_i0 PRJNA826497 4772 230 2.472081 5.6857863 uncultured Pseudocyrtolophosis 2590482 SAR_Eukaryotes SAR_Eukaryotes 425 1.05e-114   NTclustered gi|1691659327|gb|MN097001.1| 2590482 g4732 i0 100 97.0130434782609 230 0 100 0 1 230 27 256 Uncultured Pseudocyrtolophosis clone OTU123 small subunit ribosomal RNA gene, partial sequence blastn 22313 425 1 Eukaryota Sar   Ciliophora Colpodea Cyrtolophosidida Cyrtolophosididae   uncultured Pseudocyrtolophosis
22905749 22905749 PRJNA826497_S_NODE_10878_length_182_cov_5.241611_g10838_i0 PRJNA826497 10878 182 5.241611 9.53973202 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 215 1.87e-51   NTclustered gi|161728|gb|M86723.1|TETATUB 5911 g10838 i0 94.891 62.478021978022 137 7 75 0 1 137 2601 2737 Tetrahymena thermophila alpha-tubulin gene, complete cds blastn 11371 215 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);;