contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA1148190" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4119437 | 4119437 | PRJNA1148190_P_NODE_221044_length_361_cov_1.069444_g209874_i0 | PRJNA1148190 | 221044 | 361 | 1.069444 | 3.86069284 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 130 | 1.54e-25 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g209874 | i0 | 90 | 1.74238227146814 | 100 | 10 | 28 | 0 | 262 | 361 | 514 | 415 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 629 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6678309 | 6678309 | PRJNA1148190_P_NODE_805486_length_227_cov_2.649351_g794313_i0 | PRJNA1148190 | 805486 | 227 | 2.649351 | 6.01402677 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 102 | 1.98e-17 | NTclustered | gi|2897836978|gb|CP161927.1| | 109871 | g794313 | i0 | 89.873 | 1.21145374449339 | 79 | 8 | 35 | 0 | 20 | 98 | 686177 | 686099 | Batrachochytrium dendrobatidis strain JEL423 chromosome 5 | blastn | 275 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 11778229 | 11778229 | PRJNA1148190_P_NODE_740770_length_243_cov_0.905882_g729597_i0 | PRJNA1148190 | 740770 | 243 | 0.905882 | 2.20129326 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 71.3 | 6.05e-8 | NTclustered | gi|2432173666|ref|XM_053107885.1| | 110093 | g729597 | i0 | 86.154 | 0.559670781893004 | 65 | 9 | 27 | 0 | 43 | 107 | 953 | 889 | Polychytrium aggregatum nife hydrogenase-like protein (BJ171DRAFT_430063), partial mRNA | blastn | 136 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21972208 | 21972208 | PRJNA1148190_P_NODE_420158_length_282_cov_1.473684_g408985_i0 | PRJNA1148190 | 420158 | 282 | 1.473684 | 4.15578888 | Piromyces sp. | 45796 | Fungi | Fungi | 521 | 1.6499999999999996e-143 | NTclustered | gi|1388116266|gb|MH043820.1| | 45796 | g408985 | i0 | 100 | 87.1099290780142 | 282 | 0 | 100 | 0 | 1 | 282 | 205 | 486 | Piromyces sp. strain B5 Glycosyl hydrolase family 43 mRNA, partial cds | blastn | 24565 | 521 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Piromyces | Piromyces sp. |
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);;