contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 192499 | 192499 | PRJNA1078753_P_NODE_2361_length_646_cov_4.677138_g2172_i0 | PRJNA1078753 | 2361 | 646 | 4.677138 | 30.21431148 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 244 | 9.87e-60 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g2172 | i0 | 81.911 | 23.8219814241486 | 293 | 50 | 45 | 3 | 169 | 460 | 471 | 181 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 15389 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 5295387 | 5295387 | PRJNA1078753_P_NODE_33425_length_247_cov_0.885057_g33229_i0 | PRJNA1078753 | 33425 | 247 | 0.885057 | 2.18609079 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 261 | 3.41e-65 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g33229 | i0 | 86.555 | 93.6518218623482 | 238 | 30 | 96 | 2 | 1 | 237 | 53 | 289 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 23132 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6570383 | 6570383 | PRJNA1078753_P_NODE_13106_length_322_cov_2.457831_g12910_i0 | PRJNA1078753 | 13106 | 322 | 2.457831 | 7.91421582 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 265 | 3.57e-66 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g12910 | i0 | 85.887 | 52.6459627329193 | 248 | 35 | 77 | 0 | 12 | 259 | 289 | 42 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 16952 | 265 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6570416 | 6570416 | PRJNA1078753_P_NODE_17466_length_289_cov_1.425926_g17270_i0 | PRJNA1078753 | 17466 | 289 | 1.425926 | 4.12092614 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 189 | 1.95e-43 | NTclustered | gi|1026973001|ref|XM_016751749.1| | 645134 | g17270 | i0 | 79.401 | 16.6020761245675 | 267 | 55 | 92 | 0 | 17 | 283 | 54 | 320 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L8 (SPPG_03486), mRNA | blastn | 4798 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 10395757 | 10395757 | PRJNA1078753_P_NODE_15049_length_306_cov_1.828326_g14853_i0 | PRJNA1078753 | 15049 | 306 | 1.828326 | 5.59467756 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 241 | 5.67e-59 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g14853 | i0 | 81.046 | 46.562091503268 | 306 | 54 | 99 | 4 | 1 | 304 | 46 | 349 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 14248 | 241 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14221431 | 14221431 | PRJNA1078753_P_NODE_5332_length_457_cov_1.151042_g5136_i0 | PRJNA1078753 | 5332 | 457 | 1.151042 | 5.26026194 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 220 | 1.15e-52 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g5136 | i0 | 86.802 | 47.9365426695842 | 197 | 26 | 43 | 0 | 261 | 457 | 798 | 602 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 21907 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 15495266 | 15495266 | PRJNA1078753_P_NODE_3693_length_531_cov_1.840611_g3499_i0 | PRJNA1078753 | 3693 | 531 | 1.840611 | 9.77364441 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 374 | 9.789999999999997e-99 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g3499 | i0 | 80.435 | 74.5875706214689 | 506 | 85 | 94 | 12 | 15 | 513 | 539 | 41 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 39606 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 15495350 | 15495350 | PRJNA1078753_P_NODE_6453_length_422_cov_1.114613_g6257_i0 | PRJNA1078753 | 6453 | 422 | 1.114613 | 4.70366686 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 126 | 2.36e-24 | NTclustered | gi|575480991|ref|XM_006679727.1| | 684364 | g6257 | i0 | 81.699 | 0.855450236966825 | 153 | 26 | 36 | 2 | 227 | 378 | 176 | 25 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_12294), partial mRNA | blastn | 361 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 20593534 | 20593534 | PRJNA1078753_P_NODE_17617_length_288_cov_2.865116_g17421_i0 | PRJNA1078753 | 17617 | 288 | 2.865116 | 8.25153408 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 126 | 1.5499999999999998e-24 | NTclustered | gi|2432131643|ref|XM_053113105.1| | 110093 | g17421 | i0 | 80.723 | 24.9409722222222 | 166 | 28 | 57 | 3 | 12 | 175 | 302 | 139 | Polychytrium aggregatum 40S ribosomal protein S2 (BJ171DRAFT_557656), partial mRNA | blastn | 7183 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24418341 | 24418341 | PRJNA1078753_P_NODE_13440_length_319_cov_1.878049_g13244_i0 | PRJNA1078753 | 13440 | 319 | 1.878049 | 5.99097631 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 145 | 4.8e-30 | NTclustered | gi|2432062176|ref|XM_053067666.1| | 1396493 | g13244 | i0 | 81.215 | 0.959247648902821 | 181 | 32 | 56 | 2 | 101 | 280 | 55 | 234 | Fimicolochytrium jonesii ribosomal protein S19e (EV422DRAFT_493303), partial mRNA | blastn | 306 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 24418444 | 24418444 | PRJNA1078753_P_NODE_26240_length_253_cov_1.711111_g26044_i0 | PRJNA1078753 | 26240 | 253 | 1.711111 | 4.32911083 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 165 | 2.83e-36 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g26044 | i0 | 79.911 | 28.0790513833992 | 224 | 45 | 89 | 0 | 20 | 243 | 344 | 567 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 7104 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;