contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA285816" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4199297 | 4199297 | PRJNA285816_S_NODE_944_length_657_cov_6.064145_g872_i0 | PRJNA285816 | 944 | 657 | 6.064145 | 39.84143265 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 200 | 2.2099999999999998e-46 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g872 | i0 | 76.485 | 21.1917808219178 | 404 | 73 | 60 | 16 | 200 | 595 | 523 | 134 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13923 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 5475480 | 5475480 | PRJNA285816_S_NODE_2705_length_407_cov_16.178771_g2603_i0 | PRJNA285816 | 2705 | 407 | 16.178771 | 65.84759797 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 121 | 1.06e-22 | NTclustered | gi|575480991|ref|XM_006679727.1| | 684364 | g2603 | i0 | 81.046 | 0.886977886977887 | 153 | 27 | 37 | 2 | 234 | 385 | 176 | 25 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_12294), partial mRNA | blastn | 361 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 5475506 | 5475506 | PRJNA285816_S_NODE_285_length_1070_cov_16.727718_g246_i0 | PRJNA285816 | 285 | 1070 | 16.727718 | 178.9865826 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 640 | 1.8199999999999997e-178 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g246 | i0 | 80.324 | 81.4336448598131 | 864 | 154 | 80 | 13 | 46 | 901 | 214 | 1069 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 87134 | 640 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 6749820 | 6749820 | PRJNA285816_S_NODE_4106_length_335_cov_4.486014_g4004_i0 | PRJNA285816 | 4106 | 335 | 4.486014 | 15.0281469 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 252 | 2.9e-62 | NTclustered | gi|2432131435|ref|XM_053109312.1| | 110093 | g4004 | i0 | 80.363 | 81.8477611940299 | 331 | 65 | 99 | 0 | 1 | 331 | 192 | 522 | Polychytrium aggregatum beta-tubulin (BJ171DRAFT_487560), mRNA | blastn | 27419 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18223777 | 18223777 | PRJNA285816_S_NODE_4255_length_330_cov_1.822064_g4153_i0 | PRJNA285816 | 4255 | 330 | 1.822064 | 6.0128112 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 204 | 8.1e-48 | NTclustered | gi|2432136347|ref|XM_053109928.1| | 110093 | g4153 | i0 | 78.261 | 13.1545454545455 | 322 | 66 | 97 | 4 | 1 | 320 | 530 | 849 | Polychytrium aggregatum carboxyl transferase (BJ171DRAFT_493626), mRNA | blastn | 4341 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18223786 | 18223786 | PRJNA285816_S_NODE_5175_length_302_cov_8.027668_g5073_i0 | PRJNA285816 | 5175 | 302 | 8.027668 | 24.24355736 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 7.6e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g5073 | i0 | 84.252 | 7.10927152317881 | 127 | 16 | 41 | 3 | 148 | 272 | 148 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 2147 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19497839 | 19497839 | PRJNA285816_S_NODE_14216_length_204_cov_0.929032_g14114_i0 | PRJNA285816 | 14216 | 204 | 0.929032 | 1.89522528 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 56.5 | 0.001 | NTclustered | gi|2432048076|ref|XM_053074395.1| | 1396493 | g14114 | i0 | 100 | 2.10294117647059 | 30 | 0 | 15 | 0 | 156 | 185 | 1312 | 1283 | Fimicolochytrium jonesii karyopherin Kap95 (EV422DRAFT_7892), mRNA | blastn | 429 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 23323922 | 23323922 | PRJNA285816_S_NODE_13019_length_210_cov_1.515528_g12917_i0 | PRJNA285816 | 13019 | 210 | 1.515528 | 3.1826088 | Neocallimastix patriciarum | 4758 | Fungi | Fungi | 156 | 1.37e-33 | NTclustered | gi|18874267|gb|AY033433.1| | 4758 | g12917 | i0 | 83.051 | 12.3666666666667 | 177 | 24 | 83 | 6 | 37 | 210 | 737 | 910 | Neocallimastix patriciarum ADP/ATP carrier (AAC) mRNA, complete cds; nuclear gene for hydrogenosomal product | blastn | 2597 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix patriciarum |
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);;