RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "blastn", bioproject = "PRJNA683902" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA683902 · 12 ✖

analysis 1

  • blastn · 12 ✖

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
665500 665500 PRJNA683902_S_NODE_8961_length_520_cov_10.873706_g8536_i0 PRJNA683902 8961 520 10.873706 56.5432712 Pythium monospermum 92964 SAR_Eukaryotes SAR_Eukaryotes 815 0   NTclustered gi|33520250|gb|AY273995.1| 92964 g8536 i0 95.85 96.6076923076923 506 18 97 3 1 504 19 523 Pythium monospermum large subunit ribosomal RNA gene, partial sequence blastn 50236 815 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium monospermum
5768860 5768860 PRJNA683902_S_NODE_20565_length_233_cov_2.306122_g20121_i0 PRJNA683902 20565 233 2.306122 5.37326426 uncultured Oomycota 179533 SAR_Eukaryotes SAR_Eukaryotes 425 1.07e-114   NTclustered gi|575503194|gb|KF750352.1| 179533 g20121 i0 99.571 99.6781115879828 233 1 100 0 1 233 280 48 Uncultured oomycete clone A2g8796 large subunit ribosomal RNA gene, partial sequence blastn 23225 425 1 Eukaryota Sar   Oomycota         uncultured Oomycota
7553629 7553629 PRJNA683902_S_NODE_39826_length_150_cov_3.522124_g39382_i0 PRJNA683902 39826 150 3.522124 5.283186 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 255 8.680000000000001e-64   NTclustered gi|573007521|gb|HQ643388.2| 126845 g39382 i0 97.351 100.44 151 2 99 2 2 150 1438 1288 Phytopythium megacarpum voucher CBS112351 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 15066 255 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Phytopythium Phytopythium megacarpum
9593932 9593932 PRJNA683902_S_NODE_27708_length_188_cov_3.066225_g27264_i0 PRJNA683902 27708 188 3.066225 5.764503 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 115 2.03e-21   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g27264 i0 83.74 14.7234042553191 123 18 65 2 64 185 127 248 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 2768 115 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
10104047 10104047 PRJNA683902_S_NODE_23588_length_211_cov_2.448276_g23144_i0 PRJNA683902 23588 211 2.448276 5.16586236 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 285 1.68e-72   NTclustered gi|2440150|emb|X75631.1| 4788 g23144 i0 91.08 99.0284360189574 213 16 100 3 1 211 2927 2716 P.megasperma gene for 28S ribosomal RNA blastn 20895 285 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma
10869255 10869255 PRJNA683902_S_NODE_24949_length_203_cov_2.114458_g24505_i0 PRJNA683902 24949 203 2.114458 4.29234974 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 333 5.639999999999999e-87   NTclustered gi|7658194|gb|AF119587.1| 120398 g24505 i0 96.517 90.64039408867 201 7 99 0 3 203 358 558 Aphanomyces stellatus strain AR 51 large subunit ribosomal RNA gene, partial sequence blastn 18400 333 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
12654840 12654840 PRJNA683902_S_NODE_24910_length_203_cov_3.265060_g24466_i0 PRJNA683902 24910 203 3.26506 6.6280718 Pythiales 121069 SAR_Eukaryotes SAR_Eukaryotes 368 1.55e-97   NTclustered gi|531037406|gb|AY598692.2| 172234 g24466 i0 99.505 99.512315270936 202 1 99 0 2 203 4041 3840 Pythium grandisporangium strain CBS 286.79 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 20201 368 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium grandisporangium
18517280 18517280 PRJNA683902_S_NODE_14495_length_316_cov_2.896057_g14051_i0 PRJNA683902 14495 316 2.896057 9.15154012 Pythium grandisporangium 172234 SAR_Eukaryotes SAR_Eukaryotes 555 1.8499999999999999e-153   NTclustered gi|1042782939|gb|KT886041.1| 172234 g14051 i0 98.418 99.9240506329114 316 4 100 1 1 316 951 637 Pythium grandisporangium voucher CCIBt 4073 18S ribosomal RNA gene, partial sequence blastn 31576 555 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium grandisporangium
18517487 18517487 PRJNA683902_S_NODE_36795_length_157_cov_2.800000_g36351_i0 PRJNA683902 36795 157 2.8 4.396 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 154 3.45e-33   NTclustered gi|698801103|ref|XM_009835279.1| 112090 g36351 i0 84.713 99.1528662420382 157 20 99 4 1 155 705 859 Aphanomyces astaci adenosylhomocysteinase 2 mRNA blastn 15567 154 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
19027250 19027250 PRJNA683902_S_NODE_30255_length_177_cov_3.871429_g29811_i0 PRJNA683902 30255 177 3.871429 6.85242933 Pythium 4797 SAR_Eukaryotes SAR_Eukaryotes 281 1.75e-71   NTclustered gi|51235482|gb|AY598628.1| 82932 g29811 i0 95.48 100.011299435028 177 6 99 2 1 175 1809 1633 Pythium arrhenomanes strain CBS 324.62 internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 17702 281 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium arrhenomanes
19792362 19792362 PRJNA683902_S_NODE_36256_length_158_cov_5.619835_g35812_i0 PRJNA683902 36256 158 5.619835 8.8793393 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 191 2.65e-44   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g35812 i0 88.679 38.7658227848101 159 14 99 4 2 158 1540 1696 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 6125 191 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
25402110 25402110 PRJNA683902_S_NODE_32860_length_168_cov_3.015267_g32416_i0 PRJNA683902 32860 168 3.015267 5.06564856 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 132 1.7600000000000002e-26   NTclustered gi|189084851|gb|BT032382.1| 4784 g32416 i0 81.646 16.1190476190476 158 29 94 0 11 168 407 250 Phytophthora capsici clone CBOU49-E03 mRNA sequence blastn 2708 132 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici

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