contig_metadata
9 rows where bioproject = "PRJNA784298", tax_clade = "Sar" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4593776 | 4593776 | PRJNA784298_P_NODE_9904_length_399_cov_2.671779_g9703_i0 | PRJNA784298 | 9904 | 399 | 2.671779 | 10.66039821 | Achlya hypogyna | 1202772 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|542687346|ref|NC_022178.1| | 1202772 | g9703 | i0 | 97.264 | 108.666666666667 | 402 | 7 | 100 | 2 | 1 | 399 | 6323 | 5923 | Achlya hypogyna mitochondrion, complete genome | blastn | 43358 | 678 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Achlyaceae | Achlya | Achlya hypogyna | ||
| 6317133 | 6317133 | PRJNA784298_P_NODE_11425_length_370_cov_25.771044_g11224_i0 | PRJNA784298 | 11425 | 370 | 25.771044 | 95.3528628 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 678 | 0 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g11224 | i0 | 99.73 | 99.9108108108108 | 370 | 1 | 100 | 0 | 1 | 370 | 720 | 351 | 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 | 36967 | 684 | 0.991228070175439 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 10141865 | 10141865 | PRJNA784298_P_NODE_25868_length_244_cov_0.900585_g25667_i0 | PRJNA784298 | 25868 | 244 | 0.900585 | 2.1974274 | Saprolegnia | 4769 | SAR_Eukaryotes | SAR_Eukaryotes | 335 | 1.9499999999999992e-87 | NTclustered | gi|1770647996|gb|MK941864.1| | 101203 | g25667 | i0 | 91.393 | 85.0901639344262 | 244 | 21 | 100 | 0 | 1 | 244 | 33 | 276 | Saprolegnia parasitica isolate S2 cytochrome c oxidase subunit II (Cox2) gene, partial cds; mitochondrial | blastn | 20762 | 335 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia parasitica | ||
| 12244856 | 12244856 | PRJNA784298_P_NODE_14390_length_328_cov_3.890196_g14189_i0 | PRJNA784298 | 14390 | 328 | 3.890196 | 12.75984288 | Wilsoniana portulacae | 572137 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.249999999999998e-169 | NTclustered | gi|210164195|gb|EU826120.1| | 572137 | g14189 | i0 | 100 | 18.7560975609756 | 328 | 0 | 100 | 0 | 1 | 328 | 344 | 671 | Wilsoniana portulacae strain HUH 640 large subunit ribosomal RNA gene, partial sequence | blastn | 6152 | 606 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Wilsoniana | Wilsoniana portulacae | ||
| 12245079 | 12245079 | PRJNA784298_P_NODE_910_length_1362_cov_10.416602_g798_i0 | PRJNA784298 | 910 | 1362 | 10.416602 | 141.87411924 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 2169 | 0 | NTclustered | gi|1111669722|ref|NC_032051.1| | 112090 | g798 | i0 | 95.401 | 107.412628487518 | 1370 | 49 | 100 | 14 | 1 | 1362 | 3075 | 1712 | Aphanomyces astaci isolate AP03 mitochondrion, complete genome | blastn | 146296 | 2169 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 13519255 | 13519255 | PRJNA784298_P_NODE_6391_length_501_cov_2.593458_g6191_i0 | PRJNA784298 | 6391 | 501 | 2.593458 | 12.99322458 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 926 | 0 | NTclustered | gi|1186441155|gb|KY989960.1| | 1982524 | g6191 | i0 | 100 | 99.3872255489022 | 501 | 0 | 100 | 0 | 1 | 501 | 211 | 711 | 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 | 49793 | 926 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 16516189 | 16516189 | PRJNA784298_P_NODE_25953_length_243_cov_22.511765_g25752_i0 | PRJNA784298 | 25953 | 243 | 22.511765 | 54.70358895 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 429 | 8.66e-116 | NTclustered | gi|166048041|emb|CU364162.1| | 100861 | g25752 | i0 | 99.16 | 88.6954732510288 | 238 | 2 | 98 | 0 | 1 | 238 | 402 | 165 | Aphanomyces euteiches cDNA | blastn | 21553 | 433 | 0.990762124711316 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 18616943 | 18616943 | PRJNA784298_P_NODE_24615_length_248_cov_0.880000_g24414_i0 | PRJNA784298 | 24615 | 248 | 0.88 | 2.1824 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.13e-124 | NTclustered | gi|166046598|emb|CU367715.1| | 100861 | g24414 | i0 | 100 | 99.7620967741936 | 248 | 0 | 100 | 0 | 1 | 248 | 126 | 373 | Aphanomyces euteiches cDNA | blastn | 24741 | 459 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 19892216 | 19892216 | PRJNA784298_P_NODE_25496_length_245_cov_0.895349_g25295_i0 | PRJNA784298 | 25496 | 245 | 0.895349 | 2.19360505 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 5.38e-98 | NTclustered | gi|673039884|ref|XM_008875681.1| | 157072 | g25295 | i0 | 93.878 | 47.269387755102 | 245 | 15 | 100 | 0 | 1 | 245 | 266 | 510 | Aphanomyces invadans 60S ribosomal protein mRNA | blastn | 11581 | 370 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;