contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2258468 | 2258468 | PRJEB11748_P_NODE_172502_length_309_cov_10.157258_g170319_i0 | PRJEB11748 | 172502 | 309 | 10.157258 | 31.38592722 | Eukaryota | 2759 | Fungi | Fungi | 516 | 8.51e-142 | NTclustered | gi|2165384402|gb|OL869113.1| | 2020344 | g170319 | i0 | 96.774 | 100.802588996764 | 310 | 8 | 100 | 2 | 1 | 309 | 66 | 374 | Uncultured Lobulomycetales isolate Fragilaria-MDA25 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 | 31148 | 521 | 0.990403071017274 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Lobulomycetales | uncultured Lobulomycetales | |||
| 6087089 | 6087089 | PRJEB11748_P_NODE_265065_length_238_cov_1.745763_g262882_i0 | PRJEB11748 | 265065 | 238 | 1.745763 | 4.15491594 | Rhizophydium | 60186 | Fungi | Fungi | 156 | 1.58e-33 | NTclustered | gi|82398246|gb|DQ273781.1| | 109902 | g262882 | i0 | 80.717 | 53.1512605042017 | 223 | 23 | 89 | 14 | 1 | 213 | 1785 | 1997 | Rhizophydium sphaerotheca isolate AFTOL-ID 37 28S ribosomal RNA gene, partial sequence | blastn | 12650 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiaceae | Rhizophydium | Rhizophydium sphaerotheca | |
| 6394499 | 6394499 | PRJEB11748_P_NODE_225486_length_263_cov_7.420792_g223303_i0 | PRJEB11748 | 225486 | 263 | 7.420792 | 19.51668296 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 206 | 1.74e-48 | NTclustered | gi|1027005164|ref|XM_016754649.1| | 645134 | g223303 | i0 | 88.824 | 34.787072243346 | 170 | 15 | 64 | 4 | 23 | 190 | 293 | 460 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L44 (SPPG_06444), mRNA | blastn | 9149 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 7361322 | 7361322 | PRJEB11748_P_NODE_220086_length_267_cov_6.737864_g217903_i0 | PRJEB11748 | 220086 | 267 | 6.737864 | 17.99009688 | Spizellomyces | 4815 | Fungi | Fungi | 91.6 | 5.18e-14 | NTclustered | gi|15147293|ref|NC_003052.1| | 109760 | g217903 | i0 | 74.249 | 1.74531835205993 | 233 | 53 | 86 | 6 | 15 | 243 | 924 | 695 | Spizellomyces punctatus mitochondrion chromosome 1, complete sequence | blastn | 466 | 91.6 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 7670681 | 7670681 | PRJEB11748_P_NODE_342347_length_201_cov_11.050000_g340164_i0 | PRJEB11748 | 342347 | 201 | 11.05 | 22.2105 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 113 | 7.910000000000001e-21 | NTclustered | gi|2432131875|ref|XM_053109384.1| | 110093 | g340164 | i0 | 97.015 | 3.78606965174129 | 67 | 2 | 33 | 0 | 23 | 89 | 360 | 426 | Polychytrium aggregatum 40S ribosomal protein S20 (BJ171DRAFT_488555), mRNA | blastn | 761 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8637725 | 8637725 | PRJEB11748_P_NODE_356727_length_194_cov_5.263158_g354544_i0 | PRJEB11748 | 356727 | 194 | 5.263158 | 10.21052652 | Fungi | 4751 | Fungi | Fungi | 313 | 6.96e-81 | NTclustered | gi|290874455|gb|GQ160454.1| | 64517 | g354544 | i0 | 99.419 | 88.639175257732 | 172 | 1 | 89 | 0 | 1 | 172 | 827 | 656 | Rhizophlyctis rosea isolate BR 109 18S ribosomal RNA gene, partial sequence | blastn | 17196 | 313 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophlyctidales | Rhizophlyctidaceae | Rhizophlyctis | Rhizophlyctis rosea | |
| 11187409 | 11187409 | PRJEB11748_P_NODE_283629_length_227_cov_29.385542_g281446_i0 | PRJEB11748 | 283629 | 227 | 29.385542 | 66.70518034 | Kochiomyces | 117816 | Fungi | Fungi | 342 | 1.07e-89 | NTclustered | gi|1866582533|gb|MT730708.1| | 117817 | g281446 | i0 | 96.618 | 91.0308370044053 | 207 | 5 | 91 | 2 | 22 | 227 | 2660 | 2865 | Kochiomyces dichotomus isolate JEL0371 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 | 20664 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Kochiomyces | Kochiomyces dichotomus | |
| 11493398 | 11493398 | PRJEB11748_P_NODE_176030_length_306_cov_1.804082_g173847_i0 | PRJEB11748 | 176030 | 306 | 1.804082 | 5.52049092 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 211 | 4.45e-50 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g173847 | i0 | 80.139 | 1.86928104575163 | 287 | 54 | 93 | 3 | 1 | 285 | 497 | 212 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 572 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 15011231 | 15011231 | PRJEB11748_P_NODE_190452_length_292_cov_3.593074_g188269_i0 | PRJEB11748 | 190452 | 292 | 3.593074 | 10.49177608 | Powellomycetaceae | 1134080 | Fungi | Fungi | 481 | 2.91e-131 | NTclustered | gi|1866582454|gb|MT730629.1| | 109894 | g188269 | i0 | 98.529 | 93.1643835616438 | 272 | 4 | 93 | 0 | 1 | 272 | 4521 | 4250 | Geranomyces variabilis isolate Barr350 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 | 27204 | 481 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 15012610 | 15012610 | PRJEB11748_P_NODE_380752_length_179_cov_4.601695_g378569_i0 | PRJEB11748 | 380752 | 179 | 4.601695 | 8.23703405 | Spizellomyces | 4815 | Fungi | Fungi | 202 | 1.42e-47 | NTclustered | gi|15147293|ref|NC_003052.1| | 109760 | g378569 | i0 | 96.694 | 2.05586592178771 | 121 | 4 | 68 | 0 | 2 | 122 | 367 | 247 | Spizellomyces punctatus mitochondrion chromosome 1, complete sequence | blastn | 368 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 15317025 | 15317025 | PRJEB11748_P_NODE_146013_length_340_cov_6.469534_g143832_i0 | PRJEB11748 | 146013 | 340 | 6.469534 | 21.9964156 | Chytriomycetaceae sp. | 2012318 | Fungi | Fungi | 95.3 | 5.26e-15 | NTclustered | gi|2468791126|gb|OQ702950.1| | 2012318 | g143832 | i0 | 87.356 | 25.8323529411765 | 87 | 6 | 25 | 4 | 255 | 340 | 4393 | 4475 | Chytriomycetaceae sp. isolate PSC309 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 | 8783 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Chytriomycetaceae sp. | ||
| 15317676 | 15317676 | PRJEB11748_P_NODE_176293_length_305_cov_12.881148_g174110_i0 | PRJEB11748 | 176293 | 305 | 12.881148 | 39.2875014 | Rhizophydiales sp. | 2011922 | Fungi | Fungi | 106 | 2.15e-18 | NTclustered | gi|2468791078|gb|OQ702937.1| | 2011922 | g174110 | i0 | 80.255 | 2.72131147540984 | 157 | 17 | 51 | 6 | 25 | 180 | 656 | 799 | Rhizophydiales sp. isolate PSC285 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 | 830 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiales sp. | |||
| 16287385 | 16287385 | PRJEB11748_P_NODE_374113_length_184_cov_6.162602_g371930_i0 | PRJEB11748 | 374113 | 184 | 6.162602 | 11.33918768 | Spizellomyces | 4815 | Fungi | Fungi | 169 | 1.4899999999999998e-37 | NTclustered | gi|15147293|ref|NC_003052.1| | 109760 | g371930 | i0 | 86.503 | 2.55978260869565 | 163 | 11 | 89 | 2 | 1 | 163 | 1725 | 1574 | Spizellomyces punctatus mitochondrion chromosome 1, complete sequence | blastn | 471 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 24239861 | 24239861 | PRJEB11748_P_NODE_106460_length_404_cov_4.510204_g104286_i0 | PRJEB11748 | 106460 | 404 | 4.510204 | 18.22122416 | Powellomyces hirtus | 109895 | Fungi | Fungi | 226 | 2.1599999999999995e-54 | NTclustered | gi|1652151735|gb|MK292694.1| | 109895 | g104286 | i0 | 89.071 | 0.829207920792079 | 183 | 18 | 82 | 2 | 223 | 404 | 99260 | 99441 | Powellomyces hirtus strain CBS 809.83 mitochondrion | blastn | 335 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus | |
| 24243083 | 24243083 | PRJEB11748_P_NODE_271500_length_234_cov_3.352601_g269317_i0 | PRJEB11748 | 271500 | 234 | 3.352601 | 7.84508634 | Powellomyces hirtus | 109895 | Fungi | Fungi | 342 | 1.11e-89 | NTclustered | gi|1652151693|gb|MK292693.1| | 109895 | g269317 | i0 | 93.22 | 2.92735042735043 | 236 | 11 | 99 | 4 | 1 | 231 | 66116 | 66351 | Powellomyces hirtus strain CBS 809.83 mitochondrion | blastn | 685 | 342 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Powellomyces | Powellomyces hirtus |
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);;