contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA986547" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1272333 | 1272333 | PRJNA986547_P_NODE_8101_length_253_cov_4.622222_g8019_i0 | PRJNA986547 | 8101 | 253 | 4.622222 | 11.69422166 | Rhizopus | 4842 | Fungi | Fungi | 468 | 1.92e-127 | NTclustered | gi|1493534650|gb|MK070014.1| | 4846 | g8019 | i0 | 100 | 96.102766798419 | 253 | 0 | 100 | 0 | 1 | 253 | 254 | 2 | Rhizopus stolonifer strain M7RJF large subunit ribosomal RNA gene, partial sequence | blastn | 24314 | 468 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 6077448 | 6077448 | PRJNA986547_P_NODE_5225_length_277_cov_1.240196_g5143_i0 | PRJNA986547 | 5225 | 277 | 1.240196 | 3.43534292 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 106 | 1.93e-18 | NTclustered | gi|1069953767|ref|XM_018429605.1| | 763407 | g5143 | i0 | 82.906 | 15.7039711191336 | 117 | 20 | 42 | 0 | 1 | 117 | 479 | 595 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 4350 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 7351979 | 7351979 | PRJNA986547_P_NODE_4506_length_284_cov_10.203791_g4424_i0 | PRJNA986547 | 4506 | 284 | 10.203791 | 28.97876644 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 117 | 9.17e-22 | NTclustered | gi|1069960134|ref|XM_018440121.1| | 763407 | g4424 | i0 | 82.014 | 1.76760563380282 | 139 | 23 | 49 | 2 | 108 | 245 | 212 | 75 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 502 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 10200852 | 10200852 | PRJNA986547_P_NODE_11748_length_242_cov_0.911243_g11666_i0 | PRJNA986547 | 11748 | 242 | 0.911243 | 2.20520806 | Fungi | 4751 | Fungi | Fungi | 440 | 3.9799999999999986e-119 | NTclustered | gi|1493534650|gb|MK070014.1| | 4846 | g11666 | i0 | 99.587 | 99.5826446280992 | 242 | 0 | 99 | 1 | 2 | 242 | 561 | 320 | Rhizopus stolonifer strain M7RJF large subunit ribosomal RNA gene, partial sequence | blastn | 24099 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 14026118 | 14026118 | PRJNA986547_P_NODE_13131_length_234_cov_4.409938_g13049_i0 | PRJNA986547 | 13131 | 234 | 4.409938 | 10.31925492 | Eukaryota | 2759 | Fungi | Fungi | 433 | 6.41e-117 | NTclustered | gi|1272210360|gb|KY780631.1| | 4846 | g13049 | i0 | 100 | 99.9786324786325 | 234 | 0 | 100 | 0 | 1 | 234 | 637 | 870 | Rhizopus stolonifer strain cy3 18S ribosomal RNA gene, partial sequence | blastn | 23395 | 433 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer | |
| 24223888 | 24223888 | PRJNA986547_P_NODE_12599_length_238_cov_2.454545_g12517_i0 | PRJNA986547 | 12599 | 238 | 2.454545 | 5.8418171 | Rhizopus | 4842 | Fungi | Fungi | 440 | 3.899999999999999e-119 | NTclustered | gi|734668976|gb|KJ408540.1| | 4846 | g12517 | i0 | 100 | 100.008403361345 | 238 | 0 | 100 | 0 | 1 | 238 | 293 | 56 | Rhizopus stolonifer strain FSU9872 18S ribosomal RNA gene, partial sequence | blastn | 23802 | 440 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus stolonifer |
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);;