contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJEB58983" and tax_phylum = "Oomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 124676 | 124676 | PRJEB58983_P_NODE_14561_length_334_cov_1.379310_g14146_i0 | PRJEB58983 | 14561 | 334 | 1.37931 | 4.6068954 | Phytophthora ramorum | 164328 | SAR_Eukaryotes | SAR_Eukaryotes | 222 | 2.27e-53 | NTclustered | gi|2794879146|ref|XM_067888617.1| | 164328 | g14146 | i0 | 79.936 | 48.2964071856287 | 314 | 53 | 93 | 8 | 23 | 331 | 531 | 223 | Phytophthora ramorum Guanine nucleotide-binding protein subunit beta-like protein (KRP23_392), partial mRNA | blastn | 16131 | 222 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora ramorum | ||
| 124785 | 124785 | PRJEB58983_P_NODE_20521_length_287_cov_1.602804_g20106_i0 | PRJEB58983 | 20521 | 287 | 1.602804 | 4.60004748 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.2e-51 | NTclustered | gi|2795021165|ref|XM_067935669.1| | 4785 | g20106 | i0 | 82.4 | 80.8606271777004 | 250 | 40 | 86 | 3 | 1 | 248 | 1089 | 1336 | Phytophthora cinnamomi ATP synthase subunit beta, mitochondrial (IUM83_11126), partial mRNA | blastn | 23207 | 215 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 125220 | 125220 | PRJEB58983_P_NODE_8721_length_421_cov_2.635057_g8307_i0 | PRJEB58983 | 8721 | 421 | 2.635057 | 11.09358997 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 761 | 0 | NTclustered | gi|698793876|ref|XR_717098.1| | 112090 | g8307 | i0 | 99.287 | 101.232779097387 | 421 | 3 | 100 | 0 | 1 | 421 | 2109 | 2529 | Aphanomyces astaci 28S ribosomal RNA rRNA | blastn | 42619 | 761 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 2267340 | 2267340 | PRJEB58983_P_NODE_19082_length_295_cov_3.666667_g18667_i0 | PRJEB58983 | 19082 | 295 | 3.666667 | 10.81666765 | Verrucalvaceae | 120409 | SAR_Eukaryotes | SAR_Eukaryotes | 540 | 4.79e-149 | NTclustered | gi|319769384|gb|HQ343196.1| | 112092 | g18667 | i0 | 99.661 | 99.664406779661 | 295 | 1 | 100 | 0 | 1 | 295 | 917 | 623 | Aphanomyces laevis strain CBS 127282 18S ribosomal RNA gene, partial sequence | blastn | 29401 | 545 | 0.990825688073395 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces laevis | ||
| 2674873 | 2674873 | PRJEB58983_P_NODE_19843_length_291_cov_1.073394_g19428_i0 | PRJEB58983 | 19843 | 291 | 1.073394 | 3.12357654 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 3.78e-125 | NTclustered | gi|166042839|emb|CU353349.1| | 100861 | g19428 | i0 | 95.189 | 13.2749140893471 | 291 | 14 | 100 | 0 | 1 | 291 | 747 | 457 | Aphanomyces euteiches cDNA | blastn | 3863 | 460 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 3950876 | 3950876 | PRJEB58983_P_NODE_19204_length_295_cov_1.000000_g18789_i0 | PRJEB58983 | 19204 | 295 | 1 | 2.95 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 224 | 5.48e-54 | NTclustered | gi|675169410|ref|XM_008895342.1| | 761204 | g18789 | i0 | 81.852 | 54.7898305084746 | 270 | 46 | 91 | 2 | 29 | 295 | 303 | 572 | Phytophthora parasitica INRA-310 adenosylhomocysteinase mRNA | blastn | 16163 | 224 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 3951197 | 3951197 | PRJEB58983_P_NODE_35404_length_204_cov_9.816794_g34989_i0 | PRJEB58983 | 35404 | 204 | 9.816794 | 20.02625976 | Saprolegnia parasitica | 101203 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.7399999999999997e-60 | NTclustered | gi|813199067|ref|XR_001099866.1| | 695850 | g34989 | i0 | 88.35 | 39.4019607843137 | 206 | 20 | 100 | 4 | 1 | 204 | 1483 | 1686 | Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA | blastn | 8038 | 244 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 11603072 | 11603072 | PRJEB58983_P_NODE_11890_length_365_cov_2.386986_g11475_i0 | PRJEB58983 | 11890 | 365 | 2.386986 | 8.7124989 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 2.48e-58 | NTclustered | gi|675211346|ref|XM_008916310.1| | 761204 | g11475 | i0 | 81.293 | 24.0219178082192 | 294 | 55 | 81 | 0 | 7 | 300 | 134 | 427 | Phytophthora parasitica INRA-310 60S ribosomal protein L44 mRNA | blastn | 8768 | 239 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 12471127 | 12471127 | PRJEB58983_P_NODE_33430_length_235_cov_3.746914_g33015_i0 | PRJEB58983 | 33430 | 235 | 3.746914 | 8.8052479 | root | 1 | Root_unresolved | Root_unresolved | 401 | 1.8199999999999993e-107 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g33015 | i0 | 97.447 | 104.714893617021 | 235 | 6 | 100 | 0 | 1 | 235 | 7451 | 7685 | Saprolegnia ferax mitochondrion, complete genome | blastn | 24608 | 401 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 12878368 | 12878368 | PRJEB58983_P_NODE_1791_length_953_cov_6.560227_g1458_i0 | PRJEB58983 | 1791 | 953 | 6.560227 | 62.51896331 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 1585 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g1458 | i0 | 96.66 | 106.964323189927 | 958 | 25 | 100 | 7 | 1 | 953 | 1872 | 2827 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 101937 | 1585 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 12878402 | 12878402 | PRJEB58983_P_NODE_19231_length_294_cov_3.389140_g18816_i0 | PRJEB58983 | 19231 | 294 | 3.38914 | 9.9640716 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.7499999999999996e-133 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g18816 | i0 | 96.622 | 109.894557823129 | 296 | 6 | 99 | 2 | 2 | 294 | 6227 | 5933 | Achlya hypogyna mitochondrion, complete genome | blastn | 32309 | 488 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 12878892 | 12878892 | PRJEB58983_P_NODE_9551_length_403_cov_9.754545_g9137_i0 | PRJEB58983 | 9551 | 403 | 9.754545 | 39.31081635 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 745 | 0 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g9137 | i0 | 100 | 99.985111662531 | 403 | 0 | 100 | 0 | 1 | 403 | 573 | 171 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 40294 | 745 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 15427161 | 15427161 | PRJEB58983_P_NODE_17393_length_308_cov_2.629787_g16978_i0 | PRJEB58983 | 17393 | 308 | 2.629787 | 8.09974396 | Saprolegnia ferax | 4770 | SAR_Eukaryotes | SAR_Eukaryotes | 473 | 5.179999999999999e-129 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g16978 | i0 | 94.481 | 107.282467532468 | 308 | 15 | 100 | 2 | 1 | 308 | 10630 | 10935 | Saprolegnia ferax mitochondrion, complete genome | blastn | 33043 | 473 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 17976829 | 17976829 | PRJEB58983_P_NODE_8975_length_415_cov_3.163743_g8561_i0 | PRJEB58983 | 8975 | 415 | 3.163743 | 13.12953345 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 6.31e-40 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g8561 | i0 | 79.505 | 38.0120481927711 | 283 | 33 | 63 | 13 | 149 | 406 | 8370 | 8088 | Achlya hypogyna mitochondrion, complete genome | blastn | 15775 | 178 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 23076913 | 23076913 | PRJEB58983_P_NODE_22699_length_276_cov_1.167488_g22284_i0 | PRJEB58983 | 22699 | 276 | 1.167488 | 3.22226688 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 8.56e-47 | NTclustered | gi|675196130|ref|XM_008908702.1| | 761204 | g22284 | i0 | 81.667 | 65.9094202898551 | 240 | 44 | 87 | 0 | 3 | 242 | 676 | 437 | Phytophthora parasitica INRA-310 hypothetical protein mRNA | blastn | 18191 | 200 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 23077051 | 23077051 | PRJEB58983_P_NODE_29899_length_248_cov_0.891429_g29484_i0 | PRJEB58983 | 29899 | 248 | 0.891429 | 2.21074392 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 204 | 5.849999999999999e-48 | NTclustered | gi|695460286|ref|XM_009539659.1| | 67593 | g29484 | i0 | 81.452 | 72.875 | 248 | 46 | 100 | 0 | 1 | 248 | 2693 | 2940 | Phytophthora sojae putative ATPase mRNA | blastn | 18073 | 204 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 23077118 | 23077118 | PRJEB58983_P_NODE_33019_length_238_cov_2.860606_g32604_i0 | PRJEB58983 | 33019 | 238 | 2.860606 | 6.80824228 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 3.899999999999999e-119 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g32604 | i0 | 100 | 98.2436974789916 | 238 | 0 | 100 | 0 | 1 | 238 | 274 | 37 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 23382 | 440 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 23077151 | 23077151 | PRJEB58983_P_NODE_35079_length_214_cov_18.326241_g34664_i0 | PRJEB58983 | 35079 | 214 | 18.326241 | 39.21815574 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 7.559999999999996e-106 | NTclustered | gi|1186441155|gb|KY989960.1| | 1982524 | g34664 | i0 | 100 | 98.373831775700907 | 214 | 0 | 100 | 0 | 1 | 214 | 425 | 212 | Aphanomyces sp. isolate CNUaq small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 21052 | 396 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. |
Advanced export
JSON shape: default, array, newline-delimited
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);;