RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1136505" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 13 ✖

tax_clade 1

bioproject 1

  • PRJNA1136505 · 13 ✖

analysis 1

  • blastn · 13 ✖

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
1032003 1032003 PRJNA1136505_P_NODE_82341_length_321_cov_2.036290_g75481_i0 PRJNA1136505 82341 321 2.03629 6.5364909 root 1 Root_unresolved Root_unresolved 549 8.759999999999997e-152   NTclustered gi|166044596|emb|CU367505.1| 100861 g75481 i0 97.508 94.9127725856698 321 8 100 0 1 321 152 472 Aphanomyces euteiches cDNA blastn 30467 549 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
4860043 4860043 PRJNA1136505_P_NODE_156444_length_239_cov_2.319277_g149584_i0 PRJNA1136505 156444 239 2.319277 5.54307203 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 217 7.2e-52   NTclustered gi|166045949|emb|CU363861.1| 100861 g149584 i0 83.983 20.1213389121339 231 32 95 4 1 228 304 532 Aphanomyces euteiches cDNA blastn 4809 217 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9212511 9212511 PRJNA1136505_P_NODE_25148_length_859_cov_9.329517_g18690_i0 PRJNA1136505 25148 859 9.329517 80.14055103 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 460 1.21e-124   NTclustered gi|2795027745|ref|XM_067926220.1| 4785 g18690 i0 80.187 63.813736903376 641 106 74 18 158 789 133 761 Phytophthora cinnamomi 40S ribosomal protein S2 (IUM83_02311), partial mRNA blastn 54816 460 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
10488090 10488090 PRJNA1136505_P_NODE_93689_length_298_cov_2.897778_g86829_i0 PRJNA1136505 93689 298 2.897778 8.63537844 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 126 1.6099999999999997e-24   NTclustered gi|2794879580|ref|XM_067889356.1| 164328 g86829 i0 86.207 2.72818791946309 116 16 39 0 149 264 116 1 Phytophthora ramorum 40S ribosomal protein S21 (KRP23_462), partial mRNA blastn 813 126 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
11763167 11763167 PRJNA1136505_P_NODE_89390_length_307_cov_0.841880_g82530_i0 PRJNA1136505 89390 307 0.84188 2.5845716 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 291 5.58e-74   NTclustered gi|813192857|ref|XM_012352921.1| 695850 g82530 i0 84.106 39.3615635179153 302 46 98 2 7 307 1297 997 Saprolegnia parasitica CBS 223.65 hypothetical protein mRNA blastn 12084 291 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
13038190 13038190 PRJNA1136505_P_NODE_135791_length_249_cov_0.875000_g128931_i0 PRJNA1136505 135791 249 0.875 2.17875 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 139 1.68e-28   NTclustered gi|669156411|ref|XM_008615546.1| 1156394 g128931 i0 92.708 4.86746987951807 96 7 39 0 3 98 1127 1222 Saprolegnia diclina VS20 acyl-CoA dehydrogenase mRNA blastn 1212 139 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
13038231 13038231 PRJNA1136505_P_NODE_27411_length_777_cov_2.250000_g20797_i0 PRJNA1136505 27411 777 2.25 17.4825 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 255 5.530000000000001e-63   NTclustered gi|2795047539|ref|XM_067937834.1| 4785 g20797 i0 77.677 34.6705276705277 439 84 56 13 12 443 1 432 Phytophthora cinnamomi 60S ribosomal protein (IUM83_13175), partial mRNA blastn 26939 255 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
14313481 14313481 PRJNA1136505_P_NODE_99132_length_289_cov_2.138889_g92272_i0 PRJNA1136505 99132 289 2.138889 6.18138921 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 254 6.83e-63   NTclustered gi|669165177|ref|XM_008619929.1| 1156394 g92272 i0 83.214 11.8961937716263 280 43 96 3 12 289 1120 843 Saprolegnia diclina VS20 hypothetical protein mRNA blastn 3438 254 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
15059684 15059684 PRJNA1136505_P_NODE_85972_length_313_cov_2.454167_g79112_i0 PRJNA1136505 85972 313 2.454167 7.68154271 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 87.9 8.03e-13   NTclustered gi|166038860|emb|CU355090.1| 100861 g79112 i0 85.542 23.0095846645367 83 12 27 0 231 313 750 668 Aphanomyces euteiches cDNA blastn 7202 87.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16334409 16334409 PRJNA1136505_P_NODE_40133_length_530_cov_3.564551_g33290_i0 PRJNA1136505 40133 530 3.564551 18.8921203 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 231 6.22e-56   NTclustered gi|813141990|ref|XM_012343753.1| 695850 g33290 i0 79.36 11.4867924528302 344 59 64 8 113 453 463 129 Saprolegnia parasitica CBS 223.65 40S ribosomal protein S11 mRNA blastn 6088 231 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
21961282 21961282 PRJNA1136505_P_NODE_32858_length_640_cov_3.246914_g26078_i0 PRJNA1136505 32858 640 3.246914 20.7802496 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 340 1.21e-88   NTclustered gi|2795016619|ref|XM_067930420.1| 4785 g26078 i0 79.278 55.80625 526 80 82 17 33 555 629 1128 Phytophthora cinnamomi 60S ribosomal protein (IUM83_06233), partial mRNA blastn 35716 340 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
23236822 23236822 PRJNA1136505_P_NODE_40199_length_530_cov_1.582057_g33356_i0 PRJNA1136505 40199 530 1.582057 8.3849021 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 388 3.4899999999999997e-103   NTclustered gi|695404622|ref|XM_009525283.1| 67593 g33356 i0 81.628 77.322641509434 479 78 89 8 25 498 958 1431 Phytophthora sojae hypothetical protein partial mRNA blastn 40981 388 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
25258298 25258298 PRJNA1136505_P_NODE_33000_length_637_cov_3.083333_g26216_i0 PRJNA1136505 33000 637 3.083333 19.64083121 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 239 4.53e-58   NTclustered gi|2795043501|ref|XM_067923847.1| 4785 g26216 i0 81.373 8.22448979591837 306 45 47 10 311 609 308 8 Phytophthora cinnamomi 40S ribosomal protein S10 (IUM83_00108), partial mRNA blastn 5239 239 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi

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