contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA664479" and tax_clade = "Sar"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28186655 | 28186655 | PRJNA664479_S_NODE_16406_length_164_cov_0.886957_g16330_i0 | PRJNA664479 | 16406 | 164 | 0.886957 | 1.45460948 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 101 | 8.14e-26 | NR | XP_001025062.2 | 312017 | g16330 | i0 | 88.9 | 0.98780487804878 | 54 | 6 | 98.8 | 0 | 163 | 2 | 52 | 105 | XP_001025062.2 40S ribosomal protein S24 [Tetrahymena thermophila SB210] | diamond | 162 | 101 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 28344718 | 28344718 | PRJNA664479_S_NODE_14226_length_167_cov_1.296610_g14150_i0 | PRJNA664479 | 14226 | 167 | 1.29661 | 2.1653387 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 4.13e-24 | NR | XP_004030146.1 | 5932 | g14150 | i0 | 88.9 | 0.970059880239521 | 54 | 6 | 97 | 0 | 165 | 4 | 109 | 162 | XP_004030146.1 hypothetical protein IMG5_167040 [Ichthyophthirius multifiliis] | diamond | 162 | 97.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28502647 | 28502647 | PRJNA664479_S_NODE_14547_length_167_cov_0.864407_g14471_i0 | PRJNA664479 | 14547 | 167 | 0.864407 | 1.44355969 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 99.4 | 2.0199999999999998e-24 | NR | XP_001019693.2 | 312017 | g14471 | i0 | 92.2 | 0.916167664670659 | 51 | 4 | 91.6 | 0 | 153 | 1 | 1 | 51 | XP_001019693.2 60S ribosomal protein L6 [Tetrahymena thermophila SB210] | diamond | 153 | 99.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29733755 | 29733755 | PRJNA664479_S_NODE_4630_length_244_cov_2.666667_g4554_i0 | PRJNA664479 | 4630 | 244 | 2.666667 | 6.50666748 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 48.1 | 4.78e-4 | NR | CAI2387805.1 | 5936 | g4554 | i0 | 37 | 1.77049180327869 | 73 | 46 | 89.8 | 0 | 220 | 2 | 261 | 333 | CAI2387805.1 unnamed protein product [Moneuplotes crassus] | diamond | 432 | 48.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 31408764 | 31408764 | PRJNA664479_S_NODE_3216_length_283_cov_1.273504_g3140_i0 | PRJNA664479 | 3216 | 283 | 1.273504 | 3.60401632 | Phytophthora infestans T3 | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 68.9 | 1.29e-12 | NR | XP_002900902.1 | 403677 | g3140 | i0 | 51.1 | 0.975265017667845 | 92 | 45 | 97.5 | 0 | 4 | 279 | 15 | 106 | XP_002900902.1 uncharacterized protein PITG_12299 [Phytophthora infestans T30-4] | diamond | 276 | 68.9 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 31440221 | 31440221 | PRJNA664479_S_NODE_5936_length_223_cov_1.580460_g5860_i0 | PRJNA664479 | 5936 | 223 | 1.58046 | 3.5244258 | Discostella pseudostelligera | 259834 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 2.42e-6 | NR | KAL3762553.1 | 259834 | g5860 | i0 | 40.3 | 0.968609865470852 | 72 | 43 | 96.9 | 0 | 4 | 219 | 58 | 129 | KAL3762553.1 hypothetical protein ACHAWU_002425 [Discostella pseudostelligera] | diamond | 216 | 52.8 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Discostella | Discostella pseudostelligera | ||
| 31693332 | 31693332 | PRJNA664479_S_NODE_13537_length_170_cov_1.008264_g13461_i0 | PRJNA664479 | 13537 | 170 | 1.008264 | 1.7140488 | Babesia caballi | 5871 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 1.77e-7 | NR | XP_067715666.1 | 5871 | g13461 | i0 | 54.5 | 4.74705882352941 | 55 | 25 | 97.1 | 0 | 5 | 169 | 809 | 863 | XP_067715666.1 NAD-specific glutamate dehydrogenase [Babesia caballi] | diamond | 807 | 56.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia caballi |
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);;