RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1145997" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1145997 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
18141017 18141017 PRJNA1145997_P_NODE_25895_length_490_cov_4.796163_g23279_i0 PRJNA1145997 25895 490 4.796163 23.5011987 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 142 7.34e-39   NR KAF4142888.1 4787 g23279 i0 92.4 3.64285714285714 66 5 40.4 0 11 208 166 231 KAF4142888.1 Rieske [2Fe-2S] domain, partial [Phytophthora infestans] diamond 1785 143 0.993006993006993 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
27007135 27007135 PRJNA1145997_P_NODE_24722_length_528_cov_4.540659_g22107_i0 PRJNA1145997 24722 528 4.540659 23.97467952 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 83.6 2.11e-16   NR KAJ8525733.1 4785 g22107 i0 29.9 0.875 154 99 87.5 2 27 488 29 173 KAJ8525733.1 hypothetical protein ON010_g15381 [Phytophthora cinnamomi] diamond 462 83.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
29975793 29975793 PRJNA1145997_P_NODE_49691_length_238_cov_4.272727_g47072_i0 PRJNA1145997 49691 238 4.272727 10.16909026 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.22e-4   NR XP_067795723.1 4785 g47072 i0 65.6 1.21008403361345 32 11 40.3 0 236 141 25 56 XP_067795723.1 putative 26S proteasome non-ATPase regulatory subunit [Phytophthora cinnamomi] diamond 288 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
30153980 30153980 PRJNA1145997_P_NODE_22172_length_617_cov_6.452206_g19571_i0 PRJNA1145997 22172 617 6.452206 39.81011102 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 2.53e-26   NR OQS05774.1 74557 g19571 i0 43.8 3.51539708265802 112 43 54.5 3 490 155 8 99 OQS05774.1 RING-box protein 1 [Thraustotheca clavata] diamond 2169 108 0.990740740740741 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
30375854 30375854 PRJNA1145997_P_NODE_25132_length_515_cov_6.436652_g22516_i0 PRJNA1145997 25132 515 6.436652 33.1487578 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 138 9.77e-36   NR POM57551.1 4796 g22516 i0 58.4 2.60970873786408 113 47 65.8 0 437 99 1 113 POM57551.1 Serine protease family S28, partial [Phytophthora palmivora] diamond 1344 138 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
30596432 30596432 PRJNA1145997_P_NODE_23433_length_573_cov_3.592000_g20825_i0 PRJNA1145997 23433 573 3.592 20.58216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 176 9.84e-53   NR KAJ0392104.1 114742 g20825 i0 50 11.3612565445026 182 82 95.3 1 2 547 4 176 KAJ0392104.1 hypothetical protein P43SY_009801 [Pythium insidiosum] diamond 6510 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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