contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA1146029" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 290159 | 290159 | PRJNA1146029_P_NODE_221_length_1635_cov_5.192702_g146_i0 | PRJNA1146029 | 221 | 1635 | 5.192702 | 84.9006777 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 695 | 1.1399999999999996e-247 | NR | MES1909605.1 | 1215613 | g146 | i0 | 77.1 | 4.86422018348624 | 433 | 99 | 79.4 | 0 | 18 | 1316 | 1 | 433 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 7953 | 701 | 0.991440798858773 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 4117132 | 4117132 | PRJNA1146029_P_NODE_1964_length_622_cov_1.681239_g1693_i0 | PRJNA1146029 | 1964 | 622 | 1.681239 | 10.45730658 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 1.6599999999999996e-87 | NR | MES1911029.1 | 1215613 | g1693 | i0 | 64.2 | 2.02090032154341 | 212 | 71 | 99.8 | 3 | 621 | 1 | 45 | 256 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1257 | 270 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27639443 | 27639443 | PRJNA1146029_P_NODE_3024_length_492_cov_1.684964_g2747_i0 | PRJNA1146029 | 3024 | 492 | 1.684964 | 8.29002288 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 202 | 3.74e-62 | NR | ADK26624.1 | 323453 | g2747 | i0 | 74.2 | 0.804878048780488 | 132 | 34 | 80.5 | 0 | 491 | 96 | 145 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 396 | 202 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 28018253 | 28018253 | PRJNA1146029_P_NODE_6265_length_352_cov_2.483871_g5987_i0 | PRJNA1146029 | 6265 | 352 | 2.483871 | 8.74322592 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 142 | 4.06e-39 | NR | MES1907458.1 | 1215613 | g5987 | i0 | 69.7 | 0.84375 | 99 | 30 | 84.4 | 0 | 54 | 350 | 4 | 102 | MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 297 | 142 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 28112728 | 28112728 | PRJNA1146029_P_NODE_20185_length_244_cov_0.900585_g19904_i0 | PRJNA1146029 | 20185 | 244 | 0.900585 | 2.1974274 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 6.7e-4 | NR | MES1909680.1 | 1215613 | g19904 | i0 | 76.9 | 0.577868852459016 | 26 | 6 | 32 | 0 | 2 | 79 | 1367 | 1392 | MES1909680.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 141 | 47.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29375798 | 29375798 | PRJNA1146029_P_NODE_5869_length_362_cov_1.754325_g5591_i0 | PRJNA1146029 | 5869 | 362 | 1.754325 | 6.3506565 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 73.9 | 1.04e-12 | NR | MES1907597.1 | 1215613 | g5591 | i0 | 64.7 | 0.422651933701657 | 51 | 18 | 42.3 | 0 | 208 | 360 | 2 | 52 | MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 153 | 73.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32568574 | 32568574 | PRJNA1146029_P_NODE_11639_length_280_cov_1.487923_g11358_i0 | PRJNA1146029 | 11639 | 280 | 1.487923 | 4.1661844 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.69e-26 | NR | AAT09077.1 | 227086 | g11358 | i0 | 64.7 | 0.910714285714286 | 85 | 30 | 91.1 | 0 | 256 | 2 | 1 | 85 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 255 | 105 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 32631085 | 32631085 | PRJNA1146029_P_NODE_5280_length_379_cov_1.169935_g5002_i0 | PRJNA1146029 | 5280 | 379 | 1.169935 | 4.43405365 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 146 | 6.51e-42 | NR | AAY21202.1 | 227086 | g5002 | i0 | 60.3 | 3.82321899736148 | 121 | 47 | 95.8 | 1 | 16 | 378 | 17 | 136 | AAY21202.1 Rpl7A, partial [Bigelowiella natans] | diamond | 1449 | 146 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans |
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);;