RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA263496 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
26630883 26630883 PRJNA263496_P_NODE_22421_length_165_cov_0.879310_g22168_i0 PRJNA263496 22421 165 0.87931 1.4508615 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 92.8 2.92e-20   NR CCI41832.1 65357 g22168 i0 77.8 1.94545454545455 54 12 98.2 0 163 2 183 236 CCI41832.1 unnamed protein product [Albugo candida] diamond 321 92.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
28653099 28653099 PRJNA263496_P_NODE_25607_length_161_cov_0.910714_g25354_i0 PRJNA263496 25607 161 0.910714 1.46624954 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 95.9 2.32e-21   NR KAJ0409191.1 114742 g25354 i0 84.9 1.97515527950311 53 8 98.8 0 2 160 965 1017 KAJ0409191.1 hypothetical protein ATCC90586_010272 [Pythium insidiosum] diamond 318 95.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
28779222 28779222 PRJNA263496_P_NODE_23167_length_164_cov_0.886957_g22914_i0 PRJNA263496 23167 164 0.886957 1.45460948 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 57 1.17e-7   NR TYZ57306.1 1485010 g22914 i0 64.1 1.42682926829268 39 14 71.3 0 162 46 236 274 TYZ57306.1 hypothetical protein PybrP1_008020 [[Pythium] brassicae (nom. inval.)] diamond 234 57 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
29252707 29252707 PRJNA263496_P_NODE_22089_length_166_cov_0.871795_g21836_i0 PRJNA263496 22089 166 0.871795 1.4471797 Albugo laibachii Nc14 890382 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.26e-20   NR CCA15626.1 890382 g21836 i0 81.1 0.957831325301205 53 10 95.8 0 6 164 375 427 CCA15626.1 Dlactate dehydrogenase putative [Albugo laibachii Nc14] diamond 159 93.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
30502535 30502535 PRJNA263496_P_NODE_24033_length_163_cov_0.894737_g23780_i0 PRJNA263496 24033 163 0.894737 1.45842131 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.46e-12   NR POM75922.1 4796 g23780 i0 55.6 6.95705521472393 54 24 99.4 0 162 1 357 410 POM75922.1 Hypothetical protein PHPALM_6909 [Phytophthora palmivora] diamond 1134 71.6 0.990223463687151 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora

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