contig_metadata
3 rows where bioproject = "PRJNA1020641" and tax_phylum = "Fornicata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15463297 | 15463297 | PRJNA1020641_P_NODE_2233_length_410_cov_1.246291_g2190_i0 | PRJNA1020641 | 2233 | 410 | 1.246291 | 5.1097931 | Aduncisulcus paluster | 2918883 | Fornicata | other_Eukaryota | 109 | 1.24e-24 | NR | GKT16506.1 | 2918883 | g2190 | i0 | 45.9 | 1.94634146341463 | 133 | 69 | 96.6 | 2 | 399 | 4 | 864 | 994 | GKT16506.1 Dynein-1-alpha heavy chain, flagellar inner arm I1 complex, partial [Aduncisulcus paluster] | diamond | 798 | 109 | 1 | Eukaryota | Metamonada | Fornicata | Aduncisulcus | Aduncisulcus paluster | |||||
| 30951343 | 30951343 | PRJNA1020641_P_NODE_1814_length_453_cov_1.010526_g1771_i0 | PRJNA1020641 | 1814 | 453 | 1.010526 | 4.57768278 | Hexamita inflata | 28002 | Fornicata | other_Eukaryota | 86.3 | 2.13e-17 | NR | CAK8748151.1 | 28002 | g1771 | i0 | 33.3 | 1.90066225165563 | 138 | 92 | 91.4 | 0 | 445 | 32 | 75 | 212 | CAK8748151.1 HINF_077559 [Hexamita inflata] | diamond | 861 | 86.3 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata | |||
| 31796899 | 31796899 | PRJNA1020641_P_NODE_5137_length_262_cov_0.962963_g5094_i0 | PRJNA1020641 | 5137 | 262 | 0.962963 | 2.52296306 | root | 1 | Root_unresolved | Root_unresolved | 43.1 | 0.0362 | NR | CAK8776420.1 | 28002 | g5094 | i0 | 26.8 | 1.59160305343511 | 82 | 49 | 93.9 | 2 | 258 | 13 | 967 | 1037 | CAK8776420.1 HINF_085509 [Hexamita inflata] | diamond | 417 | 43.1 | 1 | Eukaryota | Metamonada | Fornicata | Diplomonadida | Hexamitidae | Hexamita | Hexamita inflata |
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);;