RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA966993 · 19 ✖

analysis 1

  • blastn · 19 ✖

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
942230 942230 PRJNA966993_P_NODE_55521_length_291_cov_2.022936_g55069_i0 PRJNA966993 55521 291 2.022936 5.88674376 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 182 3.2999999999999987e-41   NTclustered gi|695425115|ref|XM_009530803.1| 67593 g55069 i0 80.952 1.56701030927835 231 42 79 2 58 287 51 280 Phytophthora sojae hypothetical protein mRNA blastn 456 182 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
3492859 3492859 PRJNA966993_P_NODE_42903_length_329_cov_2.238281_g42451_i0 PRJNA966993 42903 329 2.238281 7.36394449 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 399 9.6e-107   NTclustered gi|2795052452|ref|XM_067926699.1| 4785 g42451 i0 90.909 80.3981762917933 297 27 90 0 5 301 223 519 Phytophthora cinnamomi caltractin (IUM83_02754), partial mRNA blastn 26451 399 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
5093901 5093901 PRJNA966993_P_NODE_40184_length_339_cov_2.966165_g39732_i0 PRJNA966993 40184 339 2.966165 10.05529935 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 259 1.7600000000000002e-64   NTclustered gi|695433088|ref|XM_009532804.1| 67593 g39732 i0 80.826 95.9026548672566 339 57 99 7 1 335 57 391 Phytophthora sojae hypothetical protein mRNA blastn 32511 259 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
6045686 6045686 PRJNA966993_P_NODE_75665_length_261_cov_2.047872_g75213_i0 PRJNA966993 75665 261 2.047872 5.34494592 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 283 7.749999999999999e-72   NTclustered gi|2794882649|ref|XM_067895061.1| 164328 g75213 i0 86.434 99.4329501915709 258 35 99 0 1 258 146 403 Phytophthora ramorum ADP-ribosylation factor (KRP23_969), partial mRNA blastn 25952 283 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
6045749 6045749 PRJNA966993_P_NODE_83625_length_250_cov_1.740113_g83173_i0 PRJNA966993 83625 250 1.740113 4.3502825 Bremia lactucae 4779 SAR_Eukaryotes SAR_Eukaryotes 462 8.83e-126   NTclustered gi|910278287|gb|KT249411.1| 4779 g83173 i0 100 100.028 250 0 100 0 1 250 331 580 Bremia lactucae voucher GLM77941 28S ribosomal RNA gene, partial sequence blastn 25007 462 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Bremia Bremia lactucae
7320275 7320275 PRJNA966993_P_NODE_47846_length_312_cov_2.552301_g47394_i0 PRJNA966993 47846 312 2.552301 7.96317912 Pythium torulosum 4799 SAR_Eukaryotes SAR_Eukaryotes 147 1.3e-30   NTclustered gi|1780534029|gb|MK753000.1| 4799 g47394 i0 87.5 31.4807692307692 128 14 41 2 186 312 1331 1205 Pythium torulosum isolate MISO_8-29.1 beta-tubulin mRNA, complete cds blastn 9822 147 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium torulosum
7320568 7320568 PRJNA966993_P_NODE_78666_length_256_cov_2.229508_g78214_i0 PRJNA966993 78666 256 2.229508 5.70754048 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 71.3 6.43e-8   NTclustered gi|669153627|ref|XM_008614154.1| 1156394 g78214 i0 90.566 0.4140625 53 5 21 0 170 222 1314 1262 Saprolegnia diclina VS20 hypothetical protein partial mRNA blastn 106 71.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
8595120 8595120 PRJNA966993_P_NODE_36847_length_353_cov_2.514286_g36395_i0 PRJNA966993 36847 353 2.514286 8.87542958 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 196 1.4599999999999998e-45   NTclustered gi|669153141|ref|XM_008613911.1| 1156394 g36395 i0 86.264 26.1501416430595 182 23 51 2 26 206 394 214 Saprolegnia diclina VS20 60S ribosomal protein mRNA blastn 9231 196 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
10194288 10194288 PRJNA966993_P_NODE_37588_length_350_cov_1.667870_g37136_i0 PRJNA966993 37588 350 1.66787 5.837545 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 278 5.0100000000000006e-70   NTclustered gi|2795045397|ref|XM_067939565.1| 4785 g37136 i0 88.938 63.9685714285714 226 23 64 2 124 348 266 42 Phytophthora cinnamomi dynein light chain LC6, flagellar outer arm (IUM83_14793), partial mRNA blastn 22389 279 0.996415770609319 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
13696172 13696172 PRJNA966993_P_NODE_82791_length_251_cov_0.865169_g82339_i0 PRJNA966993 82791 251 0.865169 2.17157419 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 95.3 3.73e-15   NTclustered gi|813160689|ref|XM_012347159.1| 695850 g82339 i0 90.278 8.26294820717131 72 7 29 0 180 251 345 274 Saprolegnia parasitica CBS 223.65 histone H4 mRNA blastn 2074 95.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
14970531 14970531 PRJNA966993_P_NODE_90432_length_246_cov_1.653179_g89980_i0 PRJNA966993 90432 246 1.653179 4.06682034 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 139 1.66e-28   NTclustered gi|695373065|ref|XM_009516665.1| 67593 g89980 i0 78.571 16.630081300813 224 38 89 10 26 244 699 481 Phytophthora sojae hypothetical protein mRNA blastn 4091 139 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
16244757 16244757 PRJNA966993_P_NODE_13993_length_561_cov_1.856557_g13559_i0 PRJNA966993 13993 561 1.856557 10.41528477 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 1031 0   NTclustered gi|166046524|emb|CU367641.1| 100861 g13559 i0 99.822 43.5472370766488 561 1 100 0 1 561 600 40 Aphanomyces euteiches cDNA blastn 24430 1031 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16245071 16245071 PRJNA966993_P_NODE_51713_length_301_cov_1.425439_g51261_i0 PRJNA966993 51713 301 1.425439 4.29057139 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 315 3.239999999999999e-81   NTclustered gi|695389557|ref|XM_009521174.1| 67593 g51261 i0 86.007 565.667774086379 293 41 97 0 7 299 479 187 Phytophthora sojae hypothetical protein partial mRNA blastn 170266 315 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
17520160 17520160 PRJNA966993_P_NODE_38774_length_345_cov_1.632353_g38322_i0 PRJNA966993 38774 345 1.632353 5.63161785 Peronospora belbahrii 622444 SAR_Eukaryotes SAR_Eukaryotes 207 6.58e-49   NTclustered gi|2248512836|ref|NC_063790.1| 622444 g38322 i0 78.107 54.168115942029 338 67 97 7 12 345 8129 7795 Peronospora belbahrii isolate HI01 mitochondrion, complete genome blastn 18688 207 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora belbahrii
20068941 20068941 PRJNA966993_P_NODE_55296_length_292_cov_1.054795_g54844_i0 PRJNA966993 55296 292 1.054795 3.0800014 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 209 1.52e-49   NTclustered gi|301091914|ref|XM_002896086.1| 403677 g54844 i0 79.795 2.93493150684932 292 55 99 4 3 292 815 1104 Phytophthora infestans T30-4 cell division control protein 48 (PITG_19871), mRNA blastn 857 209 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
20068961 20068961 PRJNA966993_P_NODE_57796_length_288_cov_1.269767_g57344_i0 PRJNA966993 57796 288 1.269767 3.65692896 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 281 3.12e-71   NTclustered gi|669139691|ref|XM_008607192.1| 1156394 g57344 i0 84.375 92.7881944444444 288 43 99 2 2 288 1941 1655 Saprolegnia diclina VS20 cell division cycle protein 48 mRNA blastn 26723 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
20069210 20069210 PRJNA966993_P_NODE_83396_length_250_cov_3.468927_g82944_i0 PRJNA966993 83396 250 3.468927 8.6723175 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 446 8.89e-121   NTclustered gi|166044546|emb|CU367455.1| 100861 g82944 i0 98.8 46.104 250 3 100 0 1 250 274 523 Aphanomyces euteiches cDNA blastn 11526 446 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
21667983 21667983 PRJNA966993_P_NODE_70237_length_270_cov_1.177665_g69785_i0 PRJNA966993 70237 270 1.177665 3.1796955 root 1 Root_unresolved Root_unresolved 54.7 0.007   NTclustered gi|669149903|ref|XM_008612292.1| 1156394 g69785 i0 79.07 0.425925925925926 86 12 31 4 1 83 221 139 Saprolegnia diclina VS20 hypothetical protein mRNA blastn 115 54.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
21667991 21667991 PRJNA966993_P_NODE_73137_length_265_cov_2.182292_g72685_i0 PRJNA966993 73137 265 2.182292 5.7830738 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 183 8.229999999999998e-42   NTclustered gi|2795054702|ref|XM_067932899.1| 4785 g72685 i0 85 7.58867924528302 180 27 68 0 74 253 139 318 Phytophthora cinnamomi DEAD-box ATP-dependent RNA helicase 8 (IUM83_08521), partial mRNA blastn 2011 183 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);;