RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA827593" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA827593 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
11024987 11024987 PRJNA827593_P_NODE_41269_length_315_cov_2.363636_g40970_i0 PRJNA827593 41269 315 2.363636 7.4454534 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 176 2.32e-52   NR DAZ94346.1 4803 g40970 i0 73.3 8.99047619047619 105 28 100 0 1 315 166 270 DAZ94346.1 TPA: hypothetical protein N0F65_000910 [Lagenidium giganteum] diamond 2832 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
22497804 22497804 PRJNA827593_P_NODE_30158_length_377_cov_1.444079_g29859_i0 PRJNA827593 30158 377 1.444079 5.44417783 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 149 6.65e-39   NR OQS03554.1 74557 g29859 i0 68.6 5.0132625994695 105 33 83.6 0 317 3 153 257 OQS03554.1 threonyl-tRNA synthetase [Thraustotheca clavata] diamond 1890 149 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
26737579 26737579 PRJNA827593_P_NODE_63261_length_248_cov_0.880000_g62962_i0 PRJNA827593 63261 248 0.88 2.1824 Phytophthora cactorum 29920 SAR_Eukaryotes SAR_Eukaryotes 72 2e-12   NR KAF1791084.1 29920 g62962 i0 58.9 5.86693548387097 56 23 67.7 0 1 168 1259 1314 KAF1791084.1 P-loop containing nucleoside triphosphate hydrolase [Phytophthora cactorum] diamond 1455 72 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
26778411 26778411 PRJNA827593_P_NODE_27361_length_398_cov_2.169231_g27062_i0 PRJNA827593 27361 398 2.169231 8.63353938 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 132 5.01e-33   NR KAH9112383.1 100861 g27062 i0 50.4 6.60301507537688 125 62 94.2 0 377 3 256 380 KAH9112383.1 hypothetical protein AeMF1_013274 [Aphanomyces euteiches] diamond 2628 132 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
27189438 27189438 PRJNA827593_P_NODE_15882_length_542_cov_1.859275_g15585_i0 PRJNA827593 15882 542 1.859275 10.0772705 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 52 6.59e-5   NR KAI9984178.1 4787 g15585 i0 46.7 1.99261992619926 60 31 32.7 1 12 188 77 136 KAI9984178.1 hypothetical protein PInf_005471 [Phytophthora infestans] diamond 1080 52 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
27284402 27284402 PRJNA827593_P_NODE_64343_length_246_cov_1.335260_g64044_i0 PRJNA827593 64343 246 1.33526 3.2847396 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.8 9.01e-7   NR CCI39630.1 65357 g64044 i0 39.5 3.91463414634146 81 21 98.8 2 3 245 250 302 CCI39630.1 unnamed protein product [Albugo candida] diamond 963 55.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
27884374 27884374 PRJNA827593_P_NODE_67025_length_242_cov_1.609467_g66726_i0 PRJNA827593 67025 242 1.609467 3.89491014 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.13e-8   NR KAG1699585.1 4784 g66726 i0 32.4 7.33884297520661 74 50 91.7 0 224 3 202 275 KAG1699585.1 hypothetical protein DVH05_012995 [Phytophthora capsici] diamond 1776 61.6 0.993506493506494 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
27979085 27979085 PRJNA827593_P_NODE_24865_length_421_cov_1.436782_g24566_i0 PRJNA827593 24865 421 1.436782 6.04885222 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 210 5.78e-60   NR KAG1691060.1 4784 g24566 i0 65 17.978622327791 140 49 99.8 0 2 421 2175 2314 KAG1691060.1 hypothetical protein DVH05_027341 [Phytophthora capsici] diamond 7569 212 0.990566037735849 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
28137168 28137168 PRJNA827593_P_NODE_51745_length_277_cov_1.509804_g51446_i0 PRJNA827593 51745 277 1.509804 4.18215708 root 1 Root_unresolved Root_unresolved 94 5.600000000000001e-22   NR TMW61450.1 41045 g51446 i0 74.6 2.3826714801444 59 15 63.9 0 101 277 4 62 TMW61450.1 hypothetical protein Poli38472_012641 [Pythium oligandrum] diamond 660 94 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
29115907 29115907 PRJNA827593_P_NODE_64948_length_245_cov_1.540698_g64649_i0 PRJNA827593 64948 245 1.540698 3.7747101 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 78.6 2.5e-15   NR KAL0586079.1 65357 g64649 i0 53.9 5.62040816326531 76 33 90.6 1 237 16 118 193 KAL0586079.1 hypothetical protein ABG067_004171 [Albugo candida] diamond 1377 79 0.994936708860759 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
29391486 29391486 PRJNA827593_P_NODE_52169_length_276_cov_1.137931_g51870_i0 PRJNA827593 52169 276 1.137931 3.14068956 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 49.3 2.74e-4   NR OWZ15590.1 4795 g51870 i0 44.1 2.03260869565217 59 32 64.1 1 186 10 134 191 OWZ15590.1 hypothetical protein PHMEG_00010740 [Phytophthora megakarya] diamond 561 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
31191618 31191618 PRJNA827593_P_NODE_37215_length_334_cov_2.065134_g36916_i0 PRJNA827593 37215 334 2.065134 6.89754756 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.11e-4   NR XP_067821410.1 4779 g36916 i0 48.6 1.31137724550898 37 19 33.2 0 137 247 103 139 XP_067821410.1 hypothetical protein CCR75_000767 [Bremia lactucae] diamond 438 50.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
31350176 31350176 PRJNA827593_P_NODE_36076_length_340_cov_2.127341_g35777_i0 PRJNA827593 36076 340 2.127341 7.2329594 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.75e-5   NR OQR83762.1 1202772 g35777 i0 53.5 0.379411764705882 43 20 37.9 0 186 314 457 499 OQR83762.1 hypothetical protein ACHHYP_14312 [Achlya hypogyna] diamond 129 53.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
31769835 31769835 PRJNA827593_P_NODE_51477_length_278_cov_1.502439_g51178_i0 PRJNA827593 51477 278 1.502439 4.17678042 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 75.1 2.45e-13   NR KAG2942981.1 29920 g51178 i0 41.1 7.12230215827338 73 42 77.7 1 276 61 1306 1378 KAG2942981.1 Fanconi anemia group M protein [Phytophthora cactorum] diamond 1980 75.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum

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