contig_metadata
12 rows where bioproject = "PRJNA751877", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3277902 | 3277902 | PRJNA751877_P_NODE_4603_length_447_cov_2.863636_g4481_i0 | PRJNA751877 | 4603 | 447 | 2.863636 | 12.80045292 | Rhizomucor pusillus | 4840 | Fungi | Fungi | 200 | 1.4599999999999999e-46 | NTclustered | gi|2837731086|ref|XM_069388369.1| | 4840 | g4481 | i0 | 82.051 | 36.751677852349 | 234 | 42 | 52 | 0 | 4 | 237 | 34 | 267 | Rhizomucor pusillus 60S ribosomal protein eL43 (VTP01DRAFT_9167), partial mRNA | blastn | 16428 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Lichtheimiaceae | Rhizomucor | Rhizomucor pusillus | |
| 7104793 | 7104793 | PRJNA751877_P_NODE_10906_length_337_cov_1.166667_g10784_i0 | PRJNA751877 | 10906 | 337 | 1.166667 | 3.93166779 | Linnemannia | 2779861 | Fungi | Fungi | 95.1 | 1.31e-20 | NR | KAG0066098.1 | 310910 | g10784 | i0 | 46.8 | 8.64391691394659 | 109 | 53 | 97 | 2 | 330 | 4 | 7 | 110 | KAG0066098.1 hypothetical protein BGZ89_007627 [Linnemannia elongata] | diamond | 2913 | 95.9 | 0.991657977059437 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia elongata | |
| 10930580 | 10930580 | PRJNA751877_P_NODE_8449_length_367_cov_1.047619_g8327_i0 | PRJNA751877 | 8449 | 367 | 1.047619 | 3.84476173 | Mortierellaceae | 4854 | Fungi | Fungi | 85.5 | 1.64e-16 | NR | KAG0301953.1 | 979702 | g8327 | i0 | 60.3 | 1.82288828337875 | 63 | 23 | 51.5 | 1 | 2 | 190 | 681 | 741 | KAG0301953.1 hypothetical protein BGZ98_007921 [Dissophora globulifera] | diamond | 669 | 85.5 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Dissophora | Dissophora globulifera | |
| 12205998 | 12205998 | PRJNA751877_P_NODE_4130_length_462_cov_3.455013_g4008_i0 | PRJNA751877 | 4130 | 462 | 3.455013 | 15.96216006 | Umbelopsis isabellina | 91625 | Fungi | Fungi | 201 | 3.43e-60 | NR | KAG2172013.1 | 91625 | g4008 | i0 | 73.6 | 1.87012987012987 | 144 | 37 | 93.5 | 1 | 437 | 6 | 209 | 351 | KAG2172013.1 hypothetical protein INT43_001490 [Umbelopsis isabellina] | diamond | 864 | 201 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 17304734 | 17304734 | PRJNA751877_P_NODE_9394_length_354_cov_1.978648_g9272_i0 | PRJNA751877 | 9394 | 354 | 1.978648 | 7.00441392 | Gamsiella multidivaricata | 101098 | Fungi | Fungi | 209 | 1.88e-49 | NTclustered | gi|2323795724|ref|XM_051557003.1| | 101098 | g9272 | i0 | 78.638 | 23.364406779661 | 323 | 63 | 90 | 3 | 3 | 322 | 50 | 369 | Gamsiella multidivaricata ribosomal protein L24 (BC939DRAFT_461274), mRNA | blastn | 8271 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Gamsiella | Gamsiella multidivaricata | |
| 19853305 | 19853305 | PRJNA751877_P_NODE_16096_length_289_cov_1.425926_g15974_i0 | PRJNA751877 | 16096 | 289 | 1.425926 | 4.12092614 | Mucor mucedo | 29922 | Fungi | Fungi | 60.2 | 1.6e-4 | NTclustered | gi|2324051478|ref|XM_051597657.1| | 29922 | g15974 | i0 | 93.023 | 0.660899653979239 | 43 | 0 | 14 | 3 | 234 | 273 | 544 | 586 | Mucor mucedo uncharacterized protein (EV154DRAFT_464253), partial mRNA | blastn | 191 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo | |
| 22877788 | 22877788 | PRJNA751877_P_NODE_24658_length_248_cov_0.880000_g24536_i0 | PRJNA751877 | 24658 | 248 | 0.88 | 2.1824 | Linnemannia exigua | 604196 | Fungi | Fungi | 108 | 3.79e-25 | NR | KAG0268363.1 | 604196 | g24536 | i0 | 65.4 | 1.94758064516129 | 81 | 28 | 98 | 0 | 6 | 248 | 292 | 372 | KAG0268363.1 Glucose-6-phosphate 1-dehydrogenase, partial [Linnemannia exigua] | diamond | 483 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mortierellomycetes | Mortierellales | Mortierellaceae | Linnemannia | Linnemannia exigua | |
| 27694834 | 27694834 | PRJNA751877_P_NODE_24004_length_249_cov_0.875000_g23882_i0 | PRJNA751877 | 24004 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | Fungi | Fungi | 106 | 1.96e-25 | NR | KAG2179225.1 | 91625 | g23882 | i0 | 82.1 | 2.73493975903614 | 56 | 10 | 67.5 | 0 | 5 | 172 | 292 | 347 | KAG2179225.1 hypothetical protein INT43_002075 [Umbelopsis isabellina] | diamond | 681 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 27947182 | 27947182 | PRJNA751877_P_NODE_24165_length_249_cov_0.875000_g24043_i0 | PRJNA751877 | 24165 | 249 | 0.875 | 2.17875 | Rhizopodaceae | 1344955 | Fungi | Fungi | 103 | 6.56e-24 | NR | RCH92229.1 | 4846 | g24043 | i0 | 61 | 7.90361445783132 | 82 | 31 | 98.8 | 1 | 3 | 248 | 339 | 419 | RCH92229.1 Ubiquitin-protein ligase, partial [Rhizopus stolonifer] | diamond | 1968 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 29894935 | 29894935 | PRJNA751877_P_NODE_27931_length_244_cov_0.900585_g27809_i0 | PRJNA751877 | 27931 | 244 | 0.900585 | 2.1974274 | Geosiphon pyriformis | 50956 | Fungi | Fungi | 74.3 | 1.86e-13 | NR | KAG9296439.1 | 50956 | g27809 | i0 | 56.7 | 1.67213114754098 | 67 | 25 | 82.4 | 1 | 33 | 233 | 173 | 235 | KAG9296439.1 hypothetical protein G9A89_015031 [Geosiphon pyriformis] | diamond | 408 | 74.3 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Geosiphonaceae | Geosiphon | Geosiphon pyriformis | |
| 30094147 | 30094147 | PRJNA751877_P_NODE_24172_length_249_cov_0.875000_g24050_i0 | PRJNA751877 | 24172 | 249 | 0.875 | 2.17875 | Fungi | 4751 | Fungi | Fungi | 79.7 | 1.61e-15 | NR | KAG2201902.1 | 97098 | g24050 | i0 | 47.6 | 2.95180722891566 | 82 | 40 | 98.8 | 1 | 248 | 3 | 17 | 95 | KAG2201902.1 hypothetical protein INT46_004622 [Mucor plumbeus] | diamond | 735 | 79.7 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor plumbeus | |
| 30589809 | 30589809 | PRJNA751877_P_NODE_28453_length_243_cov_0.905882_g28331_i0 | PRJNA751877 | 28453 | 243 | 0.905882 | 2.20129326 | Ambispora leptoticha | 144679 | Fungi | Fungi | 72.8 | 9.37e-13 | NR | CAG8539730.1 | 144679 | g28331 | i0 | 62.7 | 2.58024691358025 | 67 | 25 | 82.7 | 0 | 241 | 41 | 414 | 480 | CAG8539730.1 12640_t:CDS:2 [Ambispora leptoticha] | diamond | 627 | 72.8 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Archaeosporales | Ambisporaceae | Ambispora | Ambispora leptoticha |
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);;