RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA788929" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA788929 · 17 ✖

analysis 1

  • diamond · 17 ✖

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
8422807 8422807 PRJNA788929_P_NODE_50087_length_198_cov_4.024000_g49426_i0 PRJNA788929 50087 198 4.024 7.96752 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.7 3.850000000000001e-21   NR TMW61843.1 41045 g49426 i0 83.3 2.21212121212121 48 8 72.7 0 24 167 153 200 TMW61843.1 hypothetical protein Poli38472_010906 [Pythium oligandrum] diamond 438 91.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
10973616 10973616 PRJNA788929_P_NODE_4509_length_950_cov_83.014823_g3981_i0 PRJNA788929 4509 950 83.014823 788.6408185 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 297 3.75e-97   NR XP_008871544.1 157072 g3981 i0 65.9 1.48736842105263 217 74 68.5 0 186 836 39 255 XP_008871544.1 40S ribosomal protein S2 [Aphanomyces invadans] diamond 1413 297 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
10973701 10973701 PRJNA788929_P_NODE_5949_length_793_cov_57.219444_g5345_i0 PRJNA788929 5949 793 57.219444 453.75019092 Plasmopara halstedii 4781 SAR_Eukaryotes SAR_Eukaryotes 117 6.200000000000001e-28   NR XP_024584662.1 4781 g5345 i0 48 0.575031525851198 152 62 54.1 4 59 487 10 153 XP_024584662.1 rna binding [Plasmopara halstedii] diamond 456 117 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
12249292 12249292 PRJNA788929_P_NODE_9090_length_603_cov_82.871698_g8439_i0 PRJNA788929 9090 603 82.871698 499.71633894 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 221 3.31e-70   NR KAI9994045.1 4787 g8439 i0 74 11.6716417910448 131 34 65.2 0 536 144 56 186 KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] diamond 7038 223 0.991031390134529 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
14798360 14798360 PRJNA788929_P_NODE_8092_length_651_cov_60.826990_g7446_i0 PRJNA788929 8092 651 60.82699 395.9837049 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 221 6.02e-70   NR KAI9994045.1 4787 g7446 i0 74 10.8110599078341 131 34 60.4 0 584 192 56 186 KAI9994045.1 hypothetical protein PInf_016604 [Phytophthora infestans] diamond 7038 223 0.991031390134529 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
18620572 18620572 PRJNA788929_P_NODE_12395_length_492_cov_1.847255_g11738_i0 PRJNA788929 12395 492 1.847255 9.0884946 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 151 6.489999999999999e-43   NR YP_009167024.1 114742 g11738 i0 82.5 1.18292682926829 97 17 59.1 0 180 470 100 196 YP_009167024.1 ribosomal protein S2 [Pythium insidiosum] diamond 582 151 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
26800480 26800480 PRJNA788929_P_NODE_6081_length_784_cov_26.651195_g5472_i0 PRJNA788929 6081 784 26.651195 208.9453688 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 376 8.439999999999998e-125   NR KAF0692573.1 120398 g5472 i0 71.4 0.895408163265306 234 67 89.5 0 762 61 338 571 KAF0692573.1 hypothetical protein As57867_016328 [Aphanomyces stellatus] diamond 702 376 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
27401481 27401481 PRJNA788929_P_NODE_23863_length_329_cov_12.289062_g23202_i0 PRJNA788929 23863 329 12.289062 40.43101398 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 48.9 6.64e-4   NR KAF0719325.1 120398 g23202 i0 38.7 1.08510638297872 119 48 85.7 7 308 27 383 501 KAF0719325.1 hypothetical protein As57867_001108, partial [Aphanomyces stellatus] diamond 357 48.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
28096007 28096007 PRJNA788929_P_NODE_9585_length_582_cov_52.844794_g8933_i0 PRJNA788929 9585 582 52.844794 307.55670108 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 63.9 3.66e-8   NR OQS05425.1 74557 g8933 i0 33.6 0.597938144329897 116 73 58.2 2 19 357 277 391 OQS05425.1 CDP-alcohol phosphatidyltransferase [Thraustotheca clavata] diamond 348 63.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
29336654 29336654 PRJNA788929_P_NODE_5149_length_876_cov_45.499377_g4571_i0 PRJNA788929 5149 876 45.499377 398.57454252 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 145 2.03e-36   NR KAF0682950.1 120398 g4571 i0 39.8 4.32534246575342 201 120 68.8 1 777 175 14 213 KAF0682950.1 hypothetical protein As57867_024885 [Aphanomyces stellatus] diamond 3789 146 0.993150684931507 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
30758119 30758119 PRJNA788929_P_NODE_6494_length_750_cov_43.782866_g5874_i0 PRJNA788929 6494 750 43.782866 328.371495 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 101 7.27e-22   NR KAG3097867.1 53986 g5874 i0 36.2 4.852 149 92 59.2 3 617 174 100 246 KAG3097867.1 hypothetical protein PI125_g15513 [Phytophthora idaei] diamond 3639 101 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora idaei
31769637 31769637 PRJNA788929_P_NODE_28577_length_296_cov_10.224215_g27916_i0 PRJNA788929 28577 296 10.224215 30.2636764 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 62 7.42e-9   NR KAI9989638.1 4787 g27916 i0 81 1.7027027027027 42 8 42.6 0 269 144 230 271 KAI9989638.1 hypothetical protein PInf_019923 [Phytophthora infestans] diamond 504 62 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
31927831 31927831 PRJNA788929_P_NODE_25117_length_319_cov_21.373984_g24456_i0 PRJNA788929 25117 319 21.373984 68.18300896 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.3 4.54e-4   NR KAK1946366.1 4793 g24456 i0 57.9 1.06269592476489 38 16 35.7 0 302 189 200 237 KAK1946366.1 Ubiquitin carboxyl-terminal hydrolase 3 [Phytophthora citrophthora] diamond 339 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citrophthora
32045260 32045260 PRJNA788929_P_NODE_38538_length_249_cov_11.732955_g37877_i0 PRJNA788929 38538 249 11.732955 29.21505795 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.08e-5   NR OQR81488.1 74557 g37877 i0 56.4 0.469879518072289 39 17 47 0 206 90 78 116 OQR81488.1 hypothetical protein THRCLA_23360, partial [Thraustotheca clavata] diamond 117 50.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
32108458 32108458 PRJNA788929_P_NODE_23178_length_335_cov_21.541985_g22517_i0 PRJNA788929 23178 335 21.541985 72.16564975 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 132 9.12e-38   NR KAH9110449.1 100861 g22517 i0 83.8 0.662686567164179 74 12 66.3 0 285 64 1 74 KAH9110449.1 hypothetical protein AeMF1_014743 [Aphanomyces euteiches] diamond 222 132 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
32149460 32149460 PRJNA788929_P_NODE_7998_length_656_cov_91.222985_g7353_i0 PRJNA788929 7998 656 91.222985 598.4227816 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 0.0216   NR XP_008862755.1 157072 g7353 i0 42.6 1.24390243902439 54 31 24.7 0 333 172 575 628 XP_008862755.1 hypothetical protein H310_01430 [Aphanomyces invadans] diamond 816 48.1 0.993762993762994 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
32866310 32866310 PRJNA788929_P_NODE_22140_length_345_cov_12.779412_g21479_i0 PRJNA788929 22140 345 12.779412 44.0889714 Pythium oligandrum 41045 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.02e-10   NR TMW69339.1 41045 g21479 i0 52.3 2.07826086956522 86 32 67.8 3 24 257 366 450 TMW69339.1 hypothetical protein Poli38472_001495 [Pythium oligandrum] diamond 717 68.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum

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