contig_metadata
13 rows where bioproject = "PRJNA1255065", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1635288 | 1635288 | PRJNA1255065_P_NODE_68062_length_224_cov_0.965714_g65834_i0 | PRJNA1255065 | 68062 | 224 | 0.965714 | 2.16319936 | Pythium chondricola | 289597 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 6.169999999999998e-107 | NTclustered | gi|51235474|gb|AY598620.1| | 289597 | g65834 | i0 | 98.661 | 99.7857142857143 | 224 | 3 | 100 | 0 | 1 | 224 | 2135 | 1912 | Pythium chondricola strain CBS 203.85 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 | 22352 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium chondricola | ||
| 4880994 | 4880994 | PRJNA1255065_P_NODE_101224_length_173_cov_1.153226_g98996_i0 | PRJNA1255065 | 101224 | 173 | 1.153226 | 1.99508098 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 7.81e-80 | NTclustered | gi|1923460172|gb|MW187638.1| | 1125843 | g98996 | i0 | 98.844 | 99.635838150289 | 173 | 2 | 100 | 0 | 1 | 173 | 282 | 454 | Aphanomyces sinensis isolate CCRJB_22 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 17237 | 309 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sinensis | ||
| 6156387 | 6156387 | PRJNA1255065_P_NODE_96325_length_178_cov_1.565891_g94097_i0 | PRJNA1255065 | 96325 | 178 | 1.565891 | 2.78728598 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.21e-86 | NTclustered | gi|2832795190|gb|PQ465262.1| | 88834 | g94097 | i0 | 100 | 95.0730337078652 | 178 | 0 | 100 | 0 | 1 | 178 | 3120 | 3297 | Pythium porphyrae isolate Bangia fuscopurpurea 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 | 16923 | 329 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium porphyrae | ||
| 12532227 | 12532227 | PRJNA1255065_P_NODE_86950_length_190_cov_1.460993_g84722_i0 | PRJNA1255065 | 86950 | 190 | 1.460993 | 2.7758867 | Pythium | 4797 | SAR_Eukaryotes | SAR_Eukaryotes | 344 | 2.3999999999999993e-90 | NTclustered | gi|2832795190|gb|PQ465262.1| | 88834 | g84722 | i0 | 99.471 | 99.4631578947368 | 189 | 1 | 99 | 0 | 2 | 190 | 2913 | 3101 | Pythium porphyrae isolate Bangia fuscopurpurea 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 | 18898 | 346 | 0.994219653179191 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium porphyrae | ||
| 15663366 | 15663366 | PRJNA1255065_P_NODE_59813_length_247_cov_3.146465_g57585_i0 | PRJNA1255065 | 59813 | 247 | 3.146465 | 7.77176855 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 418 | 1.9099999999999998e-112 | NTclustered | gi|166044475|emb|CU367384.1| | 100861 | g57585 | i0 | 97.166 | 40 | 247 | 7 | 100 | 0 | 1 | 247 | 380 | 626 | Aphanomyces euteiches cDNA | blastn | 9880 | 418 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 16936998 | 16936998 | PRJNA1255065_P_NODE_101514_length_172_cov_2.113821_g99286_i0 | PRJNA1255065 | 101514 | 172 | 2.113821 | 3.63577212 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 1.32e-67 | NTclustered | gi|166044613|emb|CU367522.1| | 100861 | g99286 | i0 | 94.767 | 111.220930232558 | 172 | 9 | 100 | 0 | 1 | 172 | 198 | 369 | Aphanomyces euteiches cDNA | blastn | 19130 | 268 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 17631124 | 17631124 | PRJNA1255065_P_NODE_63854_length_234_cov_3.281081_g61626_i0 | PRJNA1255065 | 63854 | 234 | 3.281081 | 7.67772954 | root | 1 | Root_unresolved | Root_unresolved | 361 | 3.0699999999999996e-95 | NTclustered | gi|166044612|emb|CU367521.1| | 100861 | g61626 | i0 | 94.444 | 90.1495726495726 | 234 | 13 | 100 | 0 | 1 | 234 | 50 | 283 | Aphanomyces euteiches cDNA | blastn | 21095 | 361 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 23312561 | 23312561 | PRJNA1255065_P_NODE_47899_length_301_cov_2.456349_g45673_i0 | PRJNA1255065 | 47899 | 301 | 2.456349 | 7.39361049 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 440 | 5.119999999999999e-119 | NTclustered | gi|166044524|emb|CU367433.1| | 100861 | g45673 | i0 | 93.023 | 94.8073089700997 | 301 | 21 | 100 | 0 | 1 | 301 | 476 | 776 | Aphanomyces euteiches cDNA | blastn | 28537 | 440 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24005273 | 24005273 | PRJNA1255065_P_NODE_39219_length_361_cov_1.891026_g36998_i0 | PRJNA1255065 | 39219 | 361 | 1.891026 | 6.82660386 | root | 1 | Root_unresolved | Root_unresolved | 553 | 7.699999999999998e-153 | NTclustered | gi|166044644|emb|CU367553.1| | 100861 | g36998 | i0 | 94.663 | 57.2382271468144 | 356 | 19 | 99 | 0 | 1 | 356 | 356 | 1 | Aphanomyces euteiches cDNA | blastn | 20663 | 556 | 0.994604316546763 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24005374 | 24005374 | PRJNA1255065_P_NODE_59079_length_250_cov_1.293532_g56851_i0 | PRJNA1255065 | 59079 | 250 | 1.293532 | 3.23383 | root | 1 | Root_unresolved | Root_unresolved | 296 | 9.47e-76 | NTclustered | gi|166046524|emb|CU367641.1| | 100861 | g56851 | i0 | 88 | 45.408 | 250 | 30 | 100 | 0 | 1 | 250 | 201 | 450 | Aphanomyces euteiches cDNA | blastn | 11352 | 296 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 24586087 | 24586087 | PRJNA1255065_P_NODE_109700_length_169_cov_0.858333_g107472_i0 | PRJNA1255065 | 109700 | 169 | 0.858333 | 1.45058277 | Paralagenidium karlingii | 1440115 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 2.26e-30 | NTclustered | gi|2554484921|ref|NC_080886.1| | 1440115 | g107472 | i0 | 90.179 | 60.6331360946746 | 112 | 9 | 66 | 2 | 13 | 123 | 41766 | 41656 | Paralagenidium karlingii isolate 19-09020 mitochondrion, complete genome | blastn | 10247 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Paralagenidium | Paralagenidium karlingii | ||||
| 27042221 | 27042221 | PRJNA1255065_P_NODE_132802_length_165_cov_0.896552_g130574_i0 | PRJNA1255065 | 132802 | 165 | 0.896552 | 1.4793108 | Pythium oligandrum | 41045 | SAR_Eukaryotes | SAR_Eukaryotes | 49.7 | 4.73e-5 | NR | TMW59608.1 | 41045 | g130574 | i0 | 42.9 | 1.87272727272727 | 49 | 28 | 89.1 | 0 | 4 | 150 | 239 | 287 | TMW59608.1 hypothetical protein Poli38472_004677 [Pythium oligandrum] | diamond | 309 | 49.7 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium oligandrum | ||
| 31893339 | 31893339 | PRJNA1255065_P_NODE_134137_length_165_cov_0.879310_g131909_i0 | PRJNA1255065 | 134137 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.5 | 3.21e-8 | NR | CCI49143.1 | 65357 | g131909 | i0 | 45.3 | 5.78181818181818 | 53 | 29 | 96.4 | 0 | 161 | 3 | 290 | 342 | CCI49143.1 unnamed protein product [Albugo candida] | diamond | 954 | 58.5 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo candida |
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);;