contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA758088" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2015140 | 2015140 | PRJNA758088_P_NODE_83062_length_464_cov_1.792839_g76093_i0 | PRJNA758088 | 83062 | 464 | 1.792839 | 8.31877296 | Dendrochytridium crassum | 1352835 | Fungi | Fungi | 195 | 7.079999999999999e-45 | NTclustered | gi|82398285|gb|DQ273785.1| | 1352835 | g76093 | i0 | 88.485 | 27.1099137931034 | 165 | 14 | 35 | 5 | 236 | 398 | 1848 | 2009 | Dendrochytridium crassum isolate AFTOL-ID 41 28S ribosomal RNA gene, partial sequence | blastn | 12579 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiaceae | Dendrochytridium | Dendrochytridium crassum | |
| 2015345 | 2015345 | PRJNA758088_P_NODE_93722_length_434_cov_7.562327_g86752_i0 | PRJNA758088 | 93722 | 434 | 7.562327 | 32.82049918 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 268 | 3.82e-67 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g86752 | i0 | 87.879 | 53.5207373271889 | 231 | 25 | 53 | 3 | 1 | 229 | 5640 | 5411 | Gromochytrium mamkaevae strain CALU x-51 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 | 23228 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 7113049 | 7113049 | PRJNA758088_P_NODE_114766_length_391_cov_1.509434_g107796_i0 | PRJNA758088 | 114766 | 391 | 1.509434 | 5.90188694 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 195 | 5.87e-45 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g107796 | i0 | 85.185 | 37.2480818414322 | 189 | 28 | 48 | 0 | 202 | 390 | 904 | 716 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 14564 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 8392552 | 8392552 | PRJNA758088_P_NODE_91167_length_441_cov_1.554348_g84197_i0 | PRJNA758088 | 91167 | 441 | 1.554348 | 6.85467468 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 62.1 | 7.09e-5 | NTclustered | gi|2432145138|ref|XM_053110794.1| | 110093 | g84197 | i0 | 100 | 0.192743764172336 | 33 | 0 | 7 | 0 | 407 | 439 | 559 | 527 | Polychytrium aggregatum P-loop containing nucleoside triphosphate hydrolase protein (BJ171DRAFT_502800), mRNA | blastn | 85 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13491557 | 13491557 | PRJNA758088_P_NODE_347011_length_243_cov_0.905882_g340040_i0 | PRJNA758088 | 347011 | 243 | 0.905882 | 2.20129326 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 171 | 5.8e-38 | NTclustered | gi|2432155310|ref|XM_053111519.1| | 110093 | g340040 | i0 | 79.832 | 3.87242798353909 | 238 | 44 | 97 | 4 | 8 | 243 | 156 | 391 | Polychytrium aggregatum 60S ribosomal protein L23 (BJ171DRAFT_510921), mRNA | blastn | 941 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17313294 | 17313294 | PRJNA758088_P_NODE_173774_length_322_cov_0.779116_g166803_i0 | PRJNA758088 | 173774 | 322 | 0.779116 | 2.50875352 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 86.1 | 2.98e-12 | NTclustered | gi|2432130344|ref|XM_053109098.1| | 110093 | g166803 | i0 | 90.625 | 1.54037267080745 | 64 | 6 | 20 | 0 | 2 | 65 | 305 | 368 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_485234), mRNA | blastn | 496 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24964316 | 24964316 | PRJNA758088_P_NODE_348740_length_243_cov_0.905882_g341769_i0 | PRJNA758088 | 348740 | 243 | 0.905882 | 2.20129326 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 115 | 2.7500000000000003e-21 | NTclustered | gi|1027005164|ref|XM_016754649.1| | 645134 | g341769 | i0 | 93.506 | 7.52674897119342 | 77 | 5 | 32 | 0 | 1 | 77 | 333 | 257 | Spizellomyces punctatus DAOM BR117 60S ribosomal protein L44 (SPPG_06444), mRNA | blastn | 1829 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus |
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);;