RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1180292" 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

  • PRJNA1180292 · 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
11796553 11796553 PRJNA1180292_P_NODE_9370_length_250_cov_0.881356_g9238_i0 PRJNA1180292 9370 250 0.881356 2.20339 Oxytricha sp. LPJ-2005 329142 SAR_Eukaryotes SAR_Eukaryotes 372 1.53e-98   NTclustered gi|67462291|gb|DQ062087.1| 329142 g9238 i0 93.6 99.06 250 15 100 1 1 250 793 545 Oxytricha sp. LPJ-2005 heat shock protein 70 mRNA, partial cds; macronuclear blastn 24765 372 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha sp. LPJ-2005
15620677 15620677 PRJNA1180292_P_NODE_7053_length_266_cov_1.233161_g6921_i0 PRJNA1180292 7053 266 1.233161 3.28020826 Gastrocirrhus monilifer 402891 SAR_Eukaryotes SAR_Eukaryotes 69.4 2.42e-7   NTclustered gi|759083525|gb|KM222142.1| 402891 g6921 i0 73.558 1.21804511278195 208 43 76 12 3 204 1718 1517 Gastrocirrhus monilifer voucher CXM08100701 large subunit ribosomal RNA gene, partial sequence blastn 324 69.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Gastrocirrhidae Gastrocirrhus Gastrocirrhus monilifer
20719250 20719250 PRJNA1180292_P_NODE_6817_length_270_cov_1.319797_g6685_i0 PRJNA1180292 6817 270 1.319797 3.5634519 Euplotes eurystomus 5941 SAR_Eukaryotes SAR_Eukaryotes 191 5.03e-44   NTclustered gi|159037|gb|M57231.1|EUPUBQP 5941 g6685 i0 88.961 69.4185185185185 154 17 57 0 117 270 852 699 Euplotes eurystomus macronuclear polyubiquitin, complete cds blastn 18743 191 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus
23270030 23270030 PRJNA1180292_P_NODE_4299_length_334_cov_0.892720_g4167_i0 PRJNA1180292 4299 334 0.89272 2.9816848 Euplotes eurystomus 5941 SAR_Eukaryotes SAR_Eukaryotes 202 2.95e-47   NTclustered gi|1209311|gb|L15292.1|EUPHSP70B 5941 g4167 i0 82.353 18.8233532934132 238 37 71 5 29 264 317 83 Euplotes eurystomus macronuclear heat shock protein (hsp1a) gene, complete cds and promoters blastn 6287 202 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes eurystomus

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