RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA683902" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 11 ✖

tax_clade 1

bioproject 1

  • PRJNA683902 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
5003849 5003849 PRJNA683902_S_NODE_26524_length_194_cov_2.560510_g26080_i0 PRJNA683902 26524 194 2.56051 4.9673894 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 101 7.85e-24   NR DAZ96004.1 4803 g26080 i0 81 12.5103092783505 63 12 97.4 0 193 5 107 169 DAZ96004.1 TPA: hypothetical protein N0F65_009305 [Lagenidium giganteum] diamond 2427 102 0.990196078431373 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Lagenidium Lagenidium giganteum
11379099 11379099 PRJNA683902_S_NODE_31169_length_174_cov_2.160584_g30725_i0 PRJNA683902 31169 174 2.160584 3.75941616 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 95.5 3.94e-21   NR KAL4159755.1 164328 g30725 i0 86.8 18.5 53 7 91.4 0 159 1 1234 1286 KAL4159755.1 hypothetical protein PRNP1_000328 [Phytophthora ramorum] diamond 3219 95.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
26892556 26892556 PRJNA683902_S_NODE_19441_length_244_cov_1.869565_g18997_i0 PRJNA683902 19441 244 1.869565 4.5617386 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 93.2 6.6500000000000005e-22   NR KAJ0410394.1 114742 g18997 i0 62.7 2.76639344262295 75 27 92.2 1 242 18 82 155 KAJ0410394.1 hypothetical protein P43SY_002726 [Pythium insidiosum] diamond 675 93.2 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
27914913 27914913 PRJNA683902_S_NODE_30065_length_178_cov_2.127660_g29621_i0 PRJNA683902 30065 178 2.12766 3.7872348 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.9900000000000003e-21   NR KAF0718998.1 120398 g29621 i0 78.2 25.5168539325843 55 12 92.7 0 167 3 32 86 KAF0718998.1 hypothetical protein As57867_001340 [Aphanomyces stellatus] diamond 4542 92 0.996739130434783 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
28546780 28546780 PRJNA683902_S_NODE_29567_length_180_cov_1.727273_g29123_i0 PRJNA683902 29567 180 1.727273 3.1090914 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 54.7 3.78e-8   NR RHY01079.1 112090 g29123 i0 96 2.5 25 1 41.7 0 1 75 38 62 RHY01079.1 hypothetical protein DYB25_010126, partial [Aphanomyces astaci] diamond 450 54.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28704534 28704534 PRJNA683902_S_NODE_27427_length_190_cov_1.111111_g26983_i0 PRJNA683902 27427 190 1.111111 2.1111109 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 87 7.53e-20   NR RHY74090.1 112090 g26983 i0 69.8 3.97894736842105 63 18 97.9 1 188 3 15 77 RHY74090.1 hypothetical protein DYB30_004665 [Aphanomyces astaci] diamond 756 87 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
30156732 30156732 PRJNA683902_S_NODE_20272_length_236_cov_1.452261_g19828_i0 PRJNA683902 20272 236 1.452261 3.42733596 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 156 7.339999999999999e-43   NR RHZ16721.1 112090 g19828 i0 89.7 7.93220338983051 78 8 99.2 0 236 3 149 226 RHZ16721.1 hypothetical protein DYB31_004085 [Aphanomyces astaci] diamond 1872 156 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
30378538 30378538 PRJNA683902_S_NODE_19572_length_243_cov_1.422330_g19128_i0 PRJNA683902 19572 243 1.42233 3.4562619 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 138 2.95e-39   NR KAL0583279.1 65357 g19128 i0 76.5 15.8395061728395 81 19 100 0 1 243 1 81 KAL0583279.1 hypothetical protein ABG067_006780 [Albugo candida] diamond 3849 139 0.992805755395683 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
30555923 30555923 PRJNA683902_S_NODE_29493_length_180_cov_2.776224_g29049_i0 PRJNA683902 29493 180 2.776224 4.9972032 Albugo laibachii Nc14 890382 SAR_Eukaryotes SAR_Eukaryotes 103 2.67e-25   NR CCA19147.1 890382 g29049 i0 76.7 3 60 14 100 0 1 180 91 150 CCA19147.1 40S ribosomal protein S4 putative [Albugo laibachii Nc14] diamond 540 103 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
32338667 32338667 PRJNA683902_S_NODE_27019_length_192_cov_1.316129_g26575_i0 PRJNA683902 27019 192 1.316129 2.52696768 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 114 4.28e-30   NR TMW65496.1 41045 g26575 i0 76.2 14.59375 63 15 98.4 0 190 2 128 190 TMW65496.1 hypothetical protein Poli38472_008138 [Pythium oligandrum] diamond 2802 115 0.991304347826087 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
32863240 32863240 PRJNA683902_S_NODE_20240_length_236_cov_2.648241_g19796_i0 PRJNA683902 20240 236 2.648241 6.24984876 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 138 9.67e-39   NR TYZ63780.1 1485010 g19796 i0 80.5 2.94915254237288 77 15 97.9 0 4 234 65 141 TYZ63780.1 hypothetical protein PybrP1_001840 [[Pythium] brassicae (nom. inval.)] diamond 696 138 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)

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