contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA683669" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10868864 | 10868864 | PRJNA683669_P_NODE_1129_length_1185_cov_5.646583_g1001_i0 | PRJNA683669 | 1129 | 1185 | 5.646583 | 66.91200855 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 542 | 5.88e-149 | NTclustered | gi|2432157894|ref|XM_053108463.1| | 110093 | g1001 | i0 | 78.42 | 50.7856540084388 | 848 | 171 | 71 | 9 | 86 | 926 | 104 | 946 | Polychytrium aggregatum ribosomal protein L4 domain-containing protein (BJ171DRAFT_461012), mRNA | blastn | 60181 | 542 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 12144350 | 12144350 | PRJNA683669_P_NODE_2410_length_842_cov_5.929779_g2221_i0 | PRJNA683669 | 2410 | 842 | 5.929779 | 49.92873918 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 411 | 1.21e-109 | NTclustered | gi|2432098059|ref|XM_053071244.1| | 1396493 | g2221 | i0 | 80.251 | 68.186460807601 | 557 | 100 | 66 | 6 | 120 | 671 | 142 | 693 | Fimicolochytrium jonesii 60S ribosomal protein I1-a (EV422DRAFT_542036), mRNA | blastn | 57413 | 411 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 12144442 | 12144442 | PRJNA683669_P_NODE_4410_length_621_cov_6.052920_g4186_i0 | PRJNA683669 | 4410 | 621 | 6.05292 | 37.5886332 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 315 | 7.12e-81 | NTclustered | gi|2432142218|ref|XM_053114797.1| | 110093 | g4186 | i0 | 79.814 | 65.1207729468599 | 431 | 87 | 69 | 0 | 149 | 579 | 500 | 70 | Polychytrium aggregatum ribosomal protein S13/S18-domain-containing protein (BJ171DRAFT_597985), partial mRNA | blastn | 40440 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 21067385 | 21067385 | PRJNA683669_P_NODE_19177_length_294_cov_3.601810_g18945_i0 | PRJNA683669 | 19177 | 294 | 3.60181 | 10.5893214 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 128 | 4.41e-25 | NTclustered | gi|2432058563|ref|XM_053065718.1| | 1396493 | g18945 | i0 | 79.558 | 2.81632653061224 | 181 | 35 | 61 | 2 | 106 | 285 | 80 | 259 | Fimicolochytrium jonesii 40S ribosomal protein S28 (EV422DRAFT_248144), mRNA | blastn | 828 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;