contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1118107 | 1118107 | PRJNA533623_P_NODE_78941_length_193_cov_5.007576_g77160_i0 | PRJNA533623 | 78941 | 193 | 5.007576 | 9.66462168 | Rhizopus | 4842 | Fungi | Fungi | 307 | 3.2200000000000003e-79 | NTclustered | gi|2795784435|gb|PQ268974.1| | 4846 | g77160 | i0 | 98.844 | 89.0932642487047 | 173 | 0 | 89 | 1 | 23 | 193 | 5 | 177 | Rhizopus stolonifer isolate UJIY large subunit ribosomal RNA gene, partial sequence | blastn | 17195 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 6883639 | 6883639 | PRJNA533623_P_NODE_19006_length_537_cov_10.430672_g17265_i0 | PRJNA533623 | 19006 | 537 | 10.430672 | 56.01270864 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 126 | 3.0599999999999998e-24 | NTclustered | gi|2323766941|ref|XM_051553564.1| | 101098 | g17265 | i0 | 79.444 | 1.37988826815642 | 180 | 36 | 33 | 1 | 100 | 278 | 995 | 1174 | Gamsiella multidivaricata P-loop containing nucleoside triphosphate hydrolase protein (BC939DRAFT_436081), mRNA | blastn | 741 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 20244177 | 20244177 | PRJNA533623_P_NODE_16076_length_587_cov_674.338403_g14361_i0 | PRJNA533623 | 16076 | 587 | 674.338403 | 3958.36642561 | Fungi | 4751 | Fungi | Fungi | 442 | 2.9499999999999984e-119 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g14361 | i0 | 98.413 | 128.425894378194 | 252 | 2 | 93 | 2 | 329 | 579 | 2016 | 2266 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 75386 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 22794900 | 22794900 | PRJNA533623_P_NODE_15518_length_598_cov_512.986965_g13808_i0 | PRJNA533623 | 15518 | 598 | 512.986965 | 3067.6620507 | Fungi | 4751 | Fungi | Fungi | 442 | 3.0099999999999984e-119 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g13808 | i0 | 98.413 | 83.3578595317726 | 252 | 2 | 93 | 2 | 340 | 590 | 2016 | 2266 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 49848 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita |
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);;