contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4701506 | 4701506 | PRJNA896758_P_NODE_9944_length_362_cov_1.332180_g9554_i0 | PRJNA896758 | 9944 | 362 | 1.33218 | 4.8224916 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 56.5 | 0.003 | NTclustered | gi|2432063027|ref|XM_053073854.1| | 1396493 | g9554 | i0 | 100 | 0.0828729281767956 | 30 | 0 | 8 | 0 | 194 | 223 | 1622 | 1651 | Fimicolochytrium jonesii DNA mismatch repair protein Mlh1 (EV422DRAFT_610004), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 12351752 | 12351752 | PRJNA896758_P_NODE_13810_length_309_cov_4.478814_g13420_i0 | PRJNA896758 | 13810 | 309 | 4.478814 | 13.83953526 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 174 | 5.9e-39 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g13420 | i0 | 79.6 | 3.00323624595469 | 250 | 45 | 80 | 6 | 28 | 274 | 79 | 325 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 928 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13626645 | 13626645 | PRJNA896758_P_NODE_2791_length_690_cov_4.405186_g2422_i0 | PRJNA896758 | 2791 | 690 | 4.405186 | 30.3957834 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 427 | 9.79e-115 | NTclustered | gi|2432142346|ref|XM_053110504.1| | 110093 | g2422 | i0 | 82.164 | 33.2376811594203 | 499 | 87 | 72 | 2 | 117 | 614 | 576 | 79 | Polychytrium aggregatum 60S ribosomal protein L19 (BJ171DRAFT_499802), mRNA | blastn | 22934 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14900865 | 14900865 | PRJNA896758_P_NODE_8272_length_394_cov_1.869159_g7882_i0 | PRJNA896758 | 8272 | 394 | 1.869159 | 7.36448646 | Synchytrium sp. | 1971732 | Fungi | Fungi | 104 | 1.03e-17 | NTclustered | gi|1168020523|gb|KY800404.1| | 1971732 | g7882 | i0 | 78.528 | 0.413705583756345 | 163 | 31 | 41 | 4 | 91 | 251 | 1066 | 906 | Synchytrium sp. voucher BPI 893319 large subunit ribosomal RNA gene, partial sequence | blastn | 163 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium sp. | |
| 16175590 | 16175590 | PRJNA896758_P_NODE_22553_length_249_cov_0.875000_g22163_i0 | PRJNA896758 | 22553 | 249 | 0.875 | 2.17875 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 383 | 7.04e-102 | NTclustered | gi|2432134095|ref|XM_053108010.1| | 110093 | g22163 | i0 | 94.378 | 99.5622489959839 | 249 | 14 | 100 | 0 | 1 | 249 | 200 | 448 | Polychytrium aggregatum tubulin, alpha, ubiquitous (BJ171DRAFT_438790), mRNA | blastn | 24791 | 383 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16175645 | 16175645 | PRJNA896758_P_NODE_5593_length_481_cov_1.845588_g5204_i0 | PRJNA896758 | 5593 | 481 | 1.845588 | 8.87727828 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 259 | 2.5700000000000003e-64 | NTclustered | gi|2432139102|ref|XM_053107495.1| | 110093 | g5204 | i0 | 79.675 | 58.8336798336798 | 369 | 67 | 76 | 7 | 95 | 459 | 365 | 1 | Polychytrium aggregatum ribosomal protein L34e-domain-containing protein (BJ171DRAFT_421619), partial mRNA | blastn | 28299 | 259 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16546476 | 16546476 | PRJNA896758_P_NODE_3873_length_583_cov_2.845098_g3491_i0 | PRJNA896758 | 3873 | 583 | 2.845098 | 16.58692134 | Chytridiomycetes | 451435 | Fungi | Fungi | 412 | 2.2899999999999998e-110 | NTclustered | gi|2432134095|ref|XM_053108010.1| | 110093 | g3491 | i0 | 89.969 | 53.3499142367067 | 319 | 32 | 55 | 0 | 265 | 583 | 1492 | 1174 | Polychytrium aggregatum tubulin, alpha, ubiquitous (BJ171DRAFT_438790), mRNA | blastn | 31103 | 414 | 0.995169082125604 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 17451021 | 17451021 | PRJNA896758_P_NODE_17774_length_275_cov_1.524752_g17384_i0 | PRJNA896758 | 17774 | 275 | 1.524752 | 4.193068 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 180 | 1.11e-40 | NTclustered | gi|2432137896|ref|XM_053110084.1| | 110093 | g17384 | i0 | 85.635 | 20.1127272727273 | 181 | 14 | 64 | 9 | 36 | 210 | 34 | 208 | Polychytrium aggregatum 40S ribosomal protein S29-like protein (BJ171DRAFT_495104), mRNA | blastn | 5531 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18724274 | 18724274 | PRJNA896758_P_NODE_19115_length_266_cov_1.279793_g18725_i0 | PRJNA896758 | 19115 | 266 | 1.279793 | 3.40424938 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 3.9e-30 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g18725 | i0 | 86.364 | 4.52631578947368 | 132 | 18 | 50 | 0 | 116 | 247 | 155 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 1204 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21274821 | 21274821 | PRJNA896758_P_NODE_4777_length_520_cov_2.362416_g4389_i0 | PRJNA896758 | 4777 | 520 | 2.362416 | 12.2845632 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 311 | 7.62e-80 | NTclustered | gi|2432152476|ref|XM_053111362.1| | 110093 | g4389 | i0 | 82.857 | 55.9653846153846 | 350 | 56 | 67 | 4 | 80 | 427 | 610 | 263 | Polychytrium aggregatum 50S ribosomal protein L30e-like protein (BJ171DRAFT_509224), mRNA | blastn | 29102 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22549760 | 22549760 | PRJNA896758_P_NODE_9118_length_377_cov_1.519737_g8728_i0 | PRJNA896758 | 9118 | 377 | 1.519737 | 5.72940849 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 246 | 1.5299999999999998e-60 | NTclustered | gi|2432072949|ref|XM_053073468.1| | 1396493 | g8728 | i0 | 80.428 | 89.1167108753316 | 327 | 60 | 86 | 4 | 53 | 377 | 688 | 364 | Fimicolochytrium jonesii ubiquitin-related domain-containing protein (EV422DRAFT_586682), mRNA | blastn | 33597 | 246 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 23824967 | 23824967 | PRJNA896758_P_NODE_18079_length_273_cov_1.540000_g17689_i0 | PRJNA896758 | 18079 | 273 | 1.54 | 4.2042 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 180 | 1.1e-40 | NTclustered | gi|2432163634|ref|XM_053112058.1| | 110093 | g17689 | i0 | 79.767 | 0.941391941391941 | 257 | 45 | 93 | 6 | 16 | 268 | 76 | 329 | Polychytrium aggregatum 40S ribosomal protein S21 (BJ171DRAFT_516738), mRNA | blastn | 257 | 180 | 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);;