contig_metadata
12 rows where 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 | ||||||
| 16044923 | 16044923 | PRJNA760904_P_NODE_4033_length_416_cov_1.346939_g3976_i0 | PRJNA760904 | 4033 | 416 | 1.346939 | 5.60326624 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 3.4499999999999987e-107 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g3976 | i0 | 91.438 | 74.0408653846154 | 292 | 25 | 70 | 0 | 125 | 416 | 768 | 477 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 30801 | 401 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 17320562 | 17320562 | PRJNA760904_P_NODE_2134_length_546_cov_2.192389_g2078_i0 | PRJNA760904 | 2134 | 546 | 2.192389 | 11.97044394 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 505 | 3.429999999999999e-138 | NTclustered | gi|302563030|dbj|AB546338.1| | 717846 | g2078 | i0 | 82.94 | 42.3717948717949 | 551 | 84 | 100 | 7 | 1 | 546 | 382 | 927 | Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds | blastn | 23135 | 505 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 18593956 | 18593956 | PRJNA760904_P_NODE_6495_length_342_cov_1.702602_g6438_i0 | PRJNA760904 | 6495 | 342 | 1.702602 | 5.82289884 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 7.969999999999997e-88 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6438 | i0 | 84.928 | 58.6023391812866 | 345 | 38 | 100 | 10 | 1 | 342 | 3662 | 3995 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20042 | 337 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 23695237 | 23695237 | PRJNA760904_P_NODE_9959_length_288_cov_0.995349_g9902_i0 | PRJNA760904 | 9959 | 288 | 0.995349 | 2.86660512 | Thaumatomastix sp. NIES-2378 | 717846 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 3.899999999999999e-95 | NTclustered | gi|302563030|dbj|AB546338.1| | 717846 | g9902 | i0 | 91.571 | 24.2013888888889 | 261 | 22 | 91 | 0 | 2 | 262 | 85 | 345 | Thaumatomastix sp. NIES-2378 EFL mRNA for elongation factor like, partial cds | blastn | 6970 | 361 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. NIES-2378 | ||
| 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);;