RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA781427" 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

  • PRJNA781427 · 3 ✖

analysis 1

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
4588332 4588332 PRJNA781427_P_NODE_18264_length_575_cov_7.430279_g17407_i0 PRJNA781427 18264 575 7.430279 42.72410425 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 1062 0   NTclustered gi|111035915|emb|AJ781092.1| 35100 g17407 i0 100 87.4313043478261 575 0 100 0 1 575 588 14 Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 blastn 50273 1062 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
15240332 15240332 PRJNA781427_P_NODE_61352_length_283_cov_3.485714_g60468_i0 PRJNA781427 61352 283 3.485714 9.86457062 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 523 4.5999999999999983e-144   NTclustered gi|2672382733|gb|PP316658.1| 5887 g60468 i0 100 100.250883392226 283 0 100 0 1 283 94 376 Paramecium sp. isolate OBS22 small subunit ribosomal RNA gene, partial sequence blastn 28371 523 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sp.
17339489 17339489 PRJNA781427_P_NODE_65994_length_271_cov_3.080808_g65110_i0 PRJNA781427 65994 271 3.080808 8.34898968 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 219 2.32e-52   NTclustered gi|1004125725|gb|KU761582.1| 153251 g65110 i0 81.481 53.2767527675277 270 46 99 4 4 271 7680 7413 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 14438 219 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans

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