contig_metadata
4 rows where analysis = "blastn", bioproject = "PRJEB3181" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7366407 | 7366407 | PRJEB3181_P_NODE_21986_length_174_cov_1.489510_g21721_i0 | PRJEB3181 | 21986 | 174 | 1.48951 | 2.5917474 | Fungi | 4751 | Fungi | Fungi | 228 | 2.2699999999999997e-55 | NTclustered | gi|2028311018|ref|XM_040884425.1| | 61395 | g21721 | i0 | 90.643 | 97.9425287356322 | 171 | 16 | 98 | 0 | 2 | 172 | 762 | 592 | Linderina pennispora Actin/actin-like protein (DL89DRAFT_219936), partial mRNA | blastn | 17042 | 230 | 0.991304347826087 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Linderina | Linderina pennispora | |
| 17907510 | 17907510 | PRJEB3181_P_NODE_11155_length_254_cov_7.210762_g10891_i0 | PRJEB3181 | 11155 | 254 | 7.210762 | 18.31533548 | Piptocephalis corymbifera | 78917 | Fungi | Fungi | 71.3 | 6.37e-8 | NTclustered | gi|311235601|ref|NG_027616.1| | 78917 | g10891 | i0 | 88.333 | 0.728346456692913 | 60 | 6 | 23 | 1 | 173 | 231 | 3234 | 3175 | Piptocephalis corymbifera NRRL 2385 28S rRNA gene, partial sequence; from reference material | blastn | 185 | 71.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Piptocephalidaceae | Piptocephalis | Piptocephalis corymbifera | |
| 23008015 | 23008015 | PRJEB3181_P_NODE_3199_length_420_cov_9.424165_g2968_i0 | PRJEB3181 | 3199 | 420 | 9.424165 | 39.581493 | Kickxella alabastrina | 61397 | Fungi | Fungi | 54.7 | 0.011 | NTclustered | gi|2324015231|ref|XM_051538911.1| | 61397 | g2968 | i0 | 100 | 0.0690476190476191 | 29 | 0 | 7 | 0 | 163 | 191 | 445 | 417 | Kickxella alabastrina uncharacterized protein (BX661DRAFT_224628), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Kickxella | Kickxella alabastrina | |
| 24281858 | 24281858 | PRJEB3181_S_NODE_15500_length_165_cov_1.246154_g15207_i0 | PRJEB3181 | 15500 | 165 | 1.246154 | 2.0561541 | Linderina pennispora | 61395 | Fungi | Fungi | 117 | 4.82e-22 | NTclustered | gi|2028311160|ref|XM_040889078.1| | 61395 | g15207 | i0 | 86.792 | 10.9818181818182 | 106 | 12 | 64 | 2 | 1 | 105 | 328 | 432 | Linderina pennispora ribosomal protein S19 (DL89DRAFT_273559), partial mRNA | blastn | 1812 | 117 | 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);;