RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA986547 · 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
6077496 6077496 PRJNA986547_P_NODE_8085_length_253_cov_6.050000_g8003_i0 PRJNA986547 8085 253 6.05 15.3065 Opisthonecta sp. FG-2015 1607889 SAR_Eukaryotes SAR_Eukaryotes 451 1.94e-122   NTclustered gi|759083562|gb|KM222179.1| 1607889 g8003 i0 99.2 90.7430830039526 250 2 99 0 1 250 183 432 Opisthonecta sp. FG-2015 voucher SZ2011052301 large subunit ribosomal RNA gene, partial sequence blastn 22958 451 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Opisthonectidae Opisthonecta Opisthonecta sp. FG-2015
9902248 9902248 PRJNA986547_P_NODE_10888_length_244_cov_1.783626_g10806_i0 PRJNA986547 10888 244 1.783626 4.35204744 Rimostrombidium veniliae 702563 SAR_Eukaryotes SAR_Eukaryotes 313 9.139999999999999e-81   NTclustered gi|759083337|gb|KM221993.1| 702563 g10806 i0 90.041 99.2868852459016 241 24 99 0 1 241 321 561 Rimostrombidium veniliae voucher LWW2007042901 alpha-tubulin gene, partial cds blastn 24226 313 1 Eukaryota Sar   Ciliophora Spirotrichea Choreotrichida Strobilidiidae Rimostrombidium Rimostrombidium veniliae
23926596 23926596 PRJNA986547_P_NODE_10259_length_246_cov_1.260116_g10177_i0 PRJNA986547 10259 246 1.260116 3.09988536 Leptoamphisiella vermis 692523 SAR_Eukaryotes SAR_Eukaryotes 303 5.56e-78   NTclustered gi|399146156|gb|JQ736707.1| 692523 g10177 i0 88.98 102.056910569106 245 27 99 0 2 246 493 249 Leptoamphisiella vermis isolate 061224 alpha-tubulin gene, partial cds; macronuclear blastn 25106 303 1 Eukaryota Sar   Ciliophora Spirotrichea Pseudoamphisiellida   Leptoamphisiella Leptoamphisiella vermis

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