RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA896758 · 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
872764 872764 PRJNA896758_P_NODE_10981_length_346_cov_2.245421_g10591_i0 PRJNA896758 10981 346 2.245421 7.76915666 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.009   NTclustered gi|695379224|ref|XM_009518191.1| 67593 g10591 i0 100 0.167630057803468 29 0 8 0 270 298 1863 1835 Phytophthora sojae hypothetical protein partial mRNA blastn 58 54.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
3423576 3423576 PRJNA896758_P_NODE_16063_length_287_cov_1.079439_g15673_i0 PRJNA896758 16063 287 1.079439 3.09798993 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 189 1.94e-43   NTclustered gi|2795044224|ref|XM_067924377.1| 4785 g15673 i0 80.709 22.8919860627178 254 39 87 10 10 258 512 264 Phytophthora cinnamomi Carbohydrate esterase (IUM83_00594), partial mRNA blastn 6570 189 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
7250925 7250925 PRJNA896758_P_NODE_17706_length_276_cov_1.118227_g17316_i0 PRJNA896758 17706 276 1.118227 3.08630652 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.025   NTclustered gi|813171126|ref|XM_012348929.1| 695850 g17316 i0 100 0.101449275362319 28 0 10 0 208 235 864 837 Saprolegnia parasitica CBS 223.65 CMGC/MAPK protein kinase mRNA blastn 28 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
7251014 7251014 PRJNA896758_P_NODE_3866_length_584_cov_1.626223_g3484_i0 PRJNA896758 3866 584 1.626223 9.49714232 Phytophthora gondwanensis 2017144 SAR_Eukaryotes SAR_Eukaryotes 399 1.7899999999999995e-106   NTclustered gi|2131668388|gb|OK267378.1| 2017144 g3484 i0 79.102 99.4760273972603 579 115 99 6 9 584 1 576 Phytophthora gondwanensis strain ex-type CBS 139336 translation elongation factor 1-alpha (EF1A) gene, partial cds blastn 58094 399 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora gondwanensis
8525655 8525655 PRJNA896758_P_NODE_2487_length_731_cov_1.715805_g2126_i0 PRJNA896758 2487 731 1.715805 12.54253455 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 510 1e-139   NTclustered gi|2795024905|ref|XM_067925247.1| 4785 g2126 i0 80.967 74.3201094391245 662 110 89 14 76 729 60 713 Phytophthora cinnamomi ADP/ATP translocase 1 (IUM83_01398), partial mRNA blastn 54328 510 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
13626693 13626693 PRJNA896758_P_NODE_7451_length_415_cov_2.125731_g7061_i0 PRJNA896758 7451 415 2.125731 8.82178365 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 183 1.36e-41   NTclustered gi|673024575|ref|XM_008868027.1| 157072 g7061 i0 90.647 23.8289156626506 139 11 33 2 278 415 2388 2251 Aphanomyces invadans tubulin beta chain mRNA blastn 9889 183 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
19999342 19999342 PRJNA896758_P_NODE_10116_length_359_cov_2.416084_g9726_i0 PRJNA896758 10116 359 2.416084 8.67374156 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 261 5.19e-65   NTclustered gi|2795040529|ref|XM_067944818.1| 4785 g9726 i0 81.308 42.4596100278552 321 60 89 0 10 330 344 24 Phytophthora cinnamomi 60S ribosomal protein L23 (IUM83_19754), partial mRNA blastn 15243 261 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
19999457 19999457 PRJNA896758_P_NODE_2536_length_724_cov_5.634409_g2175_i0 PRJNA896758 2536 724 5.634409 40.79312116 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 436 1.71e-117   NTclustered gi|695406639|ref|XM_009525867.1| 67593 g2175 i0 79.806 35.3245856353591 619 110 85 11 89 704 616 10 Phytophthora sojae hypothetical protein mRNA blastn 25575 436 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
21274781 21274781 PRJNA896758_P_NODE_24177_length_246_cov_0.861272_g23787_i0 PRJNA896758 24177 246 0.861272 2.11872912 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 230 9.56e-56   NTclustered gi|2795033000|ref|XM_067928111.1| 4785 g23787 i0 83.806 18.2764227642276 247 34 99 5 3 246 3745 3502 Phytophthora cinnamomi Carbamoyl-phosphate synthase, large subunit (IUM83_04070), partial mRNA blastn 4496 230 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
22921536 22921536 PRJNA896758_P_NODE_14078_length_306_cov_2.133047_g13688_i0 PRJNA896758 14078 306 2.133047 6.52712382 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 244 4.39e-60   NTclustered gi|33520243|gb|AY273988.1| 162137 g13688 i0 83.099 69.8823529411765 284 33 91 11 3 281 225 498 Plasmopara pimpinellae large subunit ribosomal RNA gene, partial sequence blastn 21384 246 0.991869918699187 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara pimpinellae
23824958 23824958 PRJNA896758_P_NODE_16919_length_281_cov_1.274038_g16529_i0 PRJNA896758 16919 281 1.274038 3.58004678 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 228 4.0099999999999984e-55   NTclustered gi|325194231|emb|FR825088.1| 890382 g16529 i0 90.286 0.622775800711744 175 16 62 1 24 198 174 1 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 175 228 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii

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