contig_metadata
4 rows where bioproject = "PRJNA509429", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1110775 | 1110775 | PRJNA509429_P_NODE_33461_length_207_cov_1.360465_g32633_i0 | PRJNA509429 | 33461 | 207 | 1.360465 | 2.81616255 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 62.1 | 3.01e-5 | NTclustered | gi|14329719|emb|AJ301624.1| | 5821 | g32633 | i0 | 94.872 | 9.55072463768116 | 39 | 2 | 19 | 0 | 167 | 205 | 3530 | 3492 | Plasmodium berghei 28S rRNA gene, strain ANKA | blastn | 1977 | 62.1 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 8138325 | 8138325 | PRJNA509429_P_NODE_34767_length_201_cov_1.445783_g33939_i0 | PRJNA509429 | 34767 | 201 | 1.445783 | 2.90602383 | Plasmodium gallinaceum | 5849 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 2.69e-60 | NTclustered | gi|1620122713|ref|XM_028672112.1| | 5849 | g33939 | i0 | 91.525 | 132.004975124378 | 177 | 15 | 88 | 0 | 2 | 178 | 52 | 228 | Plasmodium gallinaceum polyubiquitin, putative (PGAL8A_00310100), partial mRNA | blastn | 26533 | 244 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium gallinaceum | ||
| 10689040 | 10689040 | PRJNA509429_P_NODE_41989_length_175_cov_1.085714_g41161_i0 | PRJNA509429 | 41989 | 175 | 1.085714 | 1.8999995 | Coccidia sp. PA5 | 2565587 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.84e-26 | NTclustered | gi|1664596163|dbj|LC474289.1| | 2565587 | g41161 | i0 | 89.091 | 61.2857142857143 | 110 | 6 | 62 | 5 | 68 | 175 | 186 | 81 | Coccidia sp. PA5 gene for 18S ribosomal RNA, partial sequence | blastn | 10725 | 132 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Coccidia sp. PA5 | |||||
| 19611317 | 19611317 | PRJNA509429_P_NODE_47256_length_160_cov_1.904000_g46428_i0 | PRJNA509429 | 47256 | 160 | 1.904 | 3.0464 | Isospora sp. 1 JRB-2013 | 1331023 | SAR_Eukaryotes | SAR_Eukaryotes | 75 | 2.83e-9 | NTclustered | gi|695117977|gb|KF815278.1| | 1331023 | g46428 | i0 | 92.308 | 0.8875 | 52 | 4 | 33 | 0 | 24 | 75 | 373 | 322 | Isospora sp. 1 JRB-2013 23S ribosomal RNA gene, partial sequence; plastid | blastn | 142 | 75 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Isospora | Isospora sp. 1 JRB-2013 |
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);;