contig_metadata
2 rows where bioproject = "PRJNA454503" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13196043 | 13196043 | PRJNA454503_P_NODE_4311_length_562_cov_1713.045908_g3995_i0 | PRJNA454503 | 4311 | 562 | 1713.045908 | 9627.31800296 | Amorphochlora amoebiformis | 1561963 | SAR_Eukaryotes | SAR_Eukaryotes | 73.1 | 4.25e-8 | NTclustered | gi|893150443|dbj|AB996604.1| | 1561963 | g3995 | i0 | 80.18 | 9.47508896797153 | 111 | 10 | 19 | 11 | 455 | 562 | 766 | 867 | Amorphochlora amoebiformis nucleomorph DNA, chromosome: 3, complete sequence, strain: CCMP2058 | blastn | 5325 | 73.1 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Amorphochlora | Amorphochlora amoebiformis | ||||
| 16396496 | 16396496 | PRJNA454503_P_NODE_88893_length_193_cov_2.007576_g88564_i0 | PRJNA454503 | 88893 | 193 | 2.007576 | 3.87462168 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 115 | 2.09e-21 | NTclustered | gi|88792585|gb|DQ386166.1| | 1979842 | g88564 | i0 | 83.607 | 44.9481865284974 | 122 | 20 | 63 | 0 | 60 | 181 | 1542 | 1421 | Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence | blastn | 8675 | 115 | 1 | Eukaryota | Sar | Cercozoa | Mesofilidae | Mesofila | Mesofila limnetica |
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);;