contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA760976" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3293601 | 3293601 | PRJNA760976_P_NODE_18283_length_359_cov_2.653846_g17962_i0 | PRJNA760976 | 18283 | 359 | 2.653846 | 9.52730714 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 209 | 1.91e-49 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g17962 | i0 | 82.449 | 60.5877437325905 | 245 | 37 | 67 | 4 | 104 | 345 | 1188 | 947 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 21751 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 3293674 | 3293674 | PRJNA760976_P_NODE_46463_length_254_cov_2.099448_g46142_i0 | PRJNA760976 | 46463 | 254 | 2.099448 | 5.33259792 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 189 | 1.6799999999999996e-43 | NTclustered | gi|575473075|ref|XM_006675768.1| | 684364 | g46142 | i0 | 82.791 | 25.511811023622 | 215 | 33 | 83 | 3 | 20 | 231 | 234 | 21 | Batrachochytrium dendrobatidis JAM81 ADP-Ribosylation factor (BATDEDRAFT_36333), mRNA | blastn | 6480 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 10946415 | 10946415 | PRJNA760976_P_NODE_12809_length_408_cov_3.453731_g12489_i0 | PRJNA760976 | 12809 | 408 | 3.453731 | 14.09122248 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 261 | 5.98e-65 | NTclustered | gi|1759161687|ref|XM_031171014.1| | 1806994 | g12489 | i0 | 81.994 | 24.9705882352941 | 311 | 52 | 76 | 4 | 70 | 378 | 312 | 4 | Synchytrium microbalum uncharacterized protein (SmJEL517_g05086), partial mRNA | blastn | 10188 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 12221961 | 12221961 | PRJNA760976_P_NODE_17890_length_362_cov_1.726644_g17569_i0 | PRJNA760976 | 17890 | 362 | 1.726644 | 6.25045128 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 5.51e-30 | NTclustered | gi|2432158676|ref|XM_053113190.1| | 110093 | g17569 | i0 | 76.866 | 57.0939226519337 | 268 | 54 | 73 | 6 | 5 | 268 | 13 | 276 | Polychytrium aggregatum ribosomal protein S25 component of cytosolic 80S ribosome and 40S small subunit (BJ171DRAFT_559057), partial mRNA | blastn | 20668 | 145 | 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);;