contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 283639 | 283639 | PRJNA1132896_P_NODE_5081_length_273_cov_2.280000_g4990_i0 | PRJNA1132896 | 5081 | 273 | 2.28 | 6.2244 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 158 | 5.16e-34 | NTclustered | gi|1069948066|ref|XM_018429500.1| | 763407 | g4990 | i0 | 77.612 | 8.09157509157509 | 268 | 55 | 97 | 5 | 1 | 264 | 446 | 180 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 2209 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 5386797 | 5386797 | PRJNA1132896_P_NODE_1305_length_458_cov_1.038961_g1214_i0 | PRJNA1132896 | 1305 | 458 | 1.038961 | 4.75844138 | Mycotypha africana | 64632 | Fungi | Fungi | 189 | 3.2499999999999992e-43 | NTclustered | gi|2432561609|ref|XM_053077210.1| | 64632 | g1214 | i0 | 80.723 | 16.3558951965066 | 249 | 42 | 54 | 6 | 3 | 248 | 148 | 393 | Mycotypha africana 40S ribosomal protein S16 (BDF20DRAFT_816965), partial mRNA | blastn | 7491 | 189 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mycotyphaceae | Mycotypha | Mycotypha africana | |
| 11762210 | 11762210 | PRJNA1132896_P_NODE_1470_length_435_cov_1.008287_g1379_i0 | PRJNA1132896 | 1470 | 435 | 1.008287 | 4.38604845 | Radiomyces spectabilis | 64574 | Fungi | Fungi | 398 | 4.679999999999998e-106 | NTclustered | gi|2323718658|ref|XM_051562801.1| | 64574 | g1379 | i0 | 83.527 | 182.347126436782 | 431 | 66 | 98 | 5 | 1 | 428 | 283 | 711 | Radiomyces spectabilis ubiquitin-related domain-containing protein (BYT42DRAFT_271756), mRNA | blastn | 79321 | 398 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Radiomycetaceae | Radiomyces | Radiomyces spectabilis | |
| 23235922 | 23235922 | PRJNA1132896_P_NODE_3059_length_320_cov_0.923077_g2968_i0 | PRJNA1132896 | 3059 | 320 | 0.923077 | 2.9538464 | Mucor velutinosus | 708070 | Fungi | Fungi | 220 | 7.77e-53 | NTclustered | gi|2724930861|ref|XM_064822107.1| | 708070 | g2968 | i0 | 81.852 | 14.63125 | 270 | 41 | 83 | 7 | 2 | 267 | 1126 | 1391 | Mucor velutinosus uncharacterized protein (ATC70_002737), partial mRNA | blastn | 4682 | 220 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor velutinosus | |
| 23235941 | 23235941 | PRJNA1132896_P_NODE_5099_length_273_cov_1.695000_g5008_i0 | PRJNA1132896 | 5099 | 273 | 1.695 | 4.62735 | Mucor mucedo | 29922 | Fungi | Fungi | 154 | 6.68e-33 | NTclustered | gi|2324046031|ref|XM_051597563.1| | 29922 | g5008 | i0 | 80.383 | 3.37362637362637 | 209 | 35 | 75 | 6 | 10 | 215 | 135 | 340 | Mucor mucedo 60S ribosomal protein L37a (EV154DRAFT_461754), mRNA | blastn | 921 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Mucor | Mucor mucedo |
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);;