contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3847537 | 3847537 | PRJEB14803_P_NODE_11064_length_381_cov_5.800578_g10599_i0 | PRJEB14803 | 11064 | 381 | 5.800578 | 22.10020218 | Linderina pennispora | 61395 | Fungi | Fungi | 193 | 2.05e-44 | NTclustered | gi|2028312556|ref|XM_040884444.1| | 61395 | g10599 | i0 | 84.536 | 58.0813648293963 | 194 | 30 | 51 | 0 | 73 | 266 | 48 | 241 | Linderina pennispora 40S ribosomal protein S27 (DL89DRAFT_220296), partial mRNA | blastn | 22129 | 193 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 3847649 | 3847649 | PRJEB14803_P_NODE_29844_length_198_cov_2.177914_g29378_i0 | PRJEB14803 | 29844 | 198 | 2.177914 | 4.31226972 | Linderina pennispora | 61395 | Fungi | Fungi | 183 | 5.829999999999998e-42 | NTclustered | gi|2028323584|ref|XM_040889307.1| | 61395 | g29378 | i0 | 83.333 | 14.0050505050505 | 198 | 33 | 100 | 0 | 1 | 198 | 394 | 197 | Linderina pennispora ADP-ribosylation factor Arf1 (DL89DRAFT_275448), partial mRNA | blastn | 2773 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 5123892 | 5123892 | PRJEB14803_P_NODE_34865_length_180_cov_1.655172_g34399_i0 | PRJEB14803 | 34865 | 180 | 1.655172 | 2.9793096 | Linderina pennispora | 61395 | Fungi | Fungi | 111 | 2.48e-20 | NTclustered | gi|2028314402|ref|XM_040886511.1| | 61395 | g34399 | i0 | 80.537 | 2.23333333333333 | 149 | 25 | 82 | 3 | 3 | 149 | 738 | 592 | Linderina pennispora uncharacterized protein (DL89DRAFT_265090), mRNA | blastn | 402 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 6399641 | 6399641 | PRJEB14803_P_NODE_37146_length_173_cov_1.739130_g36680_i0 | PRJEB14803 | 37146 | 173 | 1.73913 | 3.0086949 | Linderina pennispora | 61395 | Fungi | Fungi | 163 | 6.43e-36 | NTclustered | gi|2028314418|ref|XM_040892158.1| | 61395 | g36680 | i0 | 84.211 | 80.4335260115607 | 171 | 23 | 98 | 2 | 5 | 173 | 1011 | 843 | Linderina pennispora ATP-utilizing phosphoenolpyruvate carboxykinase (DL89DRAFT_84934), mRNA | blastn | 13915 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 22973333 | 22973333 | PRJEB14803_P_NODE_14459_length_320_cov_11.164912_g13993_i0 | PRJEB14803 | 14459 | 320 | 11.164912 | 35.7277184 | Linderina pennispora | 61395 | Fungi | Fungi | 110 | 1.76e-19 | NTclustered | gi|2028314590|ref|XM_040891227.1| | 61395 | g13993 | i0 | 79.355 | 10.365625 | 155 | 32 | 48 | 0 | 124 | 278 | 201 | 47 | Linderina pennispora ribosomal 60S subunit protein L39 (DL89DRAFT_320715), partial mRNA | blastn | 3317 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora |
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);;