RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1226487 · 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
1609709 1609709 PRJNA1226487_P_NODE_73422_length_244_cov_2.385965_g73320_i0 PRJNA1226487 73422 244 2.385965 5.8217546 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 337 5.429999999999998e-88   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g73320 i0 92.083 6.00409836065574 240 17 98 2 1 239 308 70 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1465 337 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2885849 2885849 PRJNA1226487_P_NODE_38383_length_291_cov_11.403670_g38281_i0 PRJNA1226487 38383 291 11.40367 33.1846797 Wilbertia typica 655661 SAR_Eukaryotes SAR_Eukaryotes 95.3 4.42e-15   NTclustered gi|1418575077|gb|MH577585.1| 655661 g38281 i0 90.411 19.9553264604811 73 5 25 2 70 141 112 183 Wilbertia typica isolate PXM100628 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 5807 95.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Eurystomatellidae Wilbertia Wilbertia typica
8699833 8699833 PRJNA1226487_P_NODE_42027_length_285_cov_1.452830_g41925_i0 PRJNA1226487 42027 285 1.45283 4.1405655 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.026   NTclustered gi|2558939|gb|AF025312.1|AF025312 5911 g41925 i0 96.667 0.645614035087719 30 1 11 0 239 268 2810 2839 Tetrahymena thermophila cytoplasmic dynein heavy chain 1a gene, partial cds blastn 184 52.8 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);;