contig_metadata
3 rows where bioproject = "PRJNA1101048", tax_clade = "Sar" and tax_phylum = "Apicomplexa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12965053 | 12965053 | PRJNA1101048_P_NODE_3991_length_312_cov_1.171548_g3935_i0 | PRJNA1101048 | 3991 | 312 | 1.171548 | 3.65522976 | Goussia balatonica | 947538 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 5.52e-94 | NTclustered | gi|324022100|gb|GU593717.1| | 947538 | g3935 | i0 | 95.909 | 69.025641025641 | 220 | 8 | 70 | 1 | 4 | 222 | 1787 | 2006 | Goussia balatonica strain 608 28S ribosomal RNA gene, partial sequence | blastn | 21536 | 357 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia balatonica | ||
| 20612407 | 20612407 | PRJNA1101048_P_NODE_3217_length_338_cov_1.162264_g3161_i0 | PRJNA1101048 | 3217 | 338 | 1.162264 | 3.92845232 | Goussia bayae | 2303416 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 4.669999999999999e-95 | NTclustered | gi|1450318675|gb|MH758782.1| | 2303416 | g3161 | i0 | 88.235 | 84.6272189349112 | 306 | 30 | 89 | 6 | 10 | 311 | 330 | 27 | Goussia bayae isolate Choptank large subunit ribosomal RNA gene, partial sequence | blastn | 28604 | 361 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Goussia | Goussia bayae | ||
| 32808598 | 32808598 | PRJNA1101048_P_NODE_7820_length_249_cov_0.886364_g7764_i0 | PRJNA1101048 | 7820 | 249 | 0.886364 | 2.20704636 | Babesia | 5864 | SAR_Eukaryotes | SAR_Eukaryotes | 42.7 | 0.0425 | NR | GFE53323.1 | 5869 | g7764 | i0 | 40.4 | 1.13253012048193 | 47 | 23 | 50.6 | 1 | 73 | 198 | 1233 | 1279 | GFE53323.1 SNF2 family N-terminal domain containing protein [Babesia ovis] | diamond | 282 | 42.7 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia ovis |
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);;