RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJEB673" 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

  • PRJEB673 · 11 ✖

analysis 1

  • blastn · 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
134878 134878 PRJEB673_P_NODE_10961_length_166_cov_2.511450_g10612_i0 PRJEB673 10961 166 2.51145 4.169007 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 265 1.64e-66   NTclustered gi|256009645|gb|GQ374534.1| 112090 g10612 i0 95.732 59.433734939759 164 7 99 0 3 166 264 427 Aphanomyces astaci strain Gb04 28S ribosomal RNA gene, partial sequence blastn 9866 265 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
134942 134942 PRJEB673_P_NODE_5721_length_369_cov_3.844311_g5372_i0 PRJEB673 5721 369 3.844311 14.18550759 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 259 1.92e-64   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g5372 i0 79.89 91.6178861788618 363 65 96 4 1 356 429 68 Aphanomyces astaci polyubiquitin mRNA blastn 33807 259 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
5237449 5237449 PRJEB673_P_NODE_3365_length_544_cov_2.504912_g3047_i0 PRJEB673 3365 544 2.504912 13.62672128 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 243 2.96e-59   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g3047 i0 79.05 14.5680147058824 358 71 65 4 84 439 127 482 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 7925 243 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
6098472 6098472 PRJEB673_P_NODE_12645_length_152_cov_1.478632_g12296_i0 PRJEB673 12645 152 1.478632 2.24752064 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 198 1.51e-46   NTclustered gi|698791719|ref|XM_009830590.1| 112090 g12296 i0 90.132 4.82236842105263 152 15 100 0 1 152 865 714 Aphanomyces astaci hypothetical protein partial mRNA blastn 733 198 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
6512971 6512971 PRJEB673_P_NODE_10646_length_170_cov_3.851852_g10297_i0 PRJEB673 10646 170 3.851852 6.5481484 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 315 1.64e-81   NTclustered gi|1578815423|gb|MK546600.1| 1982524 g10297 i0 100 100.041176470588 170 0 100 0 1 170 834 665 Aphanomyces sp. voucher CPZ14 large subunit ribosomal RNA gene, partial sequence blastn 17007 315 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
6513073 6513073 PRJEB673_P_NODE_9706_length_189_cov_1.818182_g9357_i0 PRJEB673 9706 189 1.818182 3.43636398 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 254 4.14e-63   NTclustered gi|166035705|emb|CU351918.1| 100861 g9357 i0 90.957 15.9153439153439 188 17 99 0 1 188 538 725 Aphanomyces euteiches cDNA blastn 3008 254 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9923347 9923347 PRJEB673_P_NODE_11908_length_157_cov_1.967213_g11559_i0 PRJEB673 11908 157 1.967213 3.08852441 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 196 5.66e-46   NTclustered gi|301107178|ref|XM_002902626.1| 403677 g11559 i0 89.308 3.01273885350318 159 13 100 2 1 157 872 716 Phytophthora infestans T30-4 40S ribosomal protein S2 (PITG_10146), mRNA blastn 473 196 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
10337967 10337967 PRJEB673_P_NODE_4289_length_464_cov_4.897436_g3946_i0 PRJEB673 4289 464 4.897436 22.72410304 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 58.4 0.001   NTclustered gi|695382888|ref|XM_009519246.1| 67593 g3946 i0 92.5 0.271551724137931 40 3 9 0 230 269 398 359 Phytophthora sojae hypothetical protein mRNA blastn 126 58.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
10337976 10337976 PRJEB673_P_NODE_5289_length_389_cov_1.748588_g4940_i0 PRJEB673 5289 389 1.748588 6.80200732 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 148 4.61e-31   NTclustered gi|813142527|ref|XM_012343931.1| 695850 g4940 i0 79.904 10.866323907455 209 36 53 6 15 220 997 1202 Saprolegnia parasitica CBS 223.65 60S ribosomal protein L3 mRNA blastn 4227 148 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
20535774 20535774 PRJEB673_P_NODE_12377_length_154_cov_1.344538_g12028_i0 PRJEB673 12377 154 1.344538 2.07058852 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 135 1.2200000000000002e-27   NTclustered gi|2794921676|ref|XM_067881069.1| 164328 g12028 i0 84.559 2.97402597402597 136 21 88 0 15 150 353 218 Phytophthora ramorum 40S ribosomal protein S8 (KRP23_10601), partial mRNA blastn 458 135 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
24360729 24360729 PRJEB673_P_NODE_5720_length_369_cov_4.284431_g5371_i0 PRJEB673 5720 369 4.284431 15.80955039 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 532 1.03e-146   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g5371 i0 92.722 76.6314363143631 371 23 100 4 1 369 1319 1687 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 28277 532 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica

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