contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJEB12237" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10223402 | 10223402 | PRJEB12237_P_NODE_10469_length_164_cov_1.224806_g10273_i0 | PRJEB12237 | 10469 | 164 | 1.224806 | 2.00868184 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 126 | 7.9499999999999995e-25 | NTclustered | gi|2432151864|ref|XM_053111326.1| | 110093 | g10273 | i0 | 81.579 | 4.17073170731707 | 152 | 28 | 93 | 0 | 8 | 159 | 472 | 623 | Polychytrium aggregatum glucosamine-6-phosphate isomerase (BJ171DRAFT_508873), mRNA | blastn | 684 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 10223413 | 10223413 | PRJEB12237_P_NODE_11789_length_153_cov_1.016949_g11593_i0 | PRJEB12237 | 11789 | 153 | 1.016949 | 1.55593197 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 152 | 1.1999999999999999e-32 | NTclustered | gi|2432057423|ref|XM_053069416.1| | 1396493 | g11593 | i0 | 84.868 | 94.156862745098 | 152 | 21 | 99 | 2 | 3 | 153 | 537 | 387 | Fimicolochytrium jonesii hsp71-like protein (EV422DRAFT_516945), mRNA | blastn | 14406 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 17872349 | 17872349 | PRJEB12237_P_NODE_9615_length_173_cov_1.159420_g9419_i0 | PRJEB12237 | 9615 | 173 | 1.15942 | 2.0057966 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 128 | 2.35e-25 | NTclustered | gi|2432157378|ref|XM_053107751.1| | 110093 | g9419 | i0 | 88.073 | 2.4971098265896 | 109 | 11 | 62 | 2 | 59 | 166 | 294 | 187 | Polychytrium aggregatum ribosomal protein L6, alpha-beta domain-containing protein (BJ171DRAFT_426015), partial mRNA | blastn | 432 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18837429 | 18837429 | PRJEB12237_P_NODE_7975_length_195_cov_5.218750_g7779_i0 | PRJEB12237 | 7975 | 195 | 5.21875 | 10.1765625 | Chytridiomycota | 4761 | Fungi | Fungi | 78.7 | 2.78e-10 | NTclustered | gi|2432146664|ref|XM_053113161.1| | 110093 | g7779 | i0 | 86.957 | 13.2615384615385 | 69 | 9 | 35 | 0 | 127 | 195 | 393 | 325 | Polychytrium aggregatum 40S ribosomal protein S22-A (BJ171DRAFT_558627), partial mRNA | blastn | 2586 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20421354 | 20421354 | PRJEB12237_P_NODE_6037_length_238_cov_2.157635_g5841_i0 | PRJEB12237 | 6037 | 238 | 2.157635 | 5.1351713 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 104 | 5.82e-18 | NTclustered | gi|2432155690|ref|XM_053111537.1| | 110093 | g5841 | i0 | 84.615 | 0.436974789915966 | 104 | 16 | 44 | 0 | 50 | 153 | 1232 | 1335 | Polychytrium aggregatum mitochondrial carrier domain-containing protein (BJ171DRAFT_511047), mRNA | blastn | 104 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22972660 | 22972660 | PRJEB12237_P_NODE_2999_length_396_cov_1.991690_g2803_i0 | PRJEB12237 | 2999 | 396 | 1.99169 | 7.8870924 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 283 | 1.23e-71 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g2803 | i0 | 79.545 | 98.5732323232323 | 396 | 81 | 100 | 0 | 1 | 396 | 1259 | 864 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 39035 | 283 | 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);;