contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA287283" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1646957 | 1646957 | PRJNA287283_P_NODE_9822_length_177_cov_1.258065_g9598_i0 | PRJNA287283 | 9822 | 177 | 1.258065 | 2.22677505 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 237 | 3.85e-58 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g9598 | i0 | 90.96 | 10.0677966101695 | 177 | 15 | 100 | 1 | 1 | 177 | 48687 | 48862 | Rhizopus oryzae mitochondrion, complete genome | blastn | 1782 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 2922849 | 2922849 | PRJNA287283_P_NODE_2483_length_416_cov_2.743802_g2260_i0 | PRJNA287283 | 2483 | 416 | 2.743802 | 11.41421632 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 758 | 0 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g2260 | i0 | 99.519 | 27.25 | 416 | 2 | 100 | 0 | 1 | 416 | 5908 | 6323 | Rhizopus oryzae mitochondrion, complete genome | blastn | 11336 | 758 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 13126022 | 13126022 | PRJNA287283_P_NODE_5191_length_263_cov_1.066667_g4967_i0 | PRJNA287283 | 5191 | 263 | 1.066667 | 2.80533421 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 464 | 2.5999999999999993e-126 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g4967 | i0 | 98.479 | 10.9543726235741 | 263 | 4 | 100 | 0 | 1 | 263 | 2922 | 2660 | Rhizopus oryzae mitochondrion, complete genome | blastn | 2881 | 464 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 15086781 | 15086781 | PRJNA287283_P_NODE_4252_length_303_cov_12.952000_g4028_i0 | PRJNA287283 | 4252 | 303 | 12.952 | 39.24456 | Eukaryota | 2759 | Fungi | Fungi | 560 | 3.79e-155 | NTclustered | gi|336126962|gb|HM172866.1| | 4846 | g4028 | i0 | 100 | 99.973597359736 | 303 | 0 | 100 | 0 | 1 | 303 | 19 | 321 | Rhizopus stolonifer culture-collection FSU<DEU>:9868 18S small subunit ribosomal RNA gene, partial sequence | blastn | 30292 | 560 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 16949573 | 16949573 | PRJNA287283_P_NODE_3494_length_340_cov_1.324042_g3270_i0 | PRJNA287283 | 3494 | 340 | 1.324042 | 4.5017428 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 623 | 5.429999999999999e-174 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g3270 | i0 | 99.706 | 27.1676470588235 | 340 | 1 | 100 | 0 | 1 | 340 | 568 | 907 | Rhizopus oryzae mitochondrion, complete genome | blastn | 9237 | 623 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 18223838 | 18223838 | PRJNA287283_P_NODE_1375_length_607_cov_1.314079_g1162_i0 | PRJNA287283 | 1375 | 607 | 1.314079 | 7.97645953 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 1099 | 0 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g1162 | i0 | 99.341 | 45.3574958813839 | 607 | 4 | 100 | 0 | 1 | 607 | 2356 | 1750 | Rhizopus oryzae mitochondrion, complete genome | blastn | 27532 | 1099 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 19498109 | 19498109 | PRJNA287283_P_NODE_2416_length_423_cov_1.372973_g2193_i0 | PRJNA287283 | 2416 | 423 | 1.372973 | 5.80767579 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 625 | 1.9099999999999995e-174 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g2193 | i0 | 92.841 | 44.886524822695 | 447 | 6 | 100 | 12 | 1 | 423 | 7049 | 6605 | Rhizopus oryzae mitochondrion, complete genome | blastn | 18987 | 625 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 19498114 | 19498114 | PRJNA287283_P_NODE_4116_length_309_cov_2.015625_g3892_i0 | PRJNA287283 | 4116 | 309 | 2.015625 | 6.22828125 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 472 | 1.87e-128 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g3892 | i0 | 94.481 | 12.126213592233 | 308 | 14 | 99 | 3 | 1 | 308 | 45 | 349 | Rhizopus oryzae mitochondrion, complete genome | blastn | 3747 | 472 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus | |
| 19498127 | 19498127 | PRJNA287283_P_NODE_8396_length_183_cov_1.292308_g8172_i0 | PRJNA287283 | 8396 | 183 | 1.292308 | 2.36492364 | Rhizopus arrhizus | 64495 | Fungi | Fungi | 339 | 1.07e-88 | NTclustered | gi|58578599|ref|NC_006836.1| | 64495 | g8172 | i0 | 100 | 11.7595628415301 | 183 | 0 | 100 | 0 | 1 | 183 | 1255 | 1073 | Rhizopus oryzae mitochondrion, complete genome | blastn | 2152 | 339 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus arrhizus |
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);;