contig_metadata
8 rows where bioproject = "PRJNA564810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8207123 | 8207123 | PRJNA564810_S_NODE_4347_length_266_cov_1.014925_g4325_i0 | PRJNA564810 | 4347 | 266 | 1.014925 | 2.6997005 | Fungi | 4751 | Fungi | Fungi | 68.2 | 1.79e-12 | NR | RUP44019.1 | 994334 | g4325 | i0 | 48.4 | 3.58646616541353 | 62 | 32 | 69.9 | 0 | 261 | 76 | 45 | 106 | RUP44019.1 transcription initiation factor IIA, gamma subunit, helical domain-containing protein, partial [Jimgerdemannia flammicorona] | diamond | 954 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 13308225 | 13308225 | PRJNA564810_S_NODE_1391_length_369_cov_10.983553_g1369_i0 | PRJNA564810 | 1391 | 369 | 10.983553 | 40.52931057 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 87.9 | 9.61e-13 | NTclustered | gi|1069965094|ref|XM_018440173.1| | 763407 | g1369 | i0 | 86.25 | 4.28184281842818 | 80 | 11 | 22 | 0 | 42 | 121 | 1082 | 1161 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 1580 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 27914139 | 27914139 | PRJNA564810_S_NODE_445_length_512_cov_2.930649_g424_i0 | PRJNA564810 | 445 | 512 | 2.930649 | 15.00492288 | Opisthokonta | 33154 | Fungi | Fungi | 155 | 1.98e-43 | NR | XP_069235167.1 | 4840 | g424 | i0 | 68.2 | 9.568359375 | 110 | 35 | 64.5 | 0 | 1 | 330 | 158 | 267 | XP_069235167.1 60S ribosomal protein eL8 [Rhizomucor pusillus] | diamond | 4899 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 29415998 | 29415998 | PRJNA564810_S_NODE_4329_length_266_cov_2.343284_g4307_i0 | PRJNA564810 | 4329 | 266 | 2.343284 | 6.23313544 | Jimgerdemannia flammicorona | 994334 | Fungi | Fungi | 72.4 | 1.8e-12 | NR | RUS32087.1 | 994334 | g4307 | i0 | 61.8 | 3.1015037593985 | 68 | 25 | 75.6 | 1 | 26 | 226 | 291 | 358 | RUS32087.1 hypothetical protein BC938DRAFT_476321 [Jimgerdemannia flammicorona] | diamond | 825 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona | |
| 29447476 | 29447476 | PRJNA564810_S_NODE_1290_length_377_cov_7.028846_g1268_i0 | PRJNA564810 | 1290 | 377 | 7.028846 | 26.49874942 | Lunasporangiospora selenospora | 979761 | Fungi | Fungi | 79 | 2.91e-14 | NR | KAF9585876.1 | 979761 | g1268 | i0 | 76.6 | 1.50397877984085 | 47 | 11 | 37.4 | 0 | 1 | 141 | 270 | 316 | KAF9585876.1 cross-pathway control WD-repeat protein cpc2 [Lunasporangiospora selenospora] | diamond | 567 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Lunasporangiospora | Lunasporangiospora selenospora | |
| 30472311 | 30472311 | PRJNA564810_S_NODE_3613_length_282_cov_1.566820_g3591_i0 | PRJNA564810 | 3613 | 282 | 1.56682 | 4.4184324 | root | 1 | Root_unresolved | Root_unresolved | 48.5 | 4.57e-4 | NR | GES78161.1 | 94130 | g3591 | i0 | 39.4 | 3.92553191489362 | 66 | 39 | 70.2 | 1 | 280 | 83 | 196 | 260 | GES78161.1 endoribonuclease LACTB2 [Rhizophagus clarus] | diamond | 1107 | 48.9 | 0.991820040899796 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus | |
| 30774575 | 30774575 | PRJNA564810_S_NODE_6674_length_227_cov_2.092593_g6652_i0 | PRJNA564810 | 6674 | 227 | 2.092593 | 4.75018611 | Linnemannia zychae | 979765 | Fungi | Fungi | 47.8 | 5.23e-4 | NR | KAF9908681.1 | 979765 | g6652 | i0 | 61.1 | 0.475770925110132 | 36 | 13 | 46.3 | 1 | 222 | 118 | 851 | 886 | KAF9908681.1 Elongator subunit elp2 [Linnemannia zychae] | diamond | 108 | 47.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia zychae | |
| 32702889 | 32702889 | PRJNA564810_S_NODE_3960_length_274_cov_1.947368_g3938_i0 | PRJNA564810 | 3960 | 274 | 1.947368 | 5.33578832 | Endogone sp. FLAS-F59 | 2012134 | Fungi | Fungi | 50.1 | 1.38e-4 | NR | RUS14217.1 | 2340872 | g3938 | i0 | 46.3 | 0.591240875912409 | 54 | 24 | 53.6 | 1 | 1 | 147 | 325 | 378 | RUS14217.1 trypsin-like cysteine/serine peptidase domain-containing protein [Endogone sp. FLAS-F59071] | diamond | 162 | 50.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Endogone | Endogone sp. FLAS-F59071 |
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);;