contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA416866" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1083771 | 1083771 | PRJNA416866_P_NODE_9381_length_209_cov_4.324324_g9237_i0 | PRJNA416866 | 9381 | 209 | 4.324324 | 9.03783716 | Fungi | 4751 | Fungi | Fungi | 387 | 4.42e-103 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g9237 | i0 | 100 | 147.033492822967 | 209 | 0 | 100 | 0 | 1 | 209 | 1993 | 2201 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 30730 | 387 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 2970358 | 2970358 | PRJNA416866_P_NODE_5123_length_289_cov_44.267544_g4979_i0 | PRJNA416866 | 5123 | 289 | 44.267544 | 127.93320216 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 281 | 3.13e-71 | NTclustered | gi|2323695494|ref|XM_051584821.1| | 1314678 | g4979 | i0 | 85.091 | 251.010380622837 | 275 | 41 | 96 | 0 | 7 | 281 | 87 | 361 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_214084), mRNA | blastn | 72542 | 281 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 4246689 | 4246689 | PRJNA416866_P_NODE_12224_length_186_cov_7.384000_g12080_i0 | PRJNA416866 | 12224 | 186 | 7.384 | 13.73424 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 82.4 | 2.03e-11 | NTclustered | gi|1069953767|ref|XM_018429605.1| | 763407 | g12080 | i0 | 92.857 | 0.956989247311828 | 56 | 4 | 30 | 0 | 77 | 132 | 521 | 576 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 178 | 82.4 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 10623534 | 10623534 | PRJNA416866_P_NODE_4349_length_316_cov_1.733333_g4206_i0 | PRJNA416866 | 4349 | 316 | 1.733333 | 5.47733228 | Umbelopsis isabellina | 91625 | Fungi | Fungi | 244 | 4.55e-60 | NTclustered | gi|11078267|gb|AF157300.1|AF157300 | 91625 | g4206 | i0 | 83.032 | 65.1962025316456 | 277 | 40 | 86 | 6 | 44 | 316 | 982 | 1255 | Umbelopsis isabellina translation elongation factor 1-alpha (EF-1alpha) gene, partial cds | blastn | 20602 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis isabellina | |
| 11898458 | 11898458 | PRJNA416866_P_NODE_11150_length_203_cov_1.338028_g11006_i0 | PRJNA416866 | 11150 | 203 | 1.338028 | 2.71619684 | Absidia idahoensis | 572091 | Fungi | Fungi | 198 | 2.1499999999999998e-46 | NTclustered | gi|210161799|gb|EU826383.1| | 572091 | g11006 | i0 | 84.772 | 91.6453201970443 | 197 | 30 | 97 | 0 | 6 | 202 | 628 | 824 | Absidia idahoensis strain FSU6198 clone 2 translation elongation factor 1alpha gene, partial cds | blastn | 18604 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Absidia | Absidia idahoensis | |
| 15722357 | 15722357 | PRJNA416866_P_NODE_9313_length_210_cov_2.536913_g9169_i0 | PRJNA416866 | 9313 | 210 | 2.536913 | 5.3275173 | Mucor racemosus | 4841 | Fungi | Fungi | 388 | 1.24e-103 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g9169 | i0 | 100 | 37.6714285714286 | 210 | 0 | 100 | 0 | 1 | 210 | 3984 | 3775 | Mucor racemosus strain ATCC 42647 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 7911 | 388 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 18271296 | 18271296 | PRJNA416866_P_NODE_5455_length_280_cov_1.168950_g5311_i0 | PRJNA416866 | 5455 | 280 | 1.16895 | 3.27306 | Rhizopus delemar | 936053 | Fungi | Fungi | 222 | 1.86e-53 | NTclustered | gi|2797475454|ref|XM_067666893.1| | 246409 | g5311 | i0 | 83.613 | 29.4857142857143 | 238 | 38 | 85 | 1 | 24 | 260 | 303 | 66 | Rhizopus delemar RA 99-880 60S ribosomal protein eL42 (RO3G_12309), partial mRNA | blastn | 8256 | 222 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar | |
| 22096101 | 22096101 | PRJNA416866_P_NODE_6538_length_255_cov_0.969072_g6394_i0 | PRJNA416866 | 6538 | 255 | 0.969072 | 2.4711336 | Rhizopus delemar | 936053 | Fungi | Fungi | 189 | 1.69e-43 | NTclustered | gi|2797463157|ref|XM_067662474.1| | 246409 | g6394 | i0 | 86.364 | 25.7686274509804 | 176 | 21 | 68 | 3 | 2 | 175 | 289 | 115 | Rhizopus delemar RA 99-880 60S ribosomal protein L3 (RO3G_07884), partial mRNA | blastn | 6571 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus delemar |
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);;