contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA473799" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22122217 | 22122217 | PRJNA473799_P_NODE_36858_length_250_cov_0.870056_g36584_i0 | PRJNA473799 | 36858 | 250 | 0.870056 | 2.17514 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 1.08e-39 | NR | CAE7382485.1 | 2951 | g36584 | i0 | 81.5 | 2.916 | 81 | 15 | 97.2 | 0 | 249 | 7 | 253 | 333 | CAE7382485.1 rpl3, partial [Symbiodinium microadriaticum] | diamond | 729 | 143 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 26633027 | 26633027 | PRJNA473799_P_NODE_44101_length_246_cov_0.890173_g43827_i0 | PRJNA473799 | 44101 | 246 | 0.890173 | 2.18982558 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.77e-4 | NR | XP_001030759.2 | 312017 | g43827 | i0 | 42.3 | 0.634146341463415 | 52 | 30 | 63.4 | 0 | 18 | 173 | 172 | 223 | XP_001030759.2 hypothetical protein TTHERM_01015990 [Tetrahymena thermophila SB210] | diamond | 156 | 49.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 26727592 | 26727592 | PRJNA473799_P_NODE_31101_length_257_cov_1.157609_g30827_i0 | PRJNA473799 | 31101 | 257 | 1.157609 | 2.97505513 | Nitzschia inconspicua | 303405 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 8.239999999999998e-35 | NR | KAG7362008.1 | 303405 | g30827 | i0 | 71.1 | 0.968871595330739 | 83 | 24 | 96.9 | 0 | 254 | 6 | 163 | 245 | KAG7362008.1 retrotransposon hot spot protein [Nitzschia inconspicua] | diamond | 249 | 132 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia inconspicua | ||
| 26886546 | 26886546 | PRJNA473799_P_NODE_20581_length_277_cov_1.460784_g20307_i0 | PRJNA473799 | 20581 | 277 | 1.460784 | 4.04637168 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 68.6 | 4.71e-11 | NR | SBT55483.1 | 864142 | g20307 | i0 | 46.4 | 0.747292418772563 | 69 | 37 | 74.7 | 0 | 11 | 217 | 40 | 108 | SBT55483.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 207 | 68.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 26918017 | 26918017 | PRJNA473799_P_NODE_27662_length_263_cov_1.573684_g27388_i0 | PRJNA473799 | 27662 | 263 | 1.573684 | 4.13878892 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 77.4 | 2.36e-14 | NR | SBT55340.1 | 864142 | g27388 | i0 | 49.3 | 2.42965779467681 | 75 | 38 | 85.6 | 0 | 225 | 1 | 305 | 379 | SBT55340.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] | diamond | 639 | 77.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 27329195 | 27329195 | PRJNA473799_P_NODE_37883_length_249_cov_1.744318_g37609_i0 | PRJNA473799 | 37883 | 249 | 1.744318 | 4.34335182 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 3.23e-36 | NR | KAJ1411522.1 | 483371 | g37609 | i0 | 81.9 | 1 | 83 | 15 | 100 | 0 | 249 | 1 | 35 | 117 | KAJ1411522.1 hypothetical protein B484DRAFT_182663, partial [Ochromonadaceae sp. CCMP2298] | diamond | 249 | 137 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 27487015 | 27487015 | PRJNA473799_P_NODE_51663_length_242_cov_0.911243_g51389_i0 | PRJNA473799 | 51663 | 242 | 0.911243 | 2.20520806 | Plasmodium vivax | 5855 | SAR_Eukaryotes | SAR_Eukaryotes | 46.6 | 0.00108 | NR | CAA63219.1 | 5855 | g51389 | i0 | 56.8 | 0.855371900826446 | 44 | 18 | 54.5 | 1 | 144 | 13 | 141 | 183 | CAA63219.1 pva1 [Plasmodium vivax] | diamond | 207 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium vivax | ||
| 27834203 | 27834203 | PRJNA473799_P_NODE_28704_length_261_cov_1.606383_g28430_i0 | PRJNA473799 | 28704 | 261 | 1.606383 | 4.19265963 | Peronospora destructor | 86335 | SAR_Eukaryotes | SAR_Eukaryotes | 145 | 1.6499999999999998e-42 | NR | CAI5713440.1 | 86335 | g28430 | i0 | 81.6 | 1 | 87 | 16 | 100 | 0 | 261 | 1 | 47 | 133 | CAI5713440.1 unnamed protein product [Peronospora destructor] | diamond | 261 | 145 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora destructor | ||
| 28465937 | 28465937 | PRJNA473799_P_NODE_50126_length_243_cov_0.905882_g49852_i0 | PRJNA473799 | 50126 | 243 | 0.905882 | 2.20129326 | Besnoitia besnoiti | 94643 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 1.1e-4 | NR | XP_029214941.1 | 94643 | g49852 | i0 | 49 | 1.25925925925926 | 51 | 26 | 63 | 0 | 153 | 1 | 3 | 53 | XP_029214941.1 uncharacterized protein BESB_058130 [Besnoitia besnoiti] | diamond | 306 | 48.9 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 28465938 | 28465938 | PRJNA473799_P_NODE_54286_length_241_cov_0.916667_g54012_i0 | PRJNA473799 | 54286 | 241 | 0.916667 | 2.20916747 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 9.91e-25 | NR | KAJ1407601.1 | 483371 | g54012 | i0 | 59.5 | 0.983402489626556 | 79 | 32 | 98.3 | 0 | 239 | 3 | 76 | 154 | KAJ1407601.1 hypothetical protein B484DRAFT_337174 [Ochromonadaceae sp. CCMP2298] | diamond | 237 | 102 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28812763 | 28812763 | PRJNA473799_P_NODE_36108_length_250_cov_1.655367_g35834_i0 | PRJNA473799 | 36108 | 250 | 1.655367 | 4.1384175 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.16e-23 | NR | KAJ1434220.1 | 483371 | g35834 | i0 | 68 | 0.9 | 75 | 20 | 86.4 | 2 | 3 | 218 | 141 | 214 | KAJ1434220.1 UNC-like C-terminal-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 225 | 100 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29129077 | 29129077 | PRJNA473799_P_NODE_7229_length_410_cov_1.910979_g6956_i0 | PRJNA473799 | 7229 | 410 | 1.910979 | 7.8350139 | Plasmodium ovale wallikeri | 864142 | SAR_Eukaryotes | SAR_Eukaryotes | 60.5 | 1.52e-7 | NR | SBT57149.1 | 864142 | g6956 | i0 | 65.9 | 0.3 | 41 | 14 | 30 | 0 | 129 | 7 | 972 | 1012 | SBT57149.1 STP1 protein [Plasmodium ovale wallikeri] | diamond | 123 | 60.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium ovale | ||
| 30424145 | 30424145 | PRJNA473799_P_NODE_22733_length_273_cov_1.050000_g22459_i0 | PRJNA473799 | 22733 | 273 | 1.05 | 2.8665 | Peronospora farinosa | 134698 | SAR_Eukaryotes | SAR_Eukaryotes | 140 | 2.29e-40 | NR | CAI5704134.1 | 134698 | g22459 | i0 | 75.8 | 1 | 91 | 22 | 100 | 0 | 273 | 1 | 20 | 110 | CAI5704134.1 unnamed protein product [Peronospora farinosa] | diamond | 273 | 140 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Peronospora | Peronospora farinosa | ||
| 30992547 | 30992547 | PRJNA473799_P_NODE_35754_length_251_cov_0.865169_g35480_i0 | PRJNA473799 | 35754 | 251 | 0.865169 | 2.17157419 | Babesia bovis T2Bo | 484906 | SAR_Eukaryotes | SAR_Eukaryotes | 97.8 | 1.75e-21 | NR | XP_001609528.1 | 484906 | g35480 | i0 | 64.9 | 0.884462151394422 | 74 | 22 | 87.3 | 2 | 31 | 249 | 207 | 277 | XP_001609528.1 DNA gyrase/topoisomerase IV subunit A family protein [Babesia bovis T2Bo] | diamond | 222 | 97.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bovis | ||
| 31371976 | 31371976 | PRJNA473799_P_NODE_45596_length_245_cov_1.220930_g45322_i0 | PRJNA473799 | 45596 | 245 | 1.22093 | 2.9912785 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 3.0300000000000003e-21 | NR | KAJ1426434.1 | 483371 | g45322 | i0 | 72.2 | 0.881632653061225 | 72 | 17 | 88.2 | 1 | 17 | 232 | 213 | 281 | KAJ1426434.1 hypothetical protein B484DRAFT_450707 [Ochromonadaceae sp. CCMP2298] | diamond | 216 | 97.1 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31593391 | 31593391 | PRJNA473799_P_NODE_32516_length_254_cov_2.044199_g32242_i0 | PRJNA473799 | 32516 | 254 | 2.044199 | 5.19226546 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 65.9 | 3.15e-10 | NR | KRW99809.1 | 266149 | g32242 | i0 | 72.1 | 0.507874015748031 | 43 | 12 | 50.8 | 0 | 119 | 247 | 897 | 939 | KRW99809.1 Protein kinase-like domain [Pseudocohnilembus persalinus] | diamond | 129 | 65.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 32368885 | 32368885 | PRJNA473799_P_NODE_13479_length_296_cov_3.838565_g13205_i0 | PRJNA473799 | 13479 | 296 | 3.838565 | 11.3621524 | root | 1 | Root_unresolved | Root_unresolved | 72 | 2.79e-13 | NR | XP_029214941.1 | 94643 | g13205 | i0 | 75.5 | 6.98310810810811 | 53 | 13 | 53.7 | 0 | 52 | 210 | 71 | 123 | XP_029214941.1 uncharacterized protein BESB_058130 [Besnoitia besnoiti] | diamond | 2067 | 72 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Besnoitia | Besnoitia besnoiti | ||
| 32574210 | 32574210 | PRJNA473799_P_NODE_28899_length_261_cov_1.117021_g28625_i0 | PRJNA473799 | 28899 | 261 | 1.117021 | 2.91542481 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 4.5e-7 | NR | KAJ1394621.1 | 483371 | g28625 | i0 | 53.3 | 0.689655172413793 | 60 | 23 | 69 | 2 | 2 | 181 | 75 | 129 | KAJ1394621.1 40S ribosomal protein S10 [Ochromonadaceae sp. CCMP2298] | diamond | 180 | 54.7 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32699763 | 32699763 | PRJNA473799_P_NODE_49020_length_243_cov_3.011765_g48746_i0 | PRJNA473799 | 49020 | 243 | 3.011765 | 7.31858895 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 1.9599999999999994e-23 | NR | KAJ1420827.1 | 483371 | g48746 | i0 | 73.8 | 0.987654320987654 | 80 | 21 | 98.8 | 0 | 2 | 241 | 373 | 452 | KAJ1420827.1 sulfate transporter family-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 240 | 103 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 |
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);;