RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA473201 · 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
3645596 3645596 PRJNA473201_P_NODE_25463_length_391_cov_0.864780_g24721_i0 PRJNA473201 25463 391 0.86478 3.3812898 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 335 3.309999999999999e-87   NTclustered gi|2795031547|ref|XM_067929360.1| 4785 g24721 i0 85.942 7.34782608695652 313 44 80 0 79 391 317 5 Phytophthora cinnamomi 40S ribosomal protein S25 (IUM83_05233), partial mRNA blastn 2873 335 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
4271360 4271360 PRJNA473201_P_NODE_70684_length_249_cov_0.875000_g69942_i0 PRJNA473201 70684 249 0.875 2.17875 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 119 2.19e-22   NTclustered gi|2795045055|ref|XM_067937582.1| 4785 g69942 i0 91.011 32.5060240963855 89 6 35 2 12 99 226 313 Phytophthora cinnamomi ribosomal protein L34 (IUM83_12935), partial mRNA blastn 8094 119 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
4271525 4271525 PRJNA473201_P_NODE_78344_length_245_cov_0.895349_g77602_i0 PRJNA473201 78344 245 0.895349 2.19360505 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|673047800|ref|XM_008879639.1| 157072 g77602 i0 100 0.118367346938776 29 0 12 0 162 190 658 630 Aphanomyces invadans hypothetical protein mRNA blastn 29 54.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
4271607 4271607 PRJNA473201_P_NODE_81864_length_243_cov_0.905882_g81122_i0 PRJNA473201 81864 243 0.905882 2.20129326 Plasmopara halstedii 4781 SAR_Eukaryotes SAR_Eukaryotes 228 3.389999999999999e-55   NTclustered gi|1378171545|ref|XM_024720239.1| 4781 g81122 i0 84.322 0.97119341563786 236 33 96 4 3 236 10 243 Plasmopara halstedii 60s ribosomal protein (PHALS_06874), partial mRNA blastn 236 228 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara halstedii
10648129 10648129 PRJNA473201_P_NODE_67889_length_250_cov_0.870056_g67147_i0 PRJNA473201 67889 250 0.870056 2.17514 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 272 1.6e-68   NTclustered gi|301093174|ref|XM_002997390.1| 403677 g67147 i0 86.345 47.132 249 34 99 0 1 249 325 573 Phytophthora infestans T30-4 60S ribosomal protein L10 (PITG_19121), mRNA blastn 11783 272 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
13848978 13848978 PRJNA473201_P_NODE_79671_length_244_cov_0.900585_g78929_i0 PRJNA473201 79671 244 0.900585 2.1974274 Saprolegnia 4769 SAR_Eukaryotes SAR_Eukaryotes 111 3.58e-20   NTclustered gi|813148855|ref|XM_012344685.1| 695850 g78929 i0 82.482 1.12295081967213 137 15 54 8 5 136 490 622 Saprolegnia parasitica CBS 223.65 50S ribosomal protein L22 mRNA blastn 274 111 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
18296163 18296163 PRJNA473201_P_NODE_78355_length_245_cov_0.895349_g77613_i0 PRJNA473201 78355 245 0.895349 2.19360505 Plasmopara viticola 143451 SAR_Eukaryotes SAR_Eukaryotes 67.6 7.9e-7   NTclustered gi|1812102600|ref|NC_045922.1| 143451 g77613 i0 91.667 18.3387755102041 48 4 20 0 191 238 6008 6055 Plasmopara viticola mitochondrion, complete genome blastn 4493 67.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara viticola
18296171 18296171 PRJNA473201_P_NODE_79035_length_244_cov_0.900585_g78293_i0 PRJNA473201 79035 244 0.900585 2.1974274 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 185 2.0799999999999994e-42   NTclustered gi|301089745|ref|XM_002895100.1| 403677 g78293 i0 81.696 9.68032786885246 224 40 91 1 5 227 1650 1427 Phytophthora infestans T30-4 threonyl-tRNA synthetase (PITG_21071), partial mRNA blastn 2362 185 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
19570254 19570254 PRJNA473201_P_NODE_77696_length_245_cov_0.895349_g76954_i0 PRJNA473201 77696 245 0.895349 2.19360505 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 270 5.609999999999999e-68   NTclustered gi|2795041993|ref|XM_067924271.1| 4785 g76954 i0 86.531 5.47755102040816 245 33 100 0 1 245 517 761 Phytophthora cinnamomi AP-4 complex subunit epsilon (IUM83_00495), partial mRNA blastn 1342 270 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
24670738 24670738 PRJNA473201_P_NODE_80060_length_244_cov_0.900585_g79318_i0 PRJNA473201 80060 244 0.900585 2.1974274 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 147 9.81e-31   NTclustered gi|695403323|ref|XM_009524958.1| 67593 g79318 i0 81.081 1.51639344262295 185 33 75 2 4 187 682 865 Phytophthora sojae hypothetical protein partial mRNA blastn 370 147 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
25321153 25321153 PRJNA473201_P_NODE_47720_length_297_cov_1.375000_g46978_i0 PRJNA473201 47720 297 1.375 4.08375 Globisporangium 1448052 SAR_Eukaryotes SAR_Eukaryotes 241 5.49e-59   NTclustered gi|1780533979|gb|MK752975.1| 228749 g46978 i0 84.711 53.8013468013468 242 35 81 2 57 297 398 158 Globisporangium glomeratum isolate NESO-4_30 beta-tubulin gene, partial cds blastn 15979 241 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium glomeratum

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