contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 616784 | 616784 | PRJNA641707_P_NODE_5781_length_878_cov_23.717732_g4329_i0 | PRJNA641707 | 5781 | 878 | 23.717732 | 208.24168696 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 200 | 2.99e-46 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g4329 | i0 | 76.845 | 16.125284738041 | 393 | 68 | 44 | 15 | 1 | 382 | 2470 | 2090 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 14158 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 12637029 | 12637029 | PRJNA641707_P_NODE_48050_length_312_cov_5.653992_g45396_i0 | PRJNA641707 | 48050 | 312 | 5.653992 | 17.64045504 | Fungi | 4751 | Fungi | Fungi | 111 | 4.74e-20 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g45396 | i0 | 86.869 | 31.7948717948718 | 99 | 13 | 32 | 0 | 210 | 308 | 1637 | 1539 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 9920 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 13365846 | 13365846 | PRJNA641707_P_NODE_140231_length_242_cov_2.352332_g137568_i0 | PRJNA641707 | 140231 | 242 | 2.352332 | 5.69264344 | Physoderma sp. | 2012393 | Fungi | Fungi | 158 | 4.49e-34 | NTclustered | gi|1953481382|gb|MW448404.1| | 2012393 | g137568 | i0 | 96.809 | 25.995867768595 | 94 | 3 | 39 | 0 | 2 | 95 | 354 | 447 | Physoderma sp. voucher UWA:M.J. Barbetti 2a large subunit ribosomal RNA gene, partial sequence | blastn | 6291 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma sp. | |
| 20283281 | 20283281 | PRJNA641707_P_NODE_21536_length_469_cov_8.866667_g18998_i0 | PRJNA641707 | 21536 | 469 | 8.866667 | 41.58466823 | Fungi | 4751 | Fungi | Fungi | 350 | 1.44e-91 | NTclustered | gi|321173705|gb|HQ888686.1| | 28583 | g18998 | i0 | 92.975 | 51.2665245202559 | 242 | 14 | 51 | 3 | 228 | 468 | 711 | 950 | Allomyces macrogynus strain Australia 3 18S ribosomal RNA gene, partial sequence | blastn | 24044 | 353 | 0.991501416430595 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 23570214 | 23570214 | PRJNA641707_P_NODE_89679_length_246_cov_5.781726_g87016_i0 | PRJNA641707 | 89679 | 246 | 5.781726 | 14.22304596 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 150 | 7.659999999999999e-32 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g87016 | i0 | 95.699 | 1.82926829268293 | 93 | 4 | 38 | 0 | 9 | 101 | 3257 | 3349 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 450 | 150 | 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);;