RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1061474" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1061474 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
177967 177967 PRJNA1061474_P_NODE_18361_length_462_cov_2.107969_g18115_i0 PRJNA1061474 18361 462 2.107969 9.73881678 Achlya ambisexualis 4768 SAR_Eukaryotes SAR_Eukaryotes 252 4.12e-62   NTclustered gi|22086549|gb|AF402100.1| 4768 g18115 i0 77.155 15.047619047619 464 86 98 18 9 462 833 380 Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds blastn 6952 252 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya ambisexualis
4004195 4004195 PRJNA1061474_P_NODE_14544_length_535_cov_6.865801_g14300_i0 PRJNA1061474 14544 535 6.865801 36.73203535 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 6.16e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g14300 i0 80.533 63.2299065420561 375 65 69 4 143 510 441 68 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
4004281 4004281 PRJNA1061474_P_NODE_16924_length_486_cov_2.576271_g16678_i0 PRJNA1061474 16924 486 2.576271 12.52067706 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 446 1.86e-120   NTclustered gi|675199806|ref|XM_008910540.1| 761204 g16678 i0 85 88.5946502057613 440 64 90 2 48 486 129 567 Phytophthora parasitica INRA-310 calmodulin mRNA blastn 43057 446 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
5281407 5281407 PRJNA1061474_P_NODE_40965_length_274_cov_1.532338_g40719_i0 PRJNA1061474 40965 274 1.532338 4.19860612 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 202 2.3599999999999996e-47   NTclustered gi|813133999|ref|XM_012342618.1| 695850 g40719 i0 83.645 22.521897810219 214 35 78 0 58 271 324 111 Saprolegnia parasitica CBS 223.65 ribonucleoprotein-associated protein mRNA blastn 6171 202 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
19304615 19304615 PRJNA1061474_P_NODE_50096_length_247_cov_0.885057_g49850_i0 PRJNA1061474 50096 247 0.885057 2.18609079 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 348 2.5400000000000004e-91   NTclustered gi|675209236|ref|XM_008915255.1| 761204 g49850 i0 92.245 11.4696356275304 245 19 99 0 3 247 321 565 Phytophthora parasitica INRA-310 archaeal ribosomal protein S17P mRNA blastn 2833 348 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
25237968 25237968 PRJNA1061474_P_NODE_48860_length_248_cov_0.880000_g48614_i0 PRJNA1061474 48860 248 0.88 2.1824 Albugo 65356 SAR_Eukaryotes SAR_Eukaryotes 126 1.2999999999999998e-24   NTclustered gi|325190492|emb|FR824314.1| 890382 g48614 i0 96.104 1.875 77 3 31 0 61 137 18379 18303 Albugo laibachii Nc14, genomic contig CONTIG_269_NC14_v4_35463_227 blastn 465 126 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);;