contig_metadata
24 rows where bioproject = "PRJNA853203" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2116935 | 2116935 | PRJNA853203_P_NODE_46222_length_243_cov_0.917647_g46073_i0 | PRJNA853203 | 46222 | 243 | 0.917647 | 2.22988221 | Phytophthora litchii | 100870 | SAR_Eukaryotes | SAR_Eukaryotes | 438 | 1.4399999999999996e-118 | NTclustered | gi|2248512916|ref|NC_063792.1| | 100870 | g46073 | i0 | 99.177 | 99.7901234567901 | 243 | 2 | 100 | 0 | 1 | 243 | 1081 | 839 | Phytophthora litchii isolate SHS3 mitochondrion, complete genome | blastn | 24249 | 438 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora litchii | ||
| 5944619 | 5944619 | PRJNA853203_P_NODE_29625_length_251_cov_2.039326_g29476_i0 | PRJNA853203 | 29625 | 251 | 2.039326 | 5.11870826 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 2.88e-16 | NTclustered | gi|325194684|emb|FR825494.1| | 890382 | g29476 | i0 | 92.754 | 24.808764940239 | 69 | 4 | 27 | 1 | 184 | 251 | 206 | 138 | Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 | blastn | 6227 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 5944796 | 5944796 | PRJNA853203_P_NODE_8425_length_293_cov_2.195455_g8276_i0 | PRJNA853203 | 8425 | 293 | 2.195455 | 6.43268315 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 399 | 8.419999999999998e-107 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g8276 | i0 | 91.696 | 1.21843003412969 | 289 | 22 | 98 | 2 | 1 | 287 | 1208 | 920 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 357 | 399 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 7219675 | 7219675 | PRJNA853203_P_NODE_40006_length_246_cov_0.901734_g39857_i0 | PRJNA853203 | 40006 | 246 | 0.901734 | 2.21826564 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 3.27e-27 | NR | XP_009032801.1 | 44056 | g39857 | i0 | 64.9 | 3.81707317073171 | 77 | 26 | 92.7 | 1 | 12 | 239 | 120 | 196 | XP_009032801.1 hypothetical protein AURANDRAFT_18666 [Aureococcus anophagefferens] | diamond | 939 | 111 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagomonadales | Pelagomonadaceae | Aureococcus | Aureococcus anophagefferens | |||
| 8494332 | 8494332 | PRJNA853203_P_NODE_30207_length_251_cov_0.876404_g30058_i0 | PRJNA853203 | 30207 | 251 | 0.876404 | 2.19977404 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 252 | 2.09e-62 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g30058 | i0 | 87.907 | 28.5856573705179 | 215 | 25 | 100 | 1 | 25 | 238 | 302045 | 302259 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 7175 | 252 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 8887740 | 8887740 | PRJNA853203_P_NODE_5487_length_327_cov_1.181102_g5338_i0 | PRJNA853203 | 5487 | 327 | 1.181102 | 3.86220354 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.5199999999999998e-142 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g5338 | i0 | 95.399 | 72.5840978593272 | 326 | 13 | 99 | 2 | 3 | 327 | 177 | 501 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 23735 | 518 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 9769659 | 9769659 | PRJNA853203_P_NODE_948_length_633_cov_3.501786_g802_i0 | PRJNA853203 | 948 | 633 | 3.501786 | 22.16630538 | Ebria tripartita | 361426 | SAR_Eukaryotes | SAR_Eukaryotes | 206 | 4.5599999999999997e-48 | NTclustered | gi|290760481|gb|GQ144684.1| | 361426 | g802 | i0 | 83.051 | 37.4296998420221 | 236 | 31 | 37 | 8 | 1 | 232 | 2924 | 2694 | Ebria tripartita large subunit ribosomal RNA gene, partial sequence | blastn | 23693 | 206 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Ebriacea | Ebria | Ebria tripartita | |||
| 12320703 | 12320703 | PRJNA853203_P_NODE_35470_length_248_cov_1.177143_g35321_i0 | PRJNA853203 | 35470 | 248 | 1.177143 | 2.91931464 | Phytophthora infestans | 4787 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.24e-59 | NTclustered | gi|301113801|ref|XM_002998625.1| | 403677 | g35321 | i0 | 84.274 | 1 | 248 | 39 | 100 | 0 | 1 | 248 | 3385 | 3632 | Phytophthora infestans T30-4 uncharacterized protein (PITG_06580), partial mRNA | blastn | 248 | 243 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora infestans | ||
| 13595299 | 13595299 | PRJNA853203_P_NODE_44751_length_243_cov_1.611765_g44602_i0 | PRJNA853203 | 44751 | 243 | 1.611765 | 3.91658895 | Nitzschia sp. DOCU1 | 3041873 | SAR_Eukaryotes | SAR_Eukaryotes | 377 | 3.18e-100 | NTclustered | gi|2504366779|emb|OX596002.1| | 3041873 | g44602 | i0 | 94.694 | 106.17695473251 | 245 | 9 | 100 | 4 | 1 | 243 | 31785 | 31543 | Nitzschia sp. DOCU1 genome assembly, organelle: mitochondrion | blastn | 25801 | 377 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Nitzschia | Nitzschia sp. DOCU1 | ||
| 14869450 | 14869450 | PRJNA853203_P_NODE_3812_length_358_cov_1.547368_g3664_i0 | PRJNA853203 | 3812 | 358 | 1.547368 | 5.53957744 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 7.52e-163 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g3664 | i0 | 96.348 | 74.6480446927374 | 356 | 13 | 99 | 0 | 3 | 358 | 2316 | 1961 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 26724 | 586 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 15262749 | 15262749 | PRJNA853203_P_NODE_49912_length_228_cov_2.058065_g49763_i0 | PRJNA853203 | 49912 | 228 | 2.058065 | 4.6923882 | Peronosporaceae | 4777 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 2.38e-71 | NTclustered | gi|2235892989|tpg|BK012092.1| | 129355 | g49763 | i0 | 88.987 | 3.99122807017544 | 227 | 25 | 99 | 0 | 2 | 228 | 23050 | 23276 | TPA_asm: Phytophthora lateralis strain SMST21 mitochondrion, complete genome | blastn | 910 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora lateralis | ||
| 19086287 | 19086287 | PRJNA853203_P_NODE_8895_length_292_cov_1.100457_g8746_i0 | PRJNA853203 | 8895 | 292 | 1.100457 | 3.21333444 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 3.17e-71 | NTclustered | gi|83034975|gb|DQ211604.1| | 352465 | g8746 | i0 | 98.137 | 48.3938356164384 | 161 | 3 | 55 | 0 | 1 | 161 | 383 | 543 | Bodomorpha sp. HFCC57 28S ribosomal RNA gene, partial sequence | blastn | 14131 | 281 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha sp. HFCC57 | |||
| 19967995 | 19967995 | PRJNA853203_P_NODE_30836_length_251_cov_0.876404_g30687_i0 | PRJNA853203 | 30836 | 251 | 0.876404 | 2.19977404 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 459 | 1.1499999999999996e-124 | NTclustered | gi|695467766|ref|XM_009541409.1| | 67593 | g30687 | i0 | 99.602 | 87.4342629482072 | 251 | 1 | 100 | 0 | 1 | 251 | 251 | 1 | Phytophthora sojae hypothetical protein mRNA | blastn | 21946 | 459 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 22518344 | 22518344 | PRJNA853203_P_NODE_8018_length_297_cov_0.901786_g7869_i0 | PRJNA853203 | 8018 | 297 | 0.901786 | 2.67830442 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 516 | 8.14e-142 | NTclustered | gi|325194231|emb|FR825088.1| | 890382 | g7869 | i0 | 97.98 | 14.1616161616162 | 297 | 6 | 100 | 0 | 1 | 297 | 1547 | 1251 | Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 | blastn | 4206 | 516 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 24186155 | 24186155 | PRJNA853203_P_NODE_1559_length_486_cov_4.280872_g1412_i0 | PRJNA853203 | 1559 | 486 | 4.280872 | 20.80503792 | Plasmodium | 5820 | SAR_Eukaryotes | SAR_Eukaryotes | 139 | 3.5399999999999993e-28 | NTclustered | gi|1976646300|ref|XR_005506384.1| | 5851 | g1412 | i0 | 88.793 | 24.4794238683128 | 116 | 9 | 23 | 4 | 150 | 263 | 2235 | 2348 | Plasmodium knowlesi strain H 28S ribosomal RNA (PKNH_1001000), rRNA | blastn | 11897 | 139 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium knowlesi | ||
| 27212895 | 27212895 | PRJNA853203_P_NODE_45042_length_243_cov_0.917647_g44893_i0 | PRJNA853203 | 45042 | 243 | 0.917647 | 2.22988221 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 72.8 | 1e-12 | NR | KAL3801545.1 | 29204 | g44893 | i0 | 82.3 | 1.95061728395062 | 79 | 14 | 97.5 | 0 | 1 | 237 | 564 | 642 | KAL3801545.1 hypothetical protein HJC23_000983 [Cyclotella cryptica] | diamond | 474 | 72.8 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 27907603 | 27907603 | PRJNA853203_P_NODE_39465_length_246_cov_0.901734_g39316_i0 | PRJNA853203 | 39465 | 246 | 0.901734 | 2.21826564 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 62 | 6.37e-9 | NR | CAK9071266.1 | 1381693 | g39316 | i0 | 43.8 | 0.890243902439024 | 73 | 38 | 85.4 | 1 | 3 | 212 | 69 | 141 | CAK9071266.1 Adenylate cyclase type 10 (AH-related protein) (Adenylate cyclase homolog) (Germ cell soluble adenylyl cyclase) (hsAC) (sAC) (Testicular soluble adenylyl cyclase) [Durusdinium trenchii] | diamond | 219 | 62 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 28286533 | 28286533 | PRJNA853203_P_NODE_13986_length_279_cov_1.728155_g13837_i0 | PRJNA853203 | 13986 | 279 | 1.728155 | 4.82155245 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 69.7 | 1.93e-11 | NR | KAL3780888.1 | 29204 | g13837 | i0 | 47.4 | 0.838709677419355 | 78 | 41 | 83.9 | 0 | 277 | 44 | 824 | 901 | KAL3780888.1 hypothetical protein HJC23_009934 [Cyclotella cryptica] | diamond | 234 | 69.7 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 29202541 | 29202541 | PRJNA853203_P_NODE_43429_length_244_cov_0.912281_g43280_i0 | PRJNA853203 | 43429 | 244 | 0.912281 | 2.22596564 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 43.1 | 0.0183 | NR | KAL3783202.1 | 29204 | g43280 | i0 | 68.8 | 0.39344262295082 | 32 | 9 | 38.1 | 1 | 93 | 1 | 1 | 32 | KAL3783202.1 hypothetical protein HJC23_013545 [Cyclotella cryptica] | diamond | 96 | 43.1 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 30971426 | 30971426 | PRJNA853203_P_NODE_10914_length_287_cov_1.130841_g10765_i0 | PRJNA853203 | 10914 | 287 | 1.130841 | 3.24551367 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 72 | 3.26e-12 | NR | KAJ1422616.1 | 483371 | g10765 | i0 | 56.9 | 0.606271777003484 | 58 | 24 | 59.6 | 1 | 79 | 249 | 270 | 327 | KAJ1422616.1 Spc98 family-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 174 | 72 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31034801 | 31034801 | PRJNA853203_P_NODE_28895_length_252_cov_0.871508_g28746_i0 | PRJNA853203 | 28895 | 252 | 0.871508 | 2.19620016 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 44.7 | 0.00866 | NR | KAL3776596.1 | 29204 | g28746 | i0 | 86.4 | 0.523809523809524 | 22 | 3 | 26.2 | 0 | 251 | 186 | 38 | 59 | KAL3776596.1 hypothetical protein HJC23_005796 [Cyclotella cryptica] | diamond | 132 | 44.7 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 31350716 | 31350716 | PRJNA853203_P_NODE_32276_length_250_cov_0.881356_g32127_i0 | PRJNA853203 | 32276 | 250 | 0.881356 | 2.20339 | Moneuplotes crassus | 5936 | SAR_Eukaryotes | SAR_Eukaryotes | 65.5 | 3.95e-10 | NR | CAI2366031.1 | 5936 | g32127 | i0 | 43.4 | 0.912 | 76 | 39 | 91.2 | 1 | 247 | 20 | 141 | 212 | CAI2366031.1 unnamed protein product [Moneuplotes crassus] | diamond | 228 | 65.5 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Euplotida | Euplotidae | Moneuplotes | Moneuplotes crassus | ||
| 31508900 | 31508900 | PRJNA853203_P_NODE_18736_length_269_cov_1.224490_g18587_i0 | PRJNA853203 | 18736 | 269 | 1.22449 | 3.2938781 | Cyclotella cryptica | 29204 | SAR_Eukaryotes | SAR_Eukaryotes | 48.9 | 3.38e-4 | NR | KAL3792175.1 | 29204 | g18587 | i0 | 53.7 | 0.45724907063197 | 41 | 19 | 45.7 | 0 | 124 | 2 | 37 | 77 | KAL3792175.1 hypothetical protein HJC23_009639 [Cyclotella cryptica] | diamond | 123 | 48.9 | 1 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 31508904 | 31508904 | PRJNA853203_P_NODE_25036_length_255_cov_3.071429_g24887_i0 | PRJNA853203 | 25036 | 255 | 3.071429 | 7.83214395 | Vaucheria litorea | 109269 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 3.08e-39 | NR | YP_002327561.1 | 109269 | g24887 | i0 | 78.6 | 2.96470588235294 | 84 | 18 | 98.8 | 0 | 3 | 254 | 89 | 172 | YP_002327561.1 photosystem I assembly protein Ycf4 [Vaucheria litorea] | diamond | 756 | 138 | 1 | Eukaryota | Sar | Xanthophyceae | Vaucheriales | Vaucheriaceae | Vaucheria | Vaucheria litorea |
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);;