contig_metadata
9 rows where bioproject = "PRJNA902848", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4710723 | 4710723 | PRJNA902848_P_NODE_5824_length_351_cov_1.938849_g5774_i0 | PRJNA902848 | 5824 | 351 | 1.938849 | 6.80535999 | Glomeromycetes | 214506 | Fungi | Fungi | 177 | 3.51e-52 | NR | GBB98808.1 | 94130 | g5774 | i0 | 73.3 | 18.8376068376068 | 116 | 31 | 99.1 | 0 | 3 | 350 | 6 | 121 | GBB98808.1 hypothetical protein RclHR1_03330005 [Rhizophagus clarus] | diamond | 6612 | 178 | 0.99438202247191 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus clarus | |
| 5985287 | 5985287 | PRJNA902848_P_NODE_17745_length_246_cov_0.901734_g17695_i0 | PRJNA902848 | 17745 | 246 | 0.901734 | 2.21826564 | Gilbertella persicaria | 101096 | Fungi | Fungi | 154 | 5.9200000000000005e-33 | NTclustered | gi|2323756360|ref|XM_051582048.1| | 101096 | g17695 | i0 | 78.279 | 1.4349593495935 | 244 | 50 | 98 | 2 | 1 | 241 | 188 | 431 | Gilbertella persicaria cystathionine beta-synthase (B0P05DRAFT_580859), partial mRNA | blastn | 353 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 11085552 | 11085552 | PRJNA902848_P_NODE_15269_length_250_cov_0.881356_g15219_i0 | PRJNA902848 | 15269 | 250 | 0.881356 | 2.20339 | Eukaryota | 2759 | Fungi | Fungi | 139 | 1.87e-40 | NR | XP_069241350.1 | 4840 | g15219 | i0 | 79.8 | 10.032 | 84 | 15 | 98.4 | 1 | 3 | 248 | 24 | 107 | XP_069241350.1 60S ribosomal protein eL42 [Rhizomucor pusillus] | diamond | 2508 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 12360992 | 12360992 | PRJNA902848_P_NODE_19250_length_243_cov_0.917647_g19200_i0 | PRJNA902848 | 19250 | 243 | 0.917647 | 2.22988221 | Linnemannia gamsii | 64522 | Fungi | Fungi | 110 | 7.29e-26 | NR | KAG0297207.1 | 64522 | g19200 | i0 | 78.2 | 11.6666666666667 | 78 | 17 | 96.3 | 0 | 241 | 8 | 164 | 241 | KAG0297207.1 Pre-mRNA-splicing factor cef1 [Linnemannia gamsii] | diamond | 2835 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia gamsii | |
| 20373368 | 20373368 | PRJNA902848_P_NODE_4016_length_403_cov_0.945455_g3966_i0 | PRJNA902848 | 4016 | 403 | 0.945455 | 3.81018365 | Glomeromycetes | 214506 | Fungi | Fungi | 231 | 8.14e-76 | NR | KAG9284240.1 | 50956 | g3966 | i0 | 87.5 | 9.44665012406948 | 128 | 16 | 95.3 | 0 | 15 | 398 | 1 | 128 | KAG9284240.1 hypothetical protein G9A89_002050 [Geosiphon pyriformis] | diamond | 3807 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 27372257 | 27372257 | PRJNA902848_P_NODE_2903_length_455_cov_1.308901_g2853_i0 | PRJNA902848 | 2903 | 455 | 1.308901 | 5.95549955 | Fennellomyces sp. T- | 1329386 | Fungi | Fungi | 80.5 | 5.07e-16 | NR | KAI8145219.1 | 1329386 | g2853 | i0 | 42.9 | 1.71428571428571 | 119 | 64 | 78.5 | 2 | 22 | 378 | 2 | 116 | KAI8145219.1 ribosomal protein L28e [Fennellomyces sp. T-0311] | diamond | 780 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Fennellomyces | Fennellomyces sp. T-0311 | |
| 28918872 | 28918872 | PRJNA902848_P_NODE_13248_length_253_cov_0.866667_g13198_i0 | PRJNA902848 | 13248 | 253 | 0.866667 | 2.19266751 | Mortierella sp. NVP85 | 1896193 | Fungi | Fungi | 136 | 2.96e-35 | NR | KAF9365928.1 | 1896193 | g13198 | i0 | 91.3 | 0.818181818181818 | 69 | 6 | 81.8 | 0 | 251 | 45 | 199 | 267 | KAF9365928.1 Sorting nexin mvp1 [Mortierella sp. NVP85] | diamond | 207 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Mortierella | Mortierella sp. NVP85 | |
| 29368744 | 29368744 | PRJNA902848_P_NODE_17989_length_245_cov_0.906977_g17939_i0 | PRJNA902848 | 17989 | 245 | 0.906977 | 2.22209365 | Glomeromycetes | 214506 | Fungi | Fungi | 72.4 | 3.74e-14 | NR | CAG8716814.1 | 27376 | g17939 | i0 | 47.4 | 7.81224489795918 | 76 | 37 | 90.6 | 2 | 239 | 18 | 25 | 99 | CAG8716814.1 11889_t:CDS:2, partial [Acaulospora colombiana] | diamond | 1914 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Acaulosporaceae | Acaulospora | Acaulospora colombiana | |
| 31675189 | 31675189 | PRJNA902848_P_NODE_8537_length_304_cov_1.341991_g8487_i0 | PRJNA902848 | 8537 | 304 | 1.341991 | 4.07965264 | Eukaryota | 2759 | Fungi | Fungi | 128 | 6.809999999999998e-32 | NR | KAG2174825.1 | 91625 | g8487 | i0 | 72.1 | 8.79276315789474 | 86 | 24 | 84.9 | 0 | 2 | 259 | 587 | 672 | KAG2174825.1 hypothetical protein INT43_005887 [Umbelopsis isabellina] | diamond | 2673 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina |
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);;