RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJEB12237" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 14 ✖

tax_clade 1

bioproject 1

  • PRJEB12237 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1294891 1294891 PRJEB12237_P_NODE_1582_length_573_cov_34.122677_g1403_i0 PRJEB12237 1582 573 34.122677 195.52293921 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 243 3.13e-59   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g1403 i0 79.05 13.8307155322862 358 71 62 4 105 460 127 482 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 7925 243 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
7672879 7672879 PRJEB12237_P_NODE_2527_length_442_cov_1.572482_g2331_i0 PRJEB12237 2527 442 1.572482 6.95037044 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 246 1.83e-60   NTclustered gi|2794919717|ref|XM_067895222.1| 164328 g2331 i0 77.162 91.4366515837104 451 85 100 15 1 442 308 749 Phytophthora ramorum Malate dehydrogenase, mitochondrial (KRP23_9643), partial mRNA blastn 40415 246 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
7672927 7672927 PRJEB12237_P_NODE_8967_length_181_cov_1.630137_g8771_i0 PRJEB12237 8967 181 1.630137 2.95054797 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 110 9e-20   NTclustered gi|813218947|ref|XM_012355461.1| 695850 g8771 i0 82.54 3.22651933701657 126 20 69 2 1 125 487 611 Saprolegnia parasitica CBS 223.65 peroxiredoxin mRNA blastn 584 110 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
14048805 14048805 PRJEB12237_P_NODE_3492_length_355_cov_3.487500_g3296_i0 PRJEB12237 3492 355 3.4875 12.380625 Achlya bisexualis 4766 SAR_Eukaryotes SAR_Eukaryotes 287 8.46e-73   NTclustered gi|2289|emb|X59936.1| 4766 g3296 i0 87.5 67.543661971831 248 31 70 0 1 248 248 1 A.bisexualis gene for actin blastn 23978 287 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya bisexualis
16597491 16597491 PRJEB12237_P_NODE_414_length_1092_cov_5.187323_g325_i0 PRJEB12237 414 1092 5.187323 56.64556716 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 643 1.4399999999999996e-179   NTclustered gi|166044823|emb|CU351082.1| 100861 g325 i0 80.641 40.2957875457875 842 153 77 9 45 881 84 920 Aphanomyces euteiches cDNA blastn 44003 643 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17872306 17872306 PRJEB12237_P_NODE_3515_length_353_cov_5.094340_g3319_i0 PRJEB12237 3515 353 5.09434 17.9830202 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 78.7 5.51e-10   NTclustered gi|695382888|ref|XM_009519246.1| 67593 g3319 i0 100 0.68271954674221 42 0 12 0 122 163 398 357 Phytophthora sojae hypothetical protein mRNA blastn 241 78.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
19146153 19146153 PRJEB12237_P_NODE_11476_length_155_cov_1.550000_g11280_i0 PRJEB12237 11476 155 1.55 2.4025 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 134 4.42e-27   NTclustered gi|2795044192|ref|XM_067924787.1| 4785 g11280 i0 82.692 2.05161290322581 156 22 100 4 1 155 247 398 Phytophthora cinnamomi CMGC/CDK protein kinase (IUM83_00965), partial mRNA blastn 318 134 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
19146155 19146155 PRJEB12237_P_NODE_12156_length_150_cov_1.391304_g11960_i0 PRJEB12237 12156 150 1.391304 2.086956 Achlya klebsiana 4767 SAR_Eukaryotes SAR_Eukaryotes 67.6 4.36e-7   NTclustered gi|166303|gb|J05116.1|ACKCAL 4767 g11960 i0 97.436 1.66666666666667 39 1 26 0 112 150 948 910 A.klebsiana calmodulin gene, complete cds blastn 250 67.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya klebsiana
20112170 20112170 PRJEB12237_P_NODE_3696_length_341_cov_1.506536_g3500_i0 PRJEB12237 3696 341 1.506536 5.13728776 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 309 1.7300000000000003e-79   NTclustered gi|1003093792|gb|KU695503.1| 53984 g3500 i0 82.997 101.759530791789 347 53 100 4 1 341 523 177 Phytophthora citricola strain RLW-P38 translation elongation factor 1-alpha (tef1) gene, partial cds blastn 34700 311 0.993569131832797 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora citricola
20421350 20421350 PRJEB12237_P_NODE_5637_length_250_cov_1.488372_g5441_i0 PRJEB12237 5637 250 1.488372 3.72093 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 178 3.58e-40   NTclustered gi|2794921692|ref|XM_067881078.1| 164328 g5441 i0 85.465 3.424 172 23 68 2 65 235 336 166 Phytophthora ramorum V-type proton ATPase 16 kDa proteolipid subunit (KRP23_10609), partial mRNA blastn 856 178 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
21697407 21697407 PRJEB12237_P_NODE_2598_length_435_cov_2.500000_g2402_i0 PRJEB12237 2598 435 2.5 10.875 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 178 6.639999999999999e-40   NTclustered gi|301093299|ref|XM_002997452.1| 403677 g2402 i0 82.075 44.3471264367816 212 34 48 4 175 384 169 378 Phytophthora infestans T30-4 nascent polypeptide-associated complex subunit alpha-like protein, putative (PITG_19008), partial mRNA blastn 19291 178 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
22972636 22972636 PRJEB12237_P_NODE_10999_length_159_cov_1.290323_g10803_i0 PRJEB12237 10999 159 1.290323 2.05161357 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 62.1 2.19e-5   NTclustered gi|813184929|ref|XM_012351247.1| 695850 g10803 i0 93.023 0.566037735849057 43 2 27 1 74 116 1974 1933 Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA blastn 90 62.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
24246468 24246468 PRJEB12237_P_NODE_1520_length_585_cov_5.412727_g1344_i0 PRJEB12237 1520 585 5.412727 31.66445295 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 244 8.89e-60   NTclustered gi|673039884|ref|XM_008875681.1| 157072 g1344 i0 77.305 14.7452991452991 423 90 72 6 151 570 450 31 Aphanomyces invadans 60S ribosomal protein mRNA blastn 8626 244 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
25211668 25211668 PRJEB12237_P_NODE_3760_length_337_cov_2.231788_g3564_i0 PRJEB12237 3760 337 2.231788 7.52112556 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 156 2.36e-33   NTclustered gi|675172666|ref|XM_008896970.1| 761204 g3564 i0 78.486 7.82789317507418 251 44 73 8 74 319 873 1118 Phytophthora parasitica INRA-310 ADP/ATP translocase 1 mRNA blastn 2638 156 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae

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