RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA352850 · 22 ✖

analysis 1

  • blastn · 22 ✖

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
1670612 1670612 PRJNA352850_P_NODE_50742_length_338_cov_1.217993_g47909_i0 PRJNA352850 50742 338 1.217993 4.11681634 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 614 3.2499999999999993e-171   NTclustered gi|166046798|emb|CU367373.1| 100861 g47909 i0 99.408 41.8994082840237 338 2 100 0 1 338 314 651 Aphanomyces euteiches cDNA blastn 14162 614 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2946060 2946060 PRJNA352850_P_NODE_34223_length_445_cov_5.085859_g31392_i0 PRJNA352850 34223 445 5.085859 22.63207255 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 137 1.16e-27   NTclustered gi|2795051892|ref|XM_067940206.1| 4785 g31392 i0 86.885 25.6988764044944 122 16 27 0 320 441 213 92 Phytophthora cinnamomi 60S ribosomal protein L44 (IUM83_15393), partial mRNA blastn 11436 137 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
4222990 4222990 PRJNA352850_P_NODE_44584_length_370_cov_1.457944_g41751_i0 PRJNA352850 44584 370 1.457944 5.3943928 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 684 0   NTclustered gi|166046714|emb|CU367824.1| 100861 g41751 i0 100 94.9324324324324 370 0 100 0 1 370 453 822 Aphanomyces euteiches cDNA blastn 35125 684 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
5499986 5499986 PRJNA352850_P_NODE_65865_length_280_cov_2.251082_g63032_i0 PRJNA352850 65865 280 2.251082 6.3030296 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 518 2.12e-142   NTclustered gi|166046703|emb|CU367813.1| 100861 g63032 i0 100 97.5285714285714 280 0 100 0 1 280 411 690 Aphanomyces euteiches cDNA blastn 27308 518 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
8049747 8049747 PRJNA352850_P_NODE_69527_length_269_cov_2.736364_g66694_i0 PRJNA352850 69527 269 2.736364 7.36081916 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 492 1.23e-134   NTclustered gi|166046469|emb|CU367586.1| 100861 g66694 i0 99.628 323.029739776952 269 1 100 0 1 269 300 568 Aphanomyces euteiches cDNA blastn 86895 492 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9324605 9324605 PRJNA352850_P_NODE_70708_length_267_cov_1.408257_g67875_i0 PRJNA352850 70708 267 1.408257 3.76004619 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 494 3.38e-135   NTclustered gi|166046489|emb|CU367606.1| 100861 g67875 i0 100 100.220973782772 267 0 100 0 1 267 425 159 Aphanomyces euteiches cDNA blastn 26759 494 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9325033 9325033 PRJNA352850_P_NODE_85148_length_238_cov_2.354497_g82315_i0 PRJNA352850 85148 238 2.354497 5.60370286 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 429 8.45e-116   NTclustered gi|166044622|emb|CU367531.1| 100861 g82315 i0 99.16 49.2016806722689 238 2 100 0 1 238 127 364 Aphanomyces euteiches cDNA blastn 11710 429 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9999416 9999416 PRJNA352850_P_NODE_42948_length_380_cov_1.821752_g40115_i0 PRJNA352850 42948 380 1.821752 6.9226576 root 1 Root_unresolved Root_unresolved 671 0   NTclustered gi|166046500|emb|CU367617.1| 100861 g40115 i0 98.677 100.107894736842 378 5 99 0 1 378 387 10 Aphanomyces euteiches cDNA blastn 38041 671 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
13149276 13149276 PRJNA352850_P_NODE_42151_length_385_cov_1.958333_g39319_i0 PRJNA352850 42151 385 1.958333 7.53958205 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 684 0   NTclustered gi|166046734|emb|CU367844.1| 100861 g39319 i0 99.468 43.8441558441558 376 2 98 0 10 385 753 378 Aphanomyces euteiches cDNA blastn 16880 684 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
15698425 15698425 PRJNA352850_P_NODE_45513_length_364_cov_4.641270_g42680_i0 PRJNA352850 45513 364 4.64127 16.8942228 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 76.8 2.05e-9   NTclustered gi|695369558|ref|XM_009515791.1| 67593 g42680 i0 100 0.112637362637363 41 0 11 0 292 332 179 219 Phytophthora sojae hypothetical protein mRNA blastn 41 76.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
16973697 16973697 PRJNA352850_P_NODE_63674_length_287_cov_2.201681_g60841_i0 PRJNA352850 63674 287 2.2016810000000002 6.31882447 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 531 2.799999999999999e-146   NTclustered gi|166044475|emb|CU367384.1| 100861 g60841 i0 100 38.801393728223 287 0 100 0 1 287 342 628 Aphanomyces euteiches cDNA blastn 11136 531 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18247343 18247343 PRJNA352850_P_NODE_44035_length_373_cov_1.876543_g41202_i0 PRJNA352850 44035 373 1.876543 6.99950539 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 682 0   NTclustered gi|166044500|emb|CU367409.1| 100861 g41202 i0 100 87.9892761394102 369 0 99 0 1 369 369 1 Aphanomyces euteiches cDNA blastn 32820 682 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18247498 18247498 PRJNA352850_P_NODE_48815_length_347_cov_2.184564_g45982_i0 PRJNA352850 48815 347 2.184564 7.58043708 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 636 7.13e-178   NTclustered gi|166046578|emb|CU367695.1| 100861 g45982 i0 99.713 100.005763688761 348 0 100 1 1 347 392 45 Aphanomyces euteiches cDNA blastn 34702 636 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18247895 18247895 PRJNA352850_P_NODE_61135_length_296_cov_1.473684_g58302_i0 PRJNA352850 61135 296 1.473684 4.36210464 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 531 2.899999999999999e-146   NTclustered gi|166044546|emb|CU367455.1| 100861 g58302 i0 98.986 75.7736486486486 296 3 100 0 1 296 636 341 Aphanomyces euteiches cDNA blastn 22429 531 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18922386 18922386 PRJNA352850_P_NODE_20555_length_637_cov_1.568027_g17781_i0 PRJNA352850 20555 637 1.568027 9.98833199 root 1 Root_unresolved Root_unresolved 911 0   NTclustered gi|166046613|emb|CU367730.1| 100861 g17781 i0 96.223 116.010989010989 556 21 87 0 1 556 14 569 Aphanomyces euteiches cDNA blastn 73899 911 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
22072808 22072808 PRJNA352850_P_NODE_62438_length_291_cov_2.148760_g59605_i0 PRJNA352850 62438 291 2.14876 6.2528916 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 538 1.6999999999999994e-148   NTclustered gi|166044613|emb|CU367522.1| 100861 g59605 i0 100 85.4020618556701 291 0 100 0 1 291 22 312 Aphanomyces euteiches cDNA blastn 24852 538 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23347007 23347007 PRJNA352850_P_NODE_24679_length_559_cov_7.033333_g21863_i0 PRJNA352850 24679 559 7.033333 39.31633147 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 472 3.5699999999999997e-128   NTclustered gi|2794917670|ref|XM_067894126.1| 164328 g21863 i0 85.811 24.0035778175313 444 63 79 0 115 558 915 472 Phytophthora ramorum Pyridoxal 5'-phosphate synthase subunit PdxS (KRP23_8658), partial mRNA blastn 13418 472 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
23347269 23347269 PRJNA352850_P_NODE_32619_length_461_cov_1.766990_g29789_i0 PRJNA352850 32619 461 1.76699 8.1458239 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 850 0   NTclustered gi|166046524|emb|CU367641.1| 100861 g29789 i0 100 39.997830802603 460 0 99 0 2 461 1 460 Aphanomyces euteiches cDNA blastn 18439 850 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23348671 23348671 PRJNA352850_P_NODE_78319_length_252_cov_3.320197_g75486_i0 PRJNA352850 78319 252 3.320197 8.36689644 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 460 3.2e-125   NTclustered gi|698793876|ref|XR_717098.1| 112090 g75486 i0 99.603 102.325396825397 252 1 100 0 1 252 2166 2417 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 25786 460 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
24622773 24622773 PRJNA352850_P_NODE_72080_length_264_cov_1.934884_g69247_i0 PRJNA352850 72080 264 1.934884 5.10809376 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 488 1.5499999999999999e-133   NTclustered gi|166046792|emb|CU367367.1| 100861 g69247 i0 100 82.7234848484848 264 0 100 0 1 264 589 326 Aphanomyces euteiches cDNA blastn 21839 488 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
24622937 24622937 PRJNA352850_P_NODE_77300_length_254_cov_2.278049_g74467_i0 PRJNA352850 77300 254 2.278049 5.78624446 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 464 2.4999999999999994e-126   NTclustered gi|166046638|emb|CU367755.1| 100861 g74467 i0 99.606 33.0196850393701 254 1 100 0 1 254 355 102 Aphanomyces euteiches cDNA blastn 8387 464 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
25297800 25297800 PRJNA352850_P_NODE_64580_length_284_cov_2.655319_g61747_i0 PRJNA352850 64580 284 2.655319 7.54110596 root 1 Root_unresolved Root_unresolved 520 5.98e-143   NTclustered gi|166044612|emb|CU367521.1| 100861 g61747 i0 99.648 99.5 284 1 100 0 1 284 679 396 Aphanomyces euteiches cDNA blastn 28258 520 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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