contig_metadata
24 rows where bioproject = "PRJNA904835" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7625549 | 7625549 | PRJNA904835_P_NODE_46486_length_269_cov_1.515306_g46230_i0 | PRJNA904835 | 46486 | 269 | 1.515306 | 4.07617314 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 120 | 1.91e-29 | NR | XP_004039325.1 | 5932 | g46230 | i0 | 62.5 | 7.6728624535316 | 88 | 33 | 98.1 | 0 | 1 | 264 | 326 | 413 | XP_004039325.1 papain family cysteine protease, putative [Ichthyophthirius multifiliis] | diamond | 2064 | 120 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 14001443 | 14001443 | PRJNA904835_P_NODE_52031_length_249_cov_1.312500_g51775_i0 | PRJNA904835 | 52031 | 249 | 1.3125 | 3.268125 | Saprolegnia diclina VS2 | 112098 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 4.59e-36 | NR | XP_008610586.1 | 1156394 | g51775 | i0 | 78 | 4.93975903614458 | 82 | 18 | 98.8 | 0 | 246 | 1 | 19 | 100 | XP_008610586.1 hypothetical protein SDRG_06578 [Saprolegnia diclina VS20] | diamond | 1230 | 139 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia diclina | ||
| 14910595 | 14910595 | PRJNA904835_P_NODE_23272_length_415_cov_0.801170_g23017_i0 | PRJNA904835 | 23272 | 415 | 0.80117 | 3.3248555 | Isotricha intestinalis | 47897 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 2.6000000000000003e-123 | NTclustered | gi|92790153|emb|AJ965262.1| | 47897 | g23017 | i0 | 86.779 | 198.265060240964 | 416 | 46 | 99 | 9 | 5 | 414 | 538 | 126 | Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) | blastn | 82280 | 455 | 1 | Eukaryota | Sar | Ciliophora | Litostomatea | Vestibuliferida | Isotrichidae | Isotricha | Isotricha intestinalis | ||
| 14910966 | 14910966 | PRJNA904835_P_NODE_34872_length_328_cov_0.905882_g34616_i0 | PRJNA904835 | 34872 | 328 | 0.905882 | 2.97129296 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 2.99e-37 | NR | XP_004034912.1 | 5932 | g34616 | i0 | 60.6 | 3.71341463414634 | 104 | 40 | 95.1 | 1 | 313 | 2 | 2 | 104 | XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis] | diamond | 1218 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 17461756 | 17461756 | PRJNA904835_P_NODE_51614_length_250_cov_0.870056_g51358_i0 | PRJNA904835 | 51614 | 250 | 0.870056 | 2.17514 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 2.59e-32 | NR | XP_001024675.2 | 312017 | g51358 | i0 | 68.7 | 1.992 | 83 | 26 | 99.6 | 0 | 2 | 250 | 230 | 312 | XP_001024675.2 aspartyl-tRNA synthetase protein [Tetrahymena thermophila SB210] | diamond | 498 | 127 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 19098972 | 19098972 | PRJNA904835_P_NODE_52755_length_249_cov_0.875000_g52499_i0 | PRJNA904835 | 52755 | 249 | 0.875 | 2.17875 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 4.84e-4 | NTclustered | gi|1843574570|ref|XM_034567210.1| | 5823 | g52499 | i0 | 100 | 0.598393574297189 | 31 | 0 | 12 | 0 | 142 | 172 | 1787 | 1757 | Plasmodium berghei ANKA zinc finger protein, putative (PBANKA_1357300), partial mRNA | blastn | 149 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium berghei | ||
| 25109069 | 25109069 | PRJNA904835_P_NODE_34940_length_327_cov_1.515748_g34684_i0 | PRJNA904835 | 34940 | 327 | 1.515748 | 4.95649596 | Oxytricha trifallax | 1172189 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.031 | NTclustered | gi|612176406|gb|KJ573500.1| | 1172189 | g34684 | i0 | 100 | 0.0856269113149847 | 28 | 0 | 9 | 0 | 230 | 257 | 775 | 802 | Oxytricha trifallax strain JRB310 TEBPalpha gene, complete sequence; micronuclear | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha trifallax | ||
| 26834478 | 26834478 | PRJNA904835_P_NODE_19161_length_464_cov_1.327366_g18906_i0 | PRJNA904835 | 19161 | 464 | 1.327366 | 6.15897824 | Reticulomyxa filosa | 46433 | SAR_Eukaryotes | SAR_Eukaryotes | 52.4 | 1.55e-4 | NR | ETN97328.1 | 46433 | g18906 | i0 | 28.4 | 0.65948275862069 | 102 | 61 | 64 | 2 | 423 | 127 | 362 | 454 | ETN97328.1 hypothetical protein RFI_40204 [Reticulomyxa filosa] | diamond | 306 | 52.4 | 1 | Eukaryota | Sar | Foraminifera | Reticulomyxidae | Reticulomyxa | Reticulomyxa filosa | ||||
| 26834501 | 26834501 | PRJNA904835_P_NODE_51641_length_250_cov_0.870056_g51385_i0 | PRJNA904835 | 51641 | 250 | 0.870056 | 2.17514 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 5.37e-7 | NR | KAJ1429269.1 | 483371 | g51385 | i0 | 74.3 | 0.42 | 35 | 9 | 42 | 0 | 199 | 95 | 951 | 985 | KAJ1429269.1 kinase-like domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 105 | 56.6 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 27506014 | 27506014 | PRJNA904835_P_NODE_41663_length_291_cov_1.412844_g41407_i0 | PRJNA904835 | 41663 | 291 | 1.412844 | 4.11137604 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 8.72e-4 | NR | CEO97978.1 | 37360 | g41407 | i0 | 39.1 | 0.958762886597938 | 46 | 28 | 47.4 | 0 | 217 | 80 | 12 | 57 | CEO97978.1 hypothetical protein PBRA_006092 [Plasmodiophora brassicae] | diamond | 279 | 45.1 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 27908464 | 27908464 | PRJNA904835_P_NODE_58485_length_242_cov_0.911243_g58229_i0 | PRJNA904835 | 58485 | 242 | 0.911243 | 2.20520806 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 7.62e-39 | NR | KAJ1423739.1 | 483371 | g58229 | i0 | 84.4 | 0.954545454545455 | 77 | 12 | 95.5 | 0 | 11 | 241 | 18 | 94 | KAJ1423739.1 hypothetical protein B484DRAFT_398539 [Ochromonadaceae sp. CCMP2298] | diamond | 231 | 138 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28635209 | 28635209 | PRJNA904835_P_NODE_8587_length_736_cov_1.613876_g8357_i0 | PRJNA904835 | 8587 | 736 | 1.613876 | 11.87812736 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 76.3 | 2.9e-13 | NR | CDW86772.1 | 5949 | g8357 | i0 | 42.6 | 0.525815217391304 | 129 | 65 | 50.5 | 5 | 654 | 283 | 15 | 139 | CDW86772.1 UNKNOWN [Stylonychia lemnae] | diamond | 387 | 76.3 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 28950895 | 28950895 | PRJNA904835_P_NODE_56548_length_244_cov_0.900585_g56292_i0 | PRJNA904835 | 56548 | 244 | 0.900585 | 2.1974274 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.54e-25 | NR | XP_004040108.1 | 5932 | g56292 | i0 | 62 | 1.94262295081967 | 79 | 30 | 97.1 | 0 | 239 | 3 | 108 | 186 | XP_004040108.1 hypothetical protein IMG5_001810 [Ichthyophthirius multifiliis] | diamond | 474 | 108 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 28982464 | 28982464 | PRJNA904835_P_NODE_51548_length_250_cov_0.870056_g51292_i0 | PRJNA904835 | 51548 | 250 | 0.870056 | 2.17514 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 105 | 4.44e-24 | NR | CEO97171.1 | 37360 | g51292 | i0 | 62.7 | 0.996 | 83 | 30 | 99.6 | 1 | 2 | 250 | 425 | 506 | CEO97171.1 hypothetical protein PBRA_005775 [Plasmodiophora brassicae] | diamond | 249 | 105 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 29108678 | 29108678 | PRJNA904835_P_NODE_50628_length_251_cov_0.865169_g50372_i0 | PRJNA904835 | 50628 | 251 | 0.865169 | 2.17157419 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 100 | 1.3899999999999998e-23 | NR | KAJ1400726.1 | 483371 | g50372 | i0 | 67.8 | 0.705179282868526 | 59 | 18 | 69.3 | 1 | 249 | 76 | 136 | 194 | KAJ1400726.1 hypothetical protein B484DRAFT_405947 [Ochromonadaceae sp. CCMP2298] | diamond | 177 | 100 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29771429 | 29771429 | PRJNA904835_P_NODE_30271_length_357_cov_1.084507_g30015_i0 | PRJNA904835 | 30271 | 357 | 1.084507 | 3.87168999 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 1.82e-17 | NR | KAJ1411514.1 | 483371 | g30015 | i0 | 56.1 | 0.689075630252101 | 82 | 33 | 68.9 | 1 | 246 | 1 | 1 | 79 | KAJ1411514.1 hypothetical protein B484DRAFT_455600 [Ochromonadaceae sp. CCMP2298] | diamond | 246 | 81.6 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 29929707 | 29929707 | PRJNA904835_P_NODE_57691_length_243_cov_0.905882_g57435_i0 | PRJNA904835 | 57691 | 243 | 0.905882 | 2.20129326 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 4.32e-9 | NR | KAJ1422220.1 | 483371 | g57435 | i0 | 52.3 | 0.802469135802469 | 65 | 28 | 80.2 | 2 | 223 | 29 | 439 | 500 | KAJ1422220.1 hypothetical protein B484DRAFT_452452 [Ochromonadaceae sp. CCMP2298] | diamond | 195 | 62.4 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30245676 | 30245676 | PRJNA904835_P_NODE_53852_length_247_cov_0.885057_g53596_i0 | PRJNA904835 | 53852 | 247 | 0.885057 | 2.18609079 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 2.17e-27 | NR | KAJ1422634.1 | 483371 | g53596 | i0 | 63.9 | 1.0080971659919 | 83 | 29 | 99.6 | 1 | 1 | 246 | 30 | 112 | KAJ1422634.1 HSP20-like chaperone [Ochromonadaceae sp. CCMP2298] | diamond | 249 | 108 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30529723 | 30529723 | PRJNA904835_P_NODE_44293_length_279_cov_1.495146_g44037_i0 | PRJNA904835 | 44293 | 279 | 1.495146 | 4.17145734 | Aphanomyces stellatus | 120398 | SAR_Eukaryotes | SAR_Eukaryotes | 58.9 | 1.04e-7 | NR | KAF0717784.1 | 120398 | g44037 | i0 | 45.8 | 1.62365591397849 | 72 | 36 | 75.3 | 2 | 65 | 274 | 21 | 91 | KAF0717784.1 hypothetical protein As57867_002096 [Aphanomyces stellatus] | diamond | 453 | 58.9 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 30537388 | 30537388 | PRJNA904835_P_NODE_44513_length_278_cov_1.497561_g44257_i0 | PRJNA904835 | 44513 | 278 | 1.497561 | 4.16321958 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 130 | 7.21e-35 | NR | CAD8077690.1 | 5886 | g44257 | i0 | 67.8 | 3.82014388489209 | 90 | 29 | 97.1 | 0 | 273 | 4 | 147 | 236 | CAD8077690.1 unnamed protein product [Paramecium primaurelia] | diamond | 1062 | 130 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium primaurelia | ||
| 31920825 | 31920825 | PRJNA904835_P_NODE_54757_length_246_cov_0.890173_g54501_i0 | PRJNA904835 | 54757 | 246 | 0.890173 | 2.18982558 | Chaetoceros tenuissimus | 426638 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00628 | NR | GFH45950.1 | 426638 | g54501 | i0 | 46.9 | 1.17073170731707 | 49 | 26 | 59.8 | 0 | 243 | 97 | 1895 | 1943 | GFH45950.1 chromodomain-helicase-DNA-binding protein 7 [Chaetoceros tenuissimus] | diamond | 288 | 45.1 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Chaetocerotales | Chaetocerotaceae | Chaetoceros | Chaetoceros tenuissimus | ||
| 32047443 | 32047443 | PRJNA904835_P_NODE_51098_length_251_cov_0.865169_g50842_i0 | PRJNA904835 | 51098 | 251 | 0.865169 | 2.17157419 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.6300000000000003e-22 | NR | KAJ1437162.1 | 483371 | g50842 | i0 | 66.3 | 0.956175298804781 | 80 | 24 | 95.6 | 1 | 243 | 4 | 19 | 95 | KAJ1437162.1 delta12-fatty acid desaturase [Ochromonadaceae sp. CCMP2298] | diamond | 240 | 99 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32213253 | 32213253 | PRJNA904835_P_NODE_31858_length_346_cov_1.128205_g31602_i0 | PRJNA904835 | 31858 | 346 | 1.128205 | 3.9035893 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 9.49e-43 | NR | XP_024573476.1 | 4781 | g31602 | i0 | 67.6 | 15.7890173410405 | 108 | 35 | 93.6 | 0 | 1 | 324 | 541 | 648 | XP_024573476.1 dead deah box helicase [Plasmopara halstedii] | diamond | 5463 | 159 | 0.993710691823899 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Plasmopara | Plasmopara halstedii | ||
| 32434928 | 32434928 | PRJNA904835_P_NODE_13259_length_576_cov_1.091451_g13008_i0 | PRJNA904835 | 13259 | 576 | 1.091451 | 6.28675776 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 3.67e-22 | NR | KAL3760185.1 | 259834 | g13008 | i0 | 34.4 | 17.0625 | 180 | 111 | 93.8 | 2 | 570 | 31 | 22 | 194 | KAL3760185.1 hypothetical protein ACHAWU_001695 [Discostella pseudostelligera] | diamond | 9828 | 102 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Discostella | Discostella pseudostelligera |
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);;