contig_metadata
4 rows where analysis = "diamond", bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9556733 | 9556733 | PRJNA662254_P_NODE_22088_length_350_cov_1.003610_g21437_i0 | PRJNA662254 | 22088 | 350 | 1.00361 | 3.512635 | Apicomplexa | 5794 | SAR_Eukaryotes | SAR_Eukaryotes | 151 | 6.14e-42 | NR | AAK43737.1 | 5861 | g21437 | i0 | 63.6 | 11.5114285714286 | 107 | 39 | 91.7 | 0 | 3 | 323 | 127 | 233 | AAK43737.1 fructose 1,6-bisphosphate aldolase, partial [Plasmodium yoelii] | diamond | 4029 | 151 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 22305521 | 22305521 | PRJNA662254_P_NODE_25918_length_324_cov_4.836653_g25267_i0 | PRJNA662254 | 25918 | 324 | 4.836653 | 15.67075572 | Hepatocystis sp. ex Piliocolobus tephrosceles | 2600580 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 8.139999999999998e-41 | NR | VWU51230.1 | 2600580 | g25267 | i0 | 68 | 2.86111111111111 | 103 | 32 | 95.4 | 1 | 314 | 6 | 1 | 102 | VWU51230.1 60S ribosomal protein L44 [Hepatocystis sp. ex Piliocolobus tephrosceles] | diamond | 927 | 140 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Hepatocystis | Hepatocystis sp. ex Piliocolobus tephrosceles | ||
| 27965775 | 27965775 | PRJNA662254_P_NODE_46705_length_250_cov_0.870056_g46054_i0 | PRJNA662254 | 46705 | 250 | 0.870056 | 2.17514 | Cryptosporidium hominis TU5 | 237895 | SAR_Eukaryotes | SAR_Eukaryotes | 43.5 | 0.0209 | NR | XP_665661.1 | 353151 | g46054 | i0 | 34.4 | 0.768 | 64 | 40 | 74.4 | 1 | 241 | 56 | 72 | 135 | XP_665661.1 hypothetical protein [Cryptosporidium hominis TU502] | diamond | 192 | 43.5 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium hominis | ||
| 31472098 | 31472098 | PRJNA662254_P_NODE_53016_length_247_cov_0.885057_g52365_i0 | PRJNA662254 | 53016 | 247 | 0.885057 | 2.18609079 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 6.15e-14 | NR | XP_029222219.1 | 94643 | g52365 | i0 | 45.1 | 0.995951417004049 | 82 | 44 | 98.4 | 1 | 245 | 3 | 1668 | 1749 | XP_029222219.1 hypothetical protein BESB_005510 [Besnoitia besnoiti] | diamond | 246 | 76.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti |
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);;