contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJNA760904" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10946307 | 10946307 | PRJNA760904_P_NODE_10809_length_281_cov_0.899038_g10752_i0 | PRJNA760904 | 10809 | 281 | 0.899038 | 2.52629678 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 4.71e-36 | NR | MES1911029.1 | 1215613 | g10752 | i0 | 72.8 | 0.98220640569395 | 92 | 25 | 98.2 | 0 | 281 | 6 | 57 | 148 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 276 | 134 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27274413 | 27274413 | PRJNA760904_P_NODE_21143_length_233_cov_2.681250_g21086_i0 | PRJNA760904 | 21143 | 233 | 2.68125 | 6.2473125 | Bigelowiella natans | 227086 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 2.44e-37 | NR | AAT09077.1 | 227086 | g21086 | i0 | 85.7 | 0.991416309012876 | 77 | 11 | 99.1 | 0 | 2 | 232 | 31 | 107 | AAT09077.1 transcription factor BTF3 [Bigelowiella natans] | diamond | 231 | 132 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Bigelowiella | Bigelowiella natans | ||||
| 29232191 | 29232191 | PRJNA760904_P_NODE_6109_length_351_cov_1.107914_g6052_i0 | PRJNA760904 | 6109 | 351 | 1.107914 | 3.88877814 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 42.4 | 0.0176 | NR | MES1915915.1 | 1215613 | g6052 | i0 | 39.7 | 1.06837606837607 | 63 | 37 | 53 | 1 | 302 | 117 | 1 | 63 | MES1915915.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 375 | 42.4 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 29926905 | 29926905 | PRJNA760904_P_NODE_5751_length_360_cov_0.912892_g5694_i0 | PRJNA760904 | 5751 | 360 | 0.912892 | 3.2864112 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 1.21e-20 | NR | MES1913197.1 | 1215613 | g5694 | i0 | 43.7 | 1.63333333333333 | 103 | 54 | 82.5 | 2 | 307 | 11 | 57 | 159 | MES1913197.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 588 | 92.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30179363 | 30179363 | PRJNA760904_P_NODE_10872_length_280_cov_1.473430_g10815_i0 | PRJNA760904 | 10872 | 280 | 1.47343 | 4.125604 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 3.11e-11 | NR | MES1907578.1 | 1215613 | g10815 | i0 | 39.3 | 0.9 | 84 | 50 | 88.9 | 1 | 250 | 2 | 104 | 187 | MES1907578.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 252 | 68.9 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32298108 | 32298108 | PRJNA760904_P_NODE_19719_length_242_cov_2.272189_g19662_i0 | PRJNA760904 | 19719 | 242 | 2.272189 | 5.49869738 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 4.849999999999999e-37 | NR | BAJ14652.1 | 717846 | g19662 | i0 | 85 | 0.991735537190083 | 80 | 12 | 99.2 | 0 | 240 | 1 | 296 | 375 | BAJ14652.1 elongation factor like, partial [Thaumatomastix sp. NIES-2378] | diamond | 240 | 137 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 32676684 | 32676684 | PRJNA760904_P_NODE_16980_length_247_cov_0.885057_g16923_i0 | PRJNA760904 | 16980 | 247 | 0.885057 | 2.18609079 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 51.2 | 2.03e-5 | NR | MES1916608.1 | 1215613 | g16923 | i0 | 37.7 | 1.68825910931174 | 69 | 42 | 83.8 | 1 | 207 | 1 | 3 | 70 | MES1916608.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 417 | 51.2 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 32802743 | 32802743 | PRJNA760904_P_NODE_14760_length_251_cov_0.865169_g14703_i0 | PRJNA760904 | 14760 | 251 | 0.865169 | 2.17157419 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 50.8 | 5.78e-5 | NR | MES1911702.1 | 1215613 | g14703 | i0 | 42.9 | 0.669322709163347 | 56 | 32 | 66.9 | 0 | 82 | 249 | 214 | 269 | MES1911702.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 168 | 50.8 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;