contig_metadata
12 rows where 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4457077 | 4457077 | PRJNA664479_S_NODE_17444_length_163_cov_0.894737_g17368_i0 | PRJNA664479 | 17444 | 163 | 0.894737 | 1.45842131 | Eimeria mitis | 44415 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 2.92e-4 | NTclustered | gi|916502996|ref|XM_013496795.1| | 44415 | g17368 | i0 | 97.059 | 1.13496932515337 | 34 | 1 | 21 | 0 | 1 | 34 | 1798 | 1831 | Eimeria mitis phosphoserine phosphatase, putative (EMH_0004480), partial mRNA | blastn | 185 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis | ||
| 10833276 | 10833276 | PRJNA664479_S_NODE_16229_length_164_cov_1.773913_g16153_i0 | PRJNA664479 | 16229 | 164 | 1.773913 | 2.90921732 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 3.73e-18 | NTclustered | gi|829196136|ref|XM_001025866.3| | 312017 | g16153 | i0 | 91.892 | 0.451219512195122 | 74 | 6 | 45 | 0 | 91 | 164 | 510 | 437 | Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA | blastn | 74 | 104 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12108493 | 12108493 | PRJNA664479_S_NODE_7970_length_202_cov_1.235294_g7894_i0 | PRJNA664479 | 7970 | 202 | 1.235294 | 2.49529388 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 2.09e-61 | NTclustered | gi|829194717|ref|XM_001025217.3| | 312017 | g7894 | i0 | 88.78 | 1.01485148514851 | 205 | 20 | 100 | 1 | 1 | 202 | 349 | 553 | Tetrahymena thermophila SB210 ubiquitin-40S ribosomal protein S27a partial mRNA | blastn | 205 | 248 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12641471 | 12641471 | PRJNA664479_S_NODE_15050_length_166_cov_0.871795_g14974_i0 | PRJNA664479 | 15050 | 166 | 0.871795 | 1.4471797 | Bacillariophyta | 2836 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 2.2e-40 | NTclustered | gi|2301269116|ref|NC_066077.1| | 197753 | g14974 | i0 | 87.179 | 33.2289156626506 | 156 | 20 | 94 | 0 | 3 | 158 | 151744 | 151589 | Pleurosigma intermedium isolate Jiaozhou Bay in China chloroplast, complete genome | blastn | 5516 | 178 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Pleurosigmataceae | Pleurosigma | Pleurosigma intermedium | ||
| 19756080 | 19756080 | PRJNA664479_S_NODE_4696_length_243_cov_1.634021_g4620_i0 | PRJNA664479 | 4696 | 243 | 1.634021 | 3.97067103 | Plasmodium inui | 52288 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.022 | NTclustered | gi|672184987|ref|XM_008815718.1| | 1237626 | g4620 | i0 | 96.875 | 0.131687242798354 | 32 | 0 | 13 | 1 | 125 | 155 | 8920 | 8951 | Plasmodium inui San Antonio 1 hypothetical protein partial mRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium inui | ||
| 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);;