contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 555280 | 555280 | PRJNA565584_P_NODE_155641_length_258_cov_2.491892_g154489_i0 | PRJNA565584 | 155641 | 258 | 2.491892 | 6.42908136 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 159 | 1.3499999999999999e-34 | NTclustered | gi|684989|gb|L22497.1|BSIAHSP70X | 4808 | g154489 | i0 | 78.346 | 18.484496124031 | 254 | 49 | 97 | 6 | 7 | 257 | 2758 | 2508 | Blastocladiella emersonii heat shock protein (hsp70) gene, complete cds | blastn | 4769 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 1832817 | 1832817 | PRJNA565584_P_NODE_65782_length_366_cov_1.924915_g64631_i0 | PRJNA565584 | 65782 | 366 | 1.924915 | 7.0451889 | Catenaria sp. | 2420186 | Fungi | Fungi | 318 | 3.1e-82 | NTclustered | gi|1866582684|gb|MT730859.1| | 2420186 | g64631 | i0 | 82.703 | 29.0109289617486 | 370 | 53 | 100 | 7 | 1 | 366 | 4107 | 4469 | Catenaria sp. isolate JEL0871 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 | 10618 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 8208790 | 8208790 | PRJNA565584_P_NODE_18447_length_746_cov_1.239227_g17357_i0 | PRJNA565584 | 18447 | 746 | 1.239227 | 9.24463342 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 1002 | 0 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g17357 | i0 | 91.105 | 65.1045576407507 | 742 | 62 | 99 | 4 | 1 | 740 | 566 | 1305 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 48568 | 1002 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 19682629 | 19682629 | PRJNA565584_P_NODE_20696_length_696_cov_2.309791_g19589_i0 | PRJNA565584 | 20696 | 696 | 2.309791 | 16.07614536 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 545 | 2.61e-150 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g19589 | i0 | 82.126 | 65.1551724137931 | 649 | 104 | 92 | 8 | 23 | 665 | 721 | 79 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 45348 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 21535772 | 21535772 | PRJNA565584_P_NODE_120137_length_282_cov_0.885167_g118985_i0 | PRJNA565584 | 120137 | 282 | 0.885167 | 2.49617094 | Eukaryota | 2759 | Fungi | Fungi | 215 | 3.13e-51 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g118985 | i0 | 81.004 | 95.1347517730496 | 279 | 45 | 98 | 6 | 8 | 282 | 2005 | 2279 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 26828 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22234430 | 22234430 | PRJNA565584_P_NODE_64438_length_370_cov_1.377104_g63287_i0 | PRJNA565584 | 64438 | 370 | 1.377104 | 5.0952848 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 392 | 1.82e-104 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g63287 | i0 | 86.592 | 52.9810810810811 | 358 | 45 | 97 | 1 | 1 | 358 | 430 | 76 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 19603 | 392 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;