contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJNA492406" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3003581 | 3003581 | PRJNA492406_P_NODE_943_length_1237_cov_3.127148_g759_i0 | PRJNA492406 | 943 | 1237 | 3.127148 | 38.68282076 | Cercozoa sp. DMV | 1342330 | SAR_Eukaryotes | SAR_Eukaryotes | 423 | 2.66e-142 | NR | BAN37425.1 | 1342330 | g759 | i0 | 73.1 | 2.59741309620048 | 271 | 73 | 65.7 | 0 | 1236 | 424 | 166 | 436 | BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] | diamond | 3213 | 423 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. DMV | ||||||
| 3650397 | 3650397 | PRJNA492406_P_NODE_25523_length_256_cov_1.262295_g25224_i0 | PRJNA492406 | 25523 | 256 | 1.262295 | 3.2314752 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 166 | 3.19e-51 | NR | ADK26622.1 | 323453 | g25224 | i0 | 94 | 0.984375 | 84 | 5 | 98.4 | 0 | 254 | 3 | 37 | 120 | ADK26622.1 rps22a [Heteromita sp. PRA-74] | diamond | 252 | 166 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 20854197 | 20854197 | PRJNA492406_P_NODE_25257_length_257_cov_1.630435_g24958_i0 | PRJNA492406 | 25257 | 257 | 1.630435 | 4.19021795 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 157 | 1.3499999999999997e-42 | NR | MES1909201.1 | 1215613 | g24958 | i0 | 81.9 | 1.92607003891051 | 83 | 14 | 96.9 | 1 | 4 | 252 | 633 | 714 | MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 495 | 157 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 24678797 | 24678797 | PRJNA492406_P_NODE_5780_length_499_cov_2.805164_g5481_i0 | PRJNA492406 | 5780 | 499 | 2.805164 | 13.99776836 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 1.4600000000000003e-79 | NR | MES1911029.1 | 1215613 | g5481 | i0 | 74.7 | 3.01803607214429 | 166 | 42 | 99.8 | 0 | 498 | 1 | 8 | 173 | MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 1506 | 248 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 27550236 | 27550236 | PRJNA492406_P_NODE_24964_length_259_cov_1.198925_g24665_i0 | PRJNA492406 | 24964 | 259 | 1.198925 | 3.10521575 | Gymnochlora stellata | 67809 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 2.36e-27 | NR | ACF24578.1 | 67809 | g24665 | i0 | 60.3 | 0.903474903474903 | 78 | 31 | 90.3 | 0 | 236 | 3 | 1 | 78 | ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata] | diamond | 234 | 105 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Gymnochlora | Gymnochlora stellata | ||||
| 28087011 | 28087011 | PRJNA492406_P_NODE_24305_length_262_cov_1.296296_g24006_i0 | PRJNA492406 | 24305 | 262 | 1.296296 | 3.39629552 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 8.02e-38 | NR | ADK26624.1 | 323453 | g24006 | i0 | 75.3 | 0.973282442748092 | 85 | 21 | 97.3 | 0 | 261 | 7 | 192 | 276 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 255 | 137 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 29066068 | 29066068 | PRJNA492406_P_NODE_23908_length_264_cov_1.277487_g23609_i0 | PRJNA492406 | 23908 | 264 | 1.277487 | 3.37256568 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 125 | 2e-31 | NR | MES1907833.1 | 1215613 | g23609 | i0 | 63.9 | 0.943181818181818 | 83 | 29 | 93.2 | 1 | 18 | 263 | 133 | 215 | MES1907833.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 249 | 125 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 30044671 | 30044671 | PRJNA492406_P_NODE_10031_length_388_cov_3.676190_g9732_i0 | PRJNA492406 | 10031 | 388 | 3.67619 | 14.2636172 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 98.6 | 3.34e-23 | NR | MES1908819.1 | 1215613 | g9732 | i0 | 43.3 | 0.981958762886598 | 127 | 69 | 96.6 | 2 | 5 | 379 | 35 | 160 | MES1908819.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 381 | 98.6 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 31308682 | 31308682 | PRJNA492406_P_NODE_25455_length_256_cov_1.628415_g25156_i0 | PRJNA492406 | 25455 | 256 | 1.628415 | 4.1687424 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 7.32e-5 | NR | MES1916909.1 | 1215613 | g25156 | i0 | 58.8 | 0.796875 | 34 | 14 | 39.8 | 0 | 233 | 132 | 40 | 73 | MES1916909.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 204 | 47.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);;