RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA1146029", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 21 ✖

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1146029 · 21 ✖

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
5393479 5393479 PRJNA1146029_P_NODE_7605_length_326_cov_0.928854_g7326_i0 PRJNA1146029 7605 326 0.928854 3.02806404 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 90.1 1.78e-20   NR KAI9998566.1 4787 g7326 i0 63.5 5.19938650306749 63 23 58 0 189 1 44 106 KAI9998566.1 hypothetical protein PInf_003115 [Phytophthora infestans] diamond 1695 90.9 0.991199119911991 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
6668095 6668095 PRJNA1146029_P_NODE_446_length_1306_cov_2.625304_g309_i0 PRJNA1146029 446 1306 2.625304 34.28647024 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 568 3.1099999999999995e-200   NR TMW60420.1 41045 g309 i0 71.3 6.14701378254211 390 109 89.6 2 1301 132 1 387 TMW60420.1 hypothetical protein Poli38472_000462 [Pythium oligandrum] diamond 8028 572 0.993006993006993 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
9218025 9218025 PRJNA1146029_P_NODE_13968_length_265_cov_1.203125_g13687_i0 PRJNA1146029 13968 265 1.203125 3.18828125 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 160 4.54e-44   NR TMW56302.1 41045 g13687 i0 78.4 30.8830188679245 88 19 99.6 0 264 1 339 426 TMW56302.1 hypothetical protein Poli38472_008950 [Pythium oligandrum] diamond 8184 161 0.993788819875776 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
9961738 9961738 PRJNA1146029_P_NODE_12728_length_273_cov_1.540000_g12447_i0 PRJNA1146029 12728 273 1.54 4.2042 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 130 1.13e-25   NTclustered gi|1923460176|gb|MW187717.1| 100861 g12447 i0 89.423 39.6739926739927 104 9 38 2 1 103 277 175 Aphanomyces euteiches isolate CCRJB_40 large subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 10831 130 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
12512345 12512345 PRJNA1146029_P_NODE_5870_length_362_cov_1.685121_g5592_i0 PRJNA1146029 5870 362 1.685121 6.10013802 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 83.2 2.98e-16   NR RQM26635.1 112090 g5592 i0 69 2.88397790055249 58 18 48.1 0 176 3 213 270 RQM26635.1 hypothetical protein B5M09_003301 [Aphanomyces astaci] diamond 1044 84 0.990476190476191 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
17611306 17611306 PRJNA1146029_P_NODE_19734_length_245_cov_0.895349_g19453_i0 PRJNA1146029 19734 245 0.895349 2.19360505 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 159 1.27e-34   NTclustered gi|2795050879|ref|XM_067944282.1| 4785 g19453 i0 79.911 10.3877551020408 224 39 90 3 25 245 693 473 Phytophthora cinnamomi Mitochondrial Carrier (MC) Family (IUM83_19238), partial mRNA blastn 2545 159 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
17611307 17611307 PRJNA1146029_P_NODE_19774_length_245_cov_0.895349_g19493_i0 PRJNA1146029 19774 245 0.895349 2.19360505 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 154 5.89e-33   NTclustered gi|166301|gb|J05597.1|ACKBTUB 4767 g19493 i0 88.462 48.8857142857143 130 11 52 2 119 245 1542 1414 A.klebsiana beta-tubulin gene, complete cds blastn 11977 154 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya klebsiana
18141859 18141859 PRJNA1146029_P_NODE_20655_length_243_cov_1.576471_g20374_i0 PRJNA1146029 20655 243 1.576471 3.83082453 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 124 3.6899999999999996e-34   NR KAF0743747.1 100861 g20374 i0 73.1 5.79012345679012 78 21 96.3 0 235 2 7 84 KAF0743747.1 hypothetical protein Ae201684_001401 [Aphanomyces euteiches] diamond 1407 124 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
26710957 26710957 PRJNA1146029_P_NODE_20761_length_243_cov_0.905882_g20480_i0 PRJNA1146029 20761 243 0.905882 2.20129326 Pythiaceae 4782 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.68e-17   NR DAZ92838.1 4803 g20480 i0 62 2.65432098765432 79 30 97.5 0 239 3 3 81 DAZ92838.1 TPA: hypothetical protein N0F65_000518 [Lagenidium giganteum] diamond 645 82.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
27122362 27122362 PRJNA1146029_P_NODE_20522_length_244_cov_0.900585_g20241_i0 PRJNA1146029 20522 244 0.900585 2.1974274 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.28e-4   NR TMW61822.1 41045 g20241 i0 41 5.69262295081967 61 34 75 1 199 17 136 194 TMW61822.1 hypothetical protein Poli38472_010885 [Pythium oligandrum] diamond 1389 50.1 0.992015968063872 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
27196826 27196826 PRJNA1146029_P_NODE_19162_length_246_cov_0.890173_g18881_i0 PRJNA1146029 19162 246 0.890173 2.18982558 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 92.8 9.19e-20   NR GLD92727.1 114742 g18881 i0 50.6 2.89024390243902 79 39 96.3 0 242 6 208 286 GLD92727.1 hypothetical protein PINS_up001306 [Pythium insidiosum] diamond 711 92.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
27723284 27723284 PRJNA1146029_P_NODE_11024_length_284_cov_1.459716_g10743_i0 PRJNA1146029 11024 284 1.459716 4.14559344 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 67 1.51e-10   NR ETM36176.1 4792 g10743 i0 41.7 7.51056338028169 103 46 97.2 5 279 4 50 149 ETM36176.1 hypothetical protein L914_17067 [Phytophthora nicotianae] diamond 2133 67 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
28081203 28081203 PRJNA1146029_P_NODE_5005_length_387_cov_1.961783_g4727_i0 PRJNA1146029 5005 387 1.961783 7.59210021 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 49.7 7.29e-4   NR GMF17650.1 2077276 g4727 i0 30.3 0.922480620155039 119 63 91.5 4 356 3 4899 4998 GMF17650.1 unnamed protein product [Phytophthora lilii] diamond 357 49.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii
28480677 28480677 PRJNA1146029_P_NODE_12206_length_277_cov_1.132353_g11925_i0 PRJNA1146029 12206 277 1.132353 3.13661781 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 145 1.68e-38   NR KAH9135011.1 100861 g11925 i0 72.2 9.74729241877256 90 25 97.5 0 3 272 130 219 KAH9135011.1 hypothetical protein LEN26_006637 [Aphanomyces euteiches] diamond 2700 146 0.993150684931507 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
28512215 28512215 PRJNA1146029_P_NODE_14227_length_263_cov_1.421053_g13946_i0 PRJNA1146029 14227 263 1.421053 3.73736939 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 163 7.88e-49   NR KAL0592341.1 65357 g13946 i0 90.7 67.0836501901141 86 8 98.1 0 262 5 47 132 KAL0592341.1 hypothetical protein ABG067_000449 [Albugo candida] diamond 17643 164 0.99390243902439 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
28712845 28712845 PRJNA1146029_P_NODE_2487_length_543_cov_2.178723_g2212_i0 PRJNA1146029 2487 543 2.178723 11.83046589 Lagenidium giganteum 4803 SAR_Eukaryotes SAR_Eukaryotes 119 2.24e-27   NR DAZ98414.1 4803 g2212 i0 70.7 0.828729281767956 75 22 41.4 0 542 318 607 681 DAZ98414.1 TPA: hypothetical protein N0F65_000128 [Lagenidium giganteum] diamond 450 119 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
28902021 28902021 PRJNA1146029_P_NODE_5908_length_361_cov_1.732639_g5630_i0 PRJNA1146029 5908 361 1.732639 6.25482679 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 97.4 6.45e-22   NR KAJ8578052.1 4785 g5630 i0 57.6 2.39335180055402 99 31 76.5 4 359 84 163 257 KAJ8578052.1 hypothetical protein ON010_g1153 [Phytophthora cinnamomi] diamond 864 97.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
29060173 29060173 PRJNA1146029_P_NODE_6108_length_356_cov_1.890459_g5830_i0 PRJNA1146029 6108 356 1.890459 6.73003404 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.58e-4   NR RHY74090.1 112090 g5830 i0 54.2 0.404494382022472 48 17 36.2 1 4 132 108 155 RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] diamond 144 49.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
29901635 29901635 PRJNA1146029_P_NODE_22151_length_241_cov_0.916667_g21870_i0 PRJNA1146029 22151 241 0.916667 2.20916747 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 104 2.22e-24   NR DBA03688.1 4803 g21870 i0 56.4 12.8589211618257 78 34 97.1 0 234 1 64 141 DBA03688.1 TPA: hypothetical protein N0F65_004105 [Lagenidium giganteum] diamond 3099 104 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
30133433 30133433 PRJNA1146029_P_NODE_4492_length_407_cov_1.383234_g4214_i0 PRJNA1146029 4492 407 1.383234 5.62976238 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0452   NR KAF0746417.1 112090 g4214 i0 48.9 0.331695331695332 45 22 32.4 1 4 135 198 242 KAF0746417.1 hypothetical protein AaE_008135, partial [Aphanomyces astaci] diamond 135 44.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31355155 31355155 PRJNA1146029_P_NODE_14376_length_262_cov_1.301587_g14095_i0 PRJNA1146029 14376 262 1.301587 3.41015794 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 101 1.11e-22   NR XP_024580211.1 4781 g14095 i0 57.6 16.8091603053435 92 34 99.6 2 1 261 167 258 XP_024580211.1 dead box rna helicase [Plasmopara halstedii] diamond 4404 102 0.990196078431373 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii

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