RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA547066 · 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
8772509 8772509 PRJNA547066_P_NODE_5007_length_173_cov_1.014493_g4913_i0 PRJNA547066 5007 173 1.014493 1.75507289 root 1 Root_unresolved Root_unresolved 292 7.87e-75   NTclustered gi|10782|emb|X54004.1| 5908 g4913 i0 97.11 10.8092485549133 173 5 100 0 1 173 2394 2566 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 1870 292 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
13873408 13873408 PRJNA547066_P_NODE_3851_length_211_cov_3.659091_g3757_i0 PRJNA547066 3851 211 3.659091 7.72068201 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 385 1.61e-102   NTclustered gi|300078456|gb|GU187050.1| 858370 g3757 i0 99.526 99.4075829383886 211 1 100 0 1 211 1387 1597 Vorticella sp. SP-2009-3 18S ribosomal RNA gene, partial sequence blastn 20975 385 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. SP-2009-3
17697441 17697441 PRJNA547066_P_NODE_5794_length_156_cov_1.256198_g5700_i0 PRJNA547066 5794 156 1.256198 1.95966888 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 239 9.19e-59   NTclustered gi|1837628855|gb|MN158348.1| 5909 g5700 i0 94.268 90.1923076923077 157 8 100 1 1 156 2966 2810 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 14070 239 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
22188388 22188388 PRJNA547066_P_NODE_1578_length_390_cov_5.033803_g1485_i0 PRJNA547066 1578 390 5.033803 19.6318317 Vorticella sp. 1 2979179 SAR_Eukaryotes SAR_Eukaryotes 665 0   NTclustered gi|2304601489|gb|OP458310.1| 2979179 g1485 i0 97.922 96.7666666666667 385 7 98 1 7 390 1 385 Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 37739 665 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 1

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