RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA1159911 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
5410815 5410815 PRJNA1159911_P_NODE_41325_length_393_cov_2.203125_g40783_i0 PRJNA1159911 41325 393 2.203125 8.65828125 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 231 4.499999999999999e-56   NTclustered gi|2794905809|ref|XM_067889902.1| 164328 g40783 i0 79.751 53.5190839694656 321 63 81 2 18 337 335 16 Phytophthora ramorum 13 kDa ribonucleoprotein-associated protein (KRP23_4892), partial mRNA blastn 21033 231 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
7961018 7961018 PRJNA1159911_P_NODE_43967_length_377_cov_1.911184_g43425_i0 PRJNA1159911 43967 377 1.911184 7.20516368 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.66e-5   NTclustered gi|675181624|ref|XM_008901449.1| 761204 g43425 i0 95 0.286472148541114 40 2 11 0 245 284 141 102 Phytophthora parasitica INRA-310 hypothetical protein mRNA blastn 108 63.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
9235742 9235742 PRJNA1159911_P_NODE_42508_length_386_cov_1.396166_g41966_i0 PRJNA1159911 42508 386 1.396166 5.38920076 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 243 2.04e-59   NTclustered gi|695434207|ref|XM_009533074.1| 67593 g41966 i0 85.47 14.6217616580311 234 33 61 1 109 342 566 334 Phytophthora sojae hypothetical protein partial mRNA blastn 5644 243 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
11785818 11785818 PRJNA1159911_P_NODE_104950_length_200_cov_5.228346_g104408_i0 PRJNA1159911 104950 200 5.228346 10.456692 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 196 7.59e-46   NTclustered gi|669148871|ref|XM_008611776.1| 1156394 g104408 i0 84.772 101.205 197 28 98 2 5 200 1213 1408 Saprolegnia diclina VS20 3-oxoacid CoA transferase 1 mRNA blastn 20241 196 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
11786481 11786481 PRJNA1159911_P_NODE_4570_length_1661_cov_6.903652_g4342_i0 PRJNA1159911 4570 1661 6.903652 114.66965972 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 887 0   NTclustered gi|669151349|ref|XM_008613015.1| 1156394 g4342 i0 78.431 69.2817579771222 1428 261 84 38 236 1635 1543 135 Saprolegnia diclina VS20 adenosylhomocysteinase mRNA blastn 115077 887 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
11786666 11786666 PRJNA1159911_P_NODE_55190_length_326_cov_7.339921_g54648_i0 PRJNA1159911 55190 326 7.339921 23.92814246 Achlya bisexualis 4766 SAR_Eukaryotes SAR_Eukaryotes 279 1.29e-70   NTclustered gi|2289|emb|X59936.1| 4766 g54648 i0 87.552 71.6625766871166 241 30 74 0 2 242 241 1 A.bisexualis gene for actin blastn 23362 279 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya bisexualis
11786921 11786921 PRJNA1159911_P_NODE_67490_length_289_cov_6.861111_g66948_i0 PRJNA1159911 67490 289 6.861111 19.82861079 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 270 6.779999999999998e-68   NTclustered gi|669155015|ref|XM_008614848.1| 1156394 g66948 i0 86.056 82.961937716263 251 35 87 0 39 289 32 282 Saprolegnia diclina VS20 actin mRNA blastn 23976 270 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
15611513 15611513 PRJNA1159911_P_NODE_9013_length_1113_cov_2.399038_g8620_i0 PRJNA1159911 9013 1113 2.399038 26.70129294 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 699 0   NTclustered gi|2795031183|ref|XM_067929373.1| 4785 g8620 i0 78.658 37.6208445642408 1073 214 96 12 15 1081 1691 628 Phytophthora cinnamomi V-type ATPase, A subunit (IUM83_05246), partial mRNA blastn 41872 699 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
16340390 16340390 PRJNA1159911_P_NODE_19153_length_671_cov_11.479933_g18643_i0 PRJNA1159911 19153 671 11.479933 77.03035043 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 488 4.2999999999999986e-133   NTclustered gi|9858457|gb|AF085344.1|AF085344 82926 g18643 i0 86.057 66.2116244411326 459 59 68 4 53 509 28 483 Pythium splendens calmodulin mRNA, complete cds blastn 44428 492 0.991869918699187 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium splendens
16884682 16884682 PRJNA1159911_P_NODE_34174_length_449_cov_2.473404_g33633_i0 PRJNA1159911 34174 449 2.473404 11.10558396 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 353 1.06e-92   NTclustered gi|166036539|emb|CU352162.1| 100861 g33633 i0 81.027 86.2204899777283 448 81 99 4 1 446 358 803 Aphanomyces euteiches cDNA blastn 38713 353 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17615617 17615617 PRJNA1159911_P_NODE_20954_length_631_cov_2.496416_g20432_i0 PRJNA1159911 20954 631 2.496416 15.75238496 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 503 1.4399999999999996e-137   NTclustered gi|2794889416|ref|XM_067886769.1| 164328 g20432 i0 83.794 83.8288431061807 543 75 85 11 90 625 1227 691 Phytophthora ramorum ATP-dependent RNA helicase eIF4A (KRP23_2082), partial mRNA blastn 52896 503 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
20164271 20164271 PRJNA1159911_P_NODE_19176_length_671_cov_2.483278_g18665_i0 PRJNA1159911 19176 671 2.483278 16.66279538 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 435 5.68e-117   NTclustered gi|2795023024|ref|XM_067929956.1| 4785 g18665 i0 83.333 12.4977645305514 474 75 70 4 9 480 17 488 Phytophthora cinnamomi GTP-binding protein YPTC4 (IUM83_05799), partial mRNA blastn 8386 435 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
20709175 20709175 PRJNA1159911_P_NODE_45057_length_371_cov_1.546980_g44515_i0 PRJNA1159911 45057 371 1.54698 5.7392958 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 257 6.96e-64   NTclustered gi|166044823|emb|CU351082.1| 100861 g44515 i0 80.114 12.1967654986523 352 64 94 5 1 349 503 155 Aphanomyces euteiches cDNA blastn 4525 257 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21984239 21984239 PRJNA1159911_P_NODE_25138_length_555_cov_18.989627_g24601_i0 PRJNA1159911 25138 555 18.989627 105.39242985 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 6.400000000000001e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g24601 i0 80.533 60.9513513513513 375 65 66 4 169 536 441 68 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
21984867 21984867 PRJNA1159911_P_NODE_57758_length_318_cov_1.257143_g57216_i0 PRJNA1159911 57758 318 1.257143 3.99771474 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 193 1.68e-44   NTclustered gi|673036227|ref|XM_008873853.1| 157072 g57216 i0 79.71 22.7012578616352 276 48 86 7 40 311 1081 810 Aphanomyces invadans adenosylhomocysteinase 2 mRNA blastn 7219 193 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
23990151 23990151 PRJNA1159911_P_NODE_30579_length_485_cov_2.250000_g30039_i0 PRJNA1159911 30579 485 2.25 10.9125 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 357 8.95e-94   NTclustered gi|813157084|ref|XM_012346501.1| 695850 g30039 i0 80.645 9.37938144329897 465 86 95 4 1 463 226 688 Saprolegnia parasitica CBS 223.65 serine/threonine-protein phosphatase 4 catalytic subunit mRNA blastn 4549 357 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
24533403 24533403 PRJNA1159911_P_NODE_24000_length_573_cov_19.880000_g23468_i0 PRJNA1159911 24000 573 19.88 113.9124 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 302 5.08e-77   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g23468 i0 78.452 61.9371727748691 478 91 83 9 78 550 527 57 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 35490 302 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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