contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA683902" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5004111 | 5004111 | PRJNA683902_S_NODE_39404_length_151_cov_2.666667_g38960_i0 | PRJNA683902 | 39404 | 151 | 2.666667 | 4.02666717 | Fungi | 4751 | Fungi | Fungi | 279 | 5.19e-71 | NTclustered | gi|1694443677|ref|NG_065498.1| | 4841 | g38960 | i0 | 100 | 100.013245033113 | 151 | 0 | 100 | 0 | 1 | 151 | 790 | 640 | Mucor racemosus NRRL 3640 18S rRNA gene, partial sequence; from TYPE material | blastn | 15102 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 7044070 | 7044070 | PRJNA683902_S_NODE_40086_length_150_cov_1.230088_g39642_i0 | PRJNA683902 | 40086 | 150 | 1.230088 | 1.845132 | Halteromyces radiatus | 101107 | Fungi | Fungi | 167 | 4.18e-37 | NTclustered | gi|2323730602|ref|XM_051542191.1| | 101107 | g39642 | i0 | 86.667 | 90.8133333333333 | 150 | 20 | 100 | 0 | 1 | 150 | 1278 | 1129 | Halteromyces radiatus translation elongation factor EF-1 alpha (BX664DRAFT_296209), mRNA | blastn | 13622 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Cunninghamellaceae | Halteromyces | Halteromyces radiatus | |
| 15968022 | 15968022 | PRJNA683902_S_NODE_29053_length_182_cov_2.241379_g28609_i0 | PRJNA683902 | 29053 | 182 | 2.241379 | 4.07930978 | Mucor racemosus | 4841 | Fungi | Fungi | 322 | 1.07e-83 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g28609 | i0 | 98.895 | 96.4010989010989 | 181 | 1 | 99 | 1 | 1 | 181 | 2383 | 2204 | 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 | 17545 | 322 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 18517408 | 18517408 | PRJNA683902_S_NODE_28035_length_187_cov_1.280000_g27591_i0 | PRJNA683902 | 28035 | 187 | 1.28 | 2.3936 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 141 | 3.32e-29 | NTclustered | gi|2323686361|ref|XM_051588234.1| | 1314678 | g27591 | i0 | 81.609 | 17.7005347593583 | 174 | 29 | 93 | 1 | 5 | 178 | 390 | 560 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_236303), mRNA | blastn | 3310 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 21067762 | 21067762 | PRJNA683902_S_NODE_27517_length_189_cov_3.467105_g27073_i0 | PRJNA683902 | 27517 | 189 | 3.467105 | 6.55282845 | Mucor racemosus | 4841 | Fungi | Fungi | 348 | 1.85e-91 | NTclustered | gi|225134681|gb|FJ345353.1| | 4841 | g27073 | i0 | 100 | 30.1269841269841 | 188 | 0 | 99 | 0 | 2 | 189 | 3975 | 3788 | 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 | 5694 | 348 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 22852607 | 22852607 | PRJNA683902_S_NODE_16398_length_282_cov_2.314286_g15954_i0 | PRJNA683902 | 16398 | 282 | 2.314286 | 6.52628652 | Mucor | 4830 | Fungi | Fungi | 516 | 7.67e-142 | NTclustered | gi|2580278665|gb|OR581588.1| | 4841 | g15954 | i0 | 99.645 | 96.8120567375886 | 282 | 1 | 100 | 0 | 1 | 282 | 898 | 617 | Mucor racemosus culture VKM:F-579 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 27301 | 516 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor racemosus | |
| 23618200 | 23618200 | PRJNA683902_S_NODE_29859_length_179_cov_1.549296_g29415_i0 | PRJNA683902 | 29859 | 179 | 1.549296 | 2.77323984 | Mucoraceae sp. AI-2023a | 3108396 | Fungi | Fungi | 73.1 | 1.16e-8 | NTclustered | gi|2715569655|gb|OR965928.1| | 3108396 | g29415 | i0 | 93.75 | 0.53072625698324 | 48 | 3 | 27 | 0 | 3 | 50 | 1676 | 1723 | Mucoraceae sp. AI-2023a actin gene, complete cds | blastn | 95 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucoraceae sp. AI-2023a | ||
| 25401731 | 25401731 | PRJNA683902_S_NODE_17320_length_268_cov_53.519481_g16876_i0 | PRJNA683902 | 17320 | 268 | 53.519481 | 143.43220908 | Fungi | 4751 | Fungi | Fungi | 468 | 2.06e-127 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g16876 | i0 | 98.134 | 144.186567164179 | 268 | 5 | 100 | 0 | 1 | 268 | 2262 | 1995 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 38642 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita |
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);;