contig_metadata
25 rows where bioproject = "PRJNA1044115" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1008785 | 1008785 | PRJNA1044115_P_NODE_23101_length_302_cov_2.912664_g22917_i0 | PRJNA1044115 | 23101 | 302 | 2.912664 | 8.79624528 | Peronosporomycetes | 3418804 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.82e-128 | NTclustered | gi|2651589115|gb|PP108238.1| | 4785 | g22917 | i0 | 95.033 | 103.029801324503 | 302 | 12 | 100 | 3 | 1 | 302 | 23124 | 23422 | Phytophthora cinnamomi strain CT09CHAP1 mitochondrion, complete genome | blastn | 31115 | 472 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 2284023 | 2284023 | PRJNA1044115_P_NODE_16742_length_357_cov_4.904930_g16558_i0 | PRJNA1044115 | 16742 | 357 | 4.90493 | 17.5106001 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 287 | 8.51e-73 | NTclustered | gi|161736|gb|L01416.1|TETBTUBUB | 5911 | g16558 | i0 | 83.495 | 61.7422969187675 | 309 | 50 | 86 | 1 | 6 | 313 | 438 | 130 | Tetrahymena thermophila beta-tubulin (BTU2) gene, complete cds | blastn | 22042 | 287 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 6549245 | 6549245 | PRJNA1044115_P_NODE_13346_length_405_cov_5.253012_g13162_i0 | PRJNA1044115 | 13346 | 405 | 5.253012 | 21.2746986 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 732 | 0 | NTclustered | gi|10782|emb|X54004.1| | 5908 | g13162 | i0 | 99.259 | 90.4074074074074 | 405 | 3 | 100 | 0 | 1 | 405 | 1918 | 1514 | Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA | blastn | 36615 | 732 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 7824130 | 7824130 | PRJNA1044115_P_NODE_31007_length_264_cov_1.633508_g30823_i0 | PRJNA1044115 | 31007 | 264 | 1.633508 | 4.31246112 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 3.4999999999999996e-100 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g30823 | i0 | 92.424 | 99.3030303030303 | 264 | 20 | 100 | 0 | 1 | 264 | 741 | 1004 | Pyrocystis lunula actin mRNA, complete cds | blastn | 26216 | 377 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 8662022 | 8662022 | PRJNA1044115_P_NODE_8547_length_524_cov_104.949002_g8365_i0 | PRJNA1044115 | 8547 | 524 | 104.949002 | 549.93277048 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 963 | 0 | NTclustered | gi|1516250946|gb|MK177633.1| | 343864 | g8365 | i0 | 99.809 | 101.030534351145 | 524 | 1 | 100 | 0 | 1 | 524 | 603 | 1126 | Uncultured Euplotes sp. clone DDI217.fa small subunit ribosomal RNA gene, partial sequence | blastn | 52940 | 968 | 0.994834710743802 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | uncultured Euplotes sp. | ||
| 9099265 | 9099265 | PRJNA1044115_P_NODE_848_length_1590_cov_6.870138_g800_i0 | PRJNA1044115 | 848 | 1590 | 6.870138 | 109.2351942 | Spirostomum yagiui | 1471042 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 7.39e-20 | NTclustered | gi|2692944869|ref|NC_086648.1| | 1471042 | g800 | i0 | 85.981 | 8.16415094339623 | 107 | 14 | 7 | 1 | 950 | 1055 | 3975 | 3869 | Spirostomum yagiui isolate XKC mitochondrion, complete genome | blastn | 12981 | 113 | 1 | Eukaryota | Sar | Ciliophora | Heterotrichea | Heterotrichida | Spirostomidae | Spirostomum | Spirostomum yagiui | ||
| 13762199 | 13762199 | PRJNA1044115_P_NODE_19471_length_330_cov_2.953307_g19287_i0 | PRJNA1044115 | 19471 | 330 | 2.953307 | 9.7459131 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|84997470|ref|XM_948364.1| | 5874 | g19287 | i0 | 100 | 0.190909090909091 | 30 | 0 | 9 | 0 | 282 | 311 | 381 | 352 | Theileria annulata uncharacterized protein (TA11355), partial mRNA | blastn | 63 | 56.5 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Theileriidae | Theileria | Theileria annulata | ||
| 15036544 | 15036544 | PRJNA1044115_P_NODE_43832_length_219_cov_17.000000_g43648_i0 | PRJNA1044115 | 43832 | 219 | 17 | 37.23 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 1.29e-108 | NTclustered | gi|1333898193|gb|MG827339.1| | 178273 | g43648 | i0 | 100 | 100.009132420091 | 219 | 0 | 100 | 0 | 1 | 219 | 161 | 379 | Euplotes sp. strain SLS1 small subunit ribosomal RNA gene, partial sequence | blastn | 21902 | 405 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes sp. | ||
| 18023396 | 18023396 | PRJNA1044115_P_NODE_37075_length_248_cov_76.788571_g36891_i0 | PRJNA1044115 | 37075 | 248 | 76.788571 | 190.43565608 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 5.38e-108 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g36891 | i0 | 95.984 | 101.213709677419 | 249 | 9 | 100 | 1 | 1 | 248 | 3424 | 3176 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 25101 | 403 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 20572687 | 20572687 | PRJNA1044115_P_NODE_3557_length_851_cov_762.863753_g3409_i0 | PRJNA1044115 | 3557 | 851 | 762.863753 | 6491.97053803 | Euplotes encysticus | 440145 | SAR_Eukaryotes | SAR_Eukaryotes | 1273 | 0 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g3409 | i0 | 100 | 74.4112808460634 | 689 | 0 | 81 | 0 | 1 | 689 | 689 | 1 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 63324 | 1273 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 20572849 | 20572849 | PRJNA1044115_P_NODE_997_length_1503_cov_36.783217_g939_i0 | PRJNA1044115 | 997 | 1503 | 36.783217 | 552.85175151 | Euplotes vanleeuwenhoeki | 2794224 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 7.89e-114 | NTclustered | gi|2055401904|ref|NC_056101.1| | 2794224 | g939 | i0 | 77.068 | 13.3313373253493 | 798 | 146 | 77 | 30 | 527 | 1308 | 17756 | 18532 | Euplotes vanleeuwenhoeki strain KKR18 mitochondrion, complete genome | blastn | 20037 | 425 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vanleeuwenhoeki | ||
| 24397216 | 24397216 | PRJNA1044115_P_NODE_10660_length_461_cov_286.564433_g10476_i0 | PRJNA1044115 | 10660 | 461 | 286.564433 | 1321.06203613 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 490 | 7.999999999999998e-134 | NTclustered | gi|6980030|gb|AF223571.1|AF223571 | 5940 | g10476 | i0 | 91.008 | 39.590021691974 | 367 | 27 | 79 | 6 | 75 | 437 | 3581 | 3945 | Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 18251 | 490 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 24397226 | 24397226 | PRJNA1044115_P_NODE_11380_length_444_cov_7.730458_g11196_i0 | PRJNA1044115 | 11380 | 444 | 7.730458 | 34.32323352 | Tetrahymena sp. KGE15 | 1200497 | SAR_Eukaryotes | SAR_Eukaryotes | 808 | 0 | NTclustered | gi|523704203|emb|HE861887.1| | 1200497 | g11196 | i0 | 99.549 | 85.213963963964 | 443 | 2 | 99 | 0 | 2 | 444 | 485 | 43 | Tetrahymena sp. KGE15 partial 28S rRNA gene, strain KGE15 | blastn | 37835 | 808 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena sp. KGE15 | ||
| 24397519 | 24397519 | PRJNA1044115_P_NODE_30840_length_265_cov_1.218750_g30656_i0 | PRJNA1044115 | 30840 | 265 | 1.21875 | 3.2296875 | Tetrahymena pigmentosa | 5907 | SAR_Eukaryotes | SAR_Eukaryotes | 387 | 5.85e-103 | NTclustered | gi|114329902|ref|NC_008339.1| | 5907 | g30656 | i0 | 93.487 | 32.222641509434 | 261 | 15 | 98 | 1 | 1 | 261 | 1812 | 1554 | Tetrahymena pigmentosa mitochondrion, complete genome | blastn | 8539 | 387 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pigmentosa | ||
| 25235038 | 25235038 | PRJNA1044115_P_NODE_18900_length_335_cov_488.232824_g18716_i0 | PRJNA1044115 | 18900 | 335 | 488.232824 | 1635.5799604 | Euplotes | 5935 | SAR_Eukaryotes | SAR_Eukaryotes | 614 | 3.209999999999999e-171 | NTclustered | gi|1233819925|gb|KX516617.1| | 440145 | g18716 | i0 | 99.701 | 99.7611940298507 | 335 | 1 | 100 | 0 | 1 | 335 | 672 | 1006 | Euplotes encysticus isolate B555 large subunit ribosomal RNA gene, partial sequence | blastn | 33420 | 614 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes encysticus | ||
| 27311886 | 27311886 | PRJNA1044115_P_NODE_37903_length_247_cov_1.793103_g37719_i0 | PRJNA1044115 | 37903 | 247 | 1.793103 | 4.42896441 | root | 1 | Root_unresolved | Root_unresolved | 130 | 7.64e-36 | NR | CDW71769.1 | 5949 | g37719 | i0 | 93 | 2.58704453441296 | 71 | 5 | 86.2 | 0 | 33 | 245 | 1 | 71 | CDW71769.1 transposase [Stylonychia lemnae] | diamond | 639 | 130 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae | ||
| 27351551 | 27351551 | PRJNA1044115_P_NODE_36283_length_250_cov_0.881356_g36099_i0 | PRJNA1044115 | 36283 | 250 | 0.881356 | 2.20339 | Bacillariaceae sp. | 3061772 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 1.99e-12 | NR | KAL3916292.1 | 3061772 | g36099 | i0 | 46.5 | 1.032 | 86 | 41 | 97.2 | 1 | 2 | 244 | 103 | 188 | KAL3916292.1 MAG: hypothetical protein SGILL_005242, partial [Bacillariaceae sp.] | diamond | 258 | 72 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Bacillariaceae sp. | |||
| 28108942 | 28108942 | PRJNA1044115_P_NODE_13825_length_397_cov_4.104938_g13641_i0 | PRJNA1044115 | 13825 | 397 | 4.104938 | 16.29660386 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 92.8 | 1.95e-20 | NR | QTT61052.1 | 5940 | g13641 | i0 | 46.3 | 0.717884130982368 | 95 | 46 | 71.8 | 1 | 1 | 285 | 55 | 144 | QTT61052.1 hypothetical protein [Euplotes aediculatus] | diamond | 285 | 92.8 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 28235160 | 28235160 | PRJNA1044115_P_NODE_35326_length_251_cov_0.876404_g35142_i0 | PRJNA1044115 | 35326 | 251 | 0.876404 | 2.19977404 | Euplotes vanleeuwenhoeki | 2794224 | SAR_Eukaryotes | SAR_Eukaryotes | 132 | 1.68e-33 | NR | YP_010117025.1 | 2794224 | g35142 | i0 | 82.7 | 4.48207171314741 | 75 | 13 | 89.6 | 0 | 25 | 249 | 99 | 173 | YP_010117025.1 Cytochrome c oxidase subunit 2 precursor [Euplotes vanleeuwenhoeki] | diamond | 1125 | 132 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vanleeuwenhoeki | ||
| 28416957 | 28416957 | PRJNA1044115_P_NODE_19606_length_329_cov_2.687500_g19422_i0 | PRJNA1044115 | 19606 | 329 | 2.6875 | 8.841875 | Bigyra | 2683628 | SAR_Eukaryotes | SAR_Eukaryotes | 95.1 | 3.6e-23 | NR | AAG23688.1 | 42467 | g19422 | i0 | 68 | 2.73556231003039 | 75 | 24 | 68.4 | 0 | 67 | 291 | 1 | 75 | AAG23688.1 ATP synthase F0 subunit 9 [Thraustochytrium aureum] | diamond | 900 | 95.9 | 0.991657977059437 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Thraustochytrium | Thraustochytrium aureum | |||
| 28677563 | 28677563 | PRJNA1044115_P_NODE_26047_length_286_cov_1.314554_g25863_i0 | PRJNA1044115 | 26047 | 286 | 1.314554 | 3.75962444 | Moneuplotes minuta | 74792 | SAR_Eukaryotes | SAR_Eukaryotes | 167 | 1.48e-47 | NR | ACX30945.1 | 74792 | g25863 | i0 | 89.4 | 1.97202797202797 | 94 | 10 | 98.6 | 0 | 3 | 284 | 35 | 128 | ACX30945.1 cytochrome b [Moneuplotes minuta] | diamond | 564 | 167 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes minuta | ||
| 28740597 | 28740597 | PRJNA1044115_P_NODE_44147_length_202_cov_4.209302_g43963_i0 | PRJNA1044115 | 44147 | 202 | 4.209302 | 8.50279004 | Euplotes vannus | 5939 | SAR_Eukaryotes | SAR_Eukaryotes | 62.4 | 2.52e-9 | NR | QTT61064.1 | 5939 | g43963 | i0 | 77.5 | 0.594059405940594 | 40 | 9 | 59.4 | 0 | 83 | 202 | 392 | 431 | QTT61064.1 hypothetical protein [Euplotes vannus] | diamond | 120 | 62.4 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes vannus | ||
| 28898310 | 28898310 | PRJNA1044115_P_NODE_36228_length_250_cov_0.881356_g36044_i0 | PRJNA1044115 | 36228 | 250 | 0.881356 | 2.20339 | Tetrahymena utriculariae | 2486642 | SAR_Eukaryotes | SAR_Eukaryotes | 70.9 | 5.29e-12 | NR | KAL4509228.1 | 2486642 | g36044 | i0 | 46.9 | 0.768 | 64 | 31 | 74.4 | 2 | 202 | 17 | 930 | 992 | KAL4509228.1 hypothetical protein ABPG72_018159 [Tetrahymena utriculariae] | diamond | 192 | 70.9 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena utriculariae | ||
| 30414705 | 30414705 | PRJNA1044115_P_NODE_43973_length_211_cov_4.862319_g43789_i0 | PRJNA1044115 | 43973 | 211 | 4.862319 | 10.25949309 | Euplotes aediculatus | 5940 | SAR_Eukaryotes | SAR_Eukaryotes | 119 | 1.36e-33 | NR | QTT61051.1 | 5940 | g43789 | i0 | 92.4 | 0.938388625592417 | 66 | 5 | 93.8 | 0 | 211 | 14 | 10 | 75 | QTT61051.1 ATPase subunit 9 [Euplotes aediculatus] | diamond | 198 | 119 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Euplotes | Euplotes aediculatus | ||
| 30572133 | 30572133 | PRJNA1044115_P_NODE_35293_length_251_cov_0.876404_g35109_i0 | PRJNA1044115 | 35293 | 251 | 0.876404 | 2.19977404 | Bacillariaceae sp. | 3061772 | SAR_Eukaryotes | SAR_Eukaryotes | 70.5 | 7.04e-12 | NR | KAL3924535.1 | 3061772 | g35109 | i0 | 41.5 | 1.93625498007968 | 82 | 47 | 96.8 | 1 | 1 | 243 | 644 | 725 | KAL3924535.1 MAG: hypothetical protein SGILL_000986 [Bacillariaceae sp.] | diamond | 486 | 70.5 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Bacillariaceae sp. |
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);;