contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA971593" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944189 | 944189 | PRJNA971593_P_NODE_18561_length_277_cov_1.132353_g18412_i0 | PRJNA971593 | 18561 | 277 | 1.132353 | 3.13661781 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 224 | 5.1e-54 | NTclustered | gi|2432132239|ref|XM_053109464.1| | 110093 | g18412 | i0 | 88.36 | 68.841155234657 | 189 | 18 | 68 | 4 | 88 | 274 | 545 | 359 | Polychytrium aggregatum ribosomal protein S17-domain-containing protein (BJ171DRAFT_489270), mRNA | blastn | 19069 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 944393 | 944393 | PRJNA971593_P_NODE_4961_length_544_cov_1.798301_g4815_i0 | PRJNA971593 | 4961 | 544 | 1.798301 | 9.78275744 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 357 | 1.01e-93 | NTclustered | gi|2432150950|ref|XM_053107694.1| | 110093 | g4815 | i0 | 79.878 | 1.39522058823529 | 492 | 95 | 90 | 3 | 29 | 518 | 1755 | 1266 | Polychytrium aggregatum elongation factor EF-3 (BJ171DRAFT_424968), partial mRNA | blastn | 759 | 357 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 2219708 | 2219708 | PRJNA971593_P_NODE_3122_length_678_cov_3.609917_g2980_i0 | PRJNA971593 | 3122 | 678 | 3.609917 | 24.47523726 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 307 | 1.31e-78 | NTclustered | gi|2432170888|ref|XM_053112523.1| | 110093 | g2980 | i0 | 77.087 | 33.3628318584071 | 563 | 109 | 82 | 18 | 44 | 596 | 49 | 601 | Polychytrium aggregatum putative 40S ribosomal protein S3 (BJ171DRAFT_522887), mRNA | blastn | 22620 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9872593 | 9872593 | PRJNA971593_P_NODE_4988_length_542_cov_3.375267_g4842_i0 | PRJNA971593 | 4988 | 542 | 3.375267 | 18.29394714 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 475 | 2.6699999999999993e-129 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g4842 | i0 | 88.86 | 70.6236162361624 | 386 | 43 | 71 | 0 | 157 | 542 | 578 | 193 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 38278 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 9872623 | 9872623 | PRJNA971593_P_NODE_7628_length_440_cov_3.147139_g7479_i0 | PRJNA971593 | 7628 | 440 | 3.147139 | 13.8474116 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 444 | 6.01e-120 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g7479 | i0 | 85.057 | 95.0568181818182 | 435 | 65 | 99 | 0 | 5 | 439 | 568 | 134 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 41825 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 11148006 | 11148006 | PRJNA971593_P_NODE_5929_length_499_cov_6.352113_g5781_i0 | PRJNA971593 | 5929 | 499 | 6.352113 | 31.69704387 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 401 | 4.199999999999999e-107 | NTclustered | gi|2432131711|ref|XM_053109357.1| | 110093 | g5781 | i0 | 82.599 | 88.0220440881764 | 454 | 79 | 91 | 0 | 42 | 495 | 579 | 126 | Polychytrium aggregatum calmodulin (BJ171DRAFT_488251), mRNA | blastn | 43923 | 401 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 13698136 | 13698136 | PRJNA971593_P_NODE_8871_length_408_cov_1.023881_g8722_i0 | PRJNA971593 | 8871 | 408 | 1.023881 | 4.17743448 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 213 | 1.7e-50 | NTclustered | gi|2432129870|ref|XM_053107267.1| | 110093 | g8722 | i0 | 80.645 | 4.47794117647059 | 279 | 50 | 68 | 4 | 1 | 277 | 512 | 236 | Polychytrium aggregatum ribosomal protein S7 domain-containing protein (BJ171DRAFT_4084), mRNA | blastn | 1827 | 213 | 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);;