RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA939415" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA939415 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
5085155 5085155 PRJNA939415_P_NODE_99824_length_235_cov_2.672840_g99402_i0 PRJNA939415 99824 235 2.67284 6.281174 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 435 1.79e-117   NTclustered gi|1237411828|gb|KX832094.1| 5908 g99402 i0 100 87.1872340425532 235 0 100 0 1 235 586 352 Tetrahymena pyriformis voucher 30331 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 20489 435 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
16218083 16218083 PRJNA939415_P_NODE_22213_length_330_cov_2.996109_g21792_i0 PRJNA939415 22213 330 2.996109 9.8871597 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 484 2.5799999999999996e-132   NTclustered gi|110645063|gb|DQ665311.1| 151077 g21792 i0 97.203 48.1090909090909 286 8 87 0 1 286 920 1205 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 15876 484 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
18768198 18768198 PRJNA939415_P_NODE_94775_length_241_cov_4.607143_g94353_i0 PRJNA939415 94775 241 4.607143 11.10321463 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 388 1.46e-103   NTclustered gi|301014695|gb|GQ377692.1| 151077 g94353 i0 95.833 64.4896265560166 240 10 99 0 2 241 471 232 Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence blastn 15542 388 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata

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