contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA436017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 430644 | 430644 | PRJNA436017_P_NODE_13701_length_226_cov_1.365079_g13403_i0 | PRJNA436017 | 13701 | 226 | 1.365079 | 3.08507854 | Mucor mucedo | 29922 | Fungi | Fungi | 119 | 1.96e-22 | NTclustered | gi|2324050181|ref|XM_051601360.1| | 29922 | g13403 | i0 | 80.247 | 24.5265486725664 | 162 | 28 | 71 | 4 | 65 | 224 | 211 | 52 | Mucor mucedo histone-fold-containing protein (EV154DRAFT_507085), mRNA | blastn | 5543 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 4257908 | 4257908 | PRJNA436017_P_NODE_28204_length_154_cov_0.982906_g27906_i0 | PRJNA436017 | 28204 | 154 | 0.982906 | 1.51367524 | Lichtheimia ornata | 688661 | Fungi | Fungi | 89.8 | 9.63e-14 | NTclustered | gi|2553578231|ref|XM_058486242.1| | 688661 | g27906 | i0 | 83.871 | 3.40909090909091 | 93 | 15 | 60 | 0 | 22 | 114 | 354 | 262 | Lichtheimia ornata uncharacterized protein (O0I10_006211), partial mRNA | blastn | 525 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Lichtheimia | Lichtheimia ornata | |
| 5534423 | 5534423 | PRJNA436017_P_NODE_17145_length_198_cov_2.776398_g16847_i0 | PRJNA436017 | 17145 | 198 | 2.776398 | 5.49726804 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 67.6 | 6.13e-7 | NTclustered | gi|2324069678|ref|XM_051523051.1| | 90255 | g16847 | i0 | 91.667 | 0.792929292929293 | 48 | 4 | 24 | 0 | 151 | 198 | 369 | 322 | Cokeromyces recurvatus putative ribosomal protein S15 (BX663DRAFT_434146), partial mRNA | blastn | 157 | 67.6 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 11909431 | 11909431 | PRJNA436017_P_NODE_14190_length_221_cov_2.282609_g13892_i0 | PRJNA436017 | 14190 | 221 | 2.282609 | 5.04456589 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 156 | 1.45e-33 | NTclustered | gi|2324061888|ref|XM_051531209.1| | 90255 | g13892 | i0 | 83.735 | 73.7285067873303 | 166 | 25 | 75 | 2 | 1 | 165 | 496 | 660 | Cokeromyces recurvatus 60S ribosomal protein L2 (BX663DRAFT_550341), partial mRNA | blastn | 16294 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 18940471 | 18940471 | PRJNA436017_P_NODE_13095_length_232_cov_1.502564_g12797_i0 | PRJNA436017 | 13095 | 232 | 1.502564 | 3.48594848 | Fungi | 4751 | Fungi | Fungi | 385 | 1.7999999999999996e-102 | NTclustered | gi|1402384622|gb|MH483598.1| | 64518 | g12797 | i0 | 97.357 | 96.2198275862069 | 227 | 4 | 97 | 2 | 7 | 232 | 230 | 455 | Mortierella alpina isolate CK595 large subunit ribosomal RNA gene, partial sequence | blastn | 22323 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella alpina | |
| 22107172 | 22107172 | PRJNA436017_P_NODE_11218_length_255_cov_2.192661_g10920_i0 | PRJNA436017 | 11218 | 255 | 2.192661 | 5.59128555 | uncultured Glomeromycotina | 241622 | Fungi | Fungi | 198 | 2.81e-46 | NTclustered | gi|219959662|gb|FJ567202.1| | 241622 | g10920 | i0 | 81.961 | 100 | 255 | 26 | 100 | 11 | 1 | 255 | 635 | 401 | Uncultured glomeromycete clone A2YM02RM1 large subunit ribosomal RNA gene, partial sequence | blastn | 25500 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | uncultured Glomeromycotina | |||||
| 23383214 | 23383214 | PRJNA436017_P_NODE_6919_length_339_cov_1.824503_g6622_i0 | PRJNA436017 | 6919 | 339 | 1.824503 | 6.18506517 | Rhizophagus intraradices | 4876 | Fungi | Fungi | 200 | 1.08e-46 | NTclustered | gi|240147765|gb|FJ235566.1| | 4876 | g6622 | i0 | 78.551 | 48.4896755162242 | 345 | 45 | 99 | 19 | 1 | 338 | 1708 | 2030 | Glomus intraradices clone rLU_21 25S large subunit ribosomal RNA, partial sequence | blastn | 16438 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus intraradices | |
| 24040901 | 24040901 | PRJNA436017_P_NODE_7579_length_322_cov_2.161404_g7282_i0 | PRJNA436017 | 7579 | 322 | 2.161404 | 6.95972088 | Mucoromycota | 1913637 | Fungi | Fungi | 171 | 8e-38 | NTclustered | gi|2724945977|ref|XM_064823284.1| | 708070 | g7282 | i0 | 87.333 | 60.6832298136646 | 150 | 17 | 46 | 2 | 174 | 322 | 456 | 308 | Mucor velutinosus uncharacterized protein (ATC70_003929), partial mRNA | blastn | 19540 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus |
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);;