contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA437204" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2983927 | 2983927 | PRJNA437204_P_NODE_74783_length_258_cov_1.243243_g74484_i0 | PRJNA437204 | 74783 | 258 | 1.243243 | 3.20756694 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 152 | 2.2499999999999995e-32 | NTclustered | gi|1026972419|ref|XM_016751697.1| | 645134 | g74484 | i0 | 85.135 | 4.3875968992248104 | 148 | 22 | 57 | 0 | 10 | 157 | 97 | 244 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein (SPPG_03431), mRNA | blastn | 1132 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus | |
| 5536017 | 5536017 | PRJNA437204_P_NODE_27205_length_368_cov_8.054237_g26906_i0 | PRJNA437204 | 27205 | 368 | 8.054237 | 29.63959216 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 150 | 1.2099999999999999e-31 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g26906 | i0 | 79.439 | 41.6032608695652 | 214 | 42 | 58 | 2 | 100 | 312 | 276 | 64 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 15310 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8085321 | 8085321 | PRJNA437204_P_NODE_14667_length_463_cov_2.317949_g14368_i0 | PRJNA437204 | 14667 | 463 | 2.317949 | 10.73210387 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 7.26e-25 | NTclustered | gi|2432097581|ref|XM_053071233.1| | 1396493 | g14368 | i0 | 82.313 | 4.21166306695464 | 147 | 26 | 32 | 0 | 273 | 419 | 229 | 83 | Fimicolochytrium jonesii 30S ribosomal protein S30e (EV422DRAFT_541825), mRNA | blastn | 1950 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 10635926 | 10635926 | PRJNA437204_P_NODE_129989_length_227_cov_2.298701_g129690_i0 | PRJNA437204 | 129989 | 227 | 2.298701 | 5.21805127 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 161 | 3.22e-35 | NTclustered | gi|575484485|ref|XM_006681474.1| | 684364 | g129690 | i0 | 86.806 | 3.6784140969163 | 144 | 19 | 63 | 0 | 70 | 213 | 198 | 55 | Batrachochytrium dendrobatidis JAM81 ribosomal 60S subunit protein L39 (BATDEDRAFT_91214), partial mRNA | blastn | 835 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 14460839 | 14460839 | PRJNA437204_P_NODE_13952_length_472_cov_1.385965_g13653_i0 | PRJNA437204 | 13952 | 472 | 1.385965 | 6.5417548 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 261 | 7.01e-65 | NTclustered | gi|2432132805|ref|XM_053109589.1| | 110093 | g13653 | i0 | 78.313 | 15.1419491525424 | 415 | 82 | 87 | 5 | 2 | 412 | 559 | 149 | Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_490208), mRNA | blastn | 7147 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20834014 | 20834014 | PRJNA437204_P_NODE_28917_length_361_cov_1.336806_g28618_i0 | PRJNA437204 | 28917 | 361 | 1.336806 | 4.82586966 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 377 | 4.97e-100 | NTclustered | gi|2432052758|ref|XM_053073165.1| | 1396493 | g28618 | i0 | 89.109 | 83.6592797783934 | 303 | 33 | 84 | 0 | 55 | 357 | 415 | 113 | Fimicolochytrium jonesii ribosomal protein S12 (EV422DRAFT_572964), partial mRNA | blastn | 30201 | 377 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 22109315 | 22109315 | PRJNA437204_P_NODE_47798_length_305_cov_1.461207_g47499_i0 | PRJNA437204 | 47798 | 305 | 1.461207 | 4.45668135 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 185 | 2.6899999999999998e-42 | NTclustered | gi|2432132239|ref|XM_053109464.1| | 110093 | g47499 | i0 | 80.478 | 5.2655737704918 | 251 | 41 | 81 | 7 | 46 | 292 | 560 | 314 | Polychytrium aggregatum ribosomal protein S17-domain-containing protein (BJ171DRAFT_489270), mRNA | blastn | 1606 | 185 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23384682 | 23384682 | PRJNA437204_P_NODE_36419_length_334_cov_2.950192_g36120_i0 | PRJNA437204 | 36419 | 334 | 2.950192 | 9.85364128 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 169 | 3e-37 | NTclustered | gi|2432169762|ref|XM_053112442.1| | 110093 | g36120 | i0 | 85.987 | 28.8443113772455 | 157 | 22 | 47 | 0 | 12 | 168 | 77 | 233 | Polychytrium aggregatum 60S ribosomal protein L39 (BJ171DRAFT_520507), mRNA | blastn | 9634 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;