contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA414225" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418912 | 418912 | PRJNA414225_P_NODE_39481_length_172_cov_1.658537_g39394_i0 | PRJNA414225 | 39481 | 172 | 1.658537 | 2.85268364 | Dinobryon cylindricum | 420577 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 1.33e-57 | NTclustered | gi|2445524902|gb|OQ453362.1| | 3028919 | g39394 | i0 | 91.765 | 98.3546511627907 | 170 | 12 | 98 | 2 | 4 | 172 | 1532 | 1364 | Dinobryon cylindricum var. palustre strain Joogyo2je043021MS12 large subunit ribosomal RNA gene, partial sequence | blastn | 16917 | 235 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Dinobryon | Dinobryon cylindricum | |||
| 3633915 | 3633915 | PRJNA414225_P_NODE_1703_length_327_cov_2.089928_g1616_i0 | PRJNA414225 | 1703 | 327 | 2.089928 | 6.83406456 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 2.93e-37 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g1616 | i0 | 96.117 | 0.944954128440367 | 103 | 4 | 31 | 0 | 1 | 103 | 2980 | 3082 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 309 | 169 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 4245930 | 4245930 | PRJNA414225_P_NODE_10224_length_210_cov_1.105590_g10137_i0 | PRJNA414225 | 10224 | 210 | 1.10559 | 2.321739 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 1.29e-73 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g10137 | i0 | 92.965 | 25.4714285714286 | 199 | 12 | 94 | 2 | 14 | 210 | 302112 | 302310 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 5349 | 289 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 4911123 | 4911123 | PRJNA414225_P_NODE_29644_length_179_cov_1.569231_g29557_i0 | PRJNA414225 | 29644 | 179 | 1.569231 | 2.80892349 | Chromulinales | 96792 | SAR_Eukaryotes | SAR_Eukaryotes | 237 | 3.9e-58 | NTclustered | gi|323690577|gb|GU935636.1| | 2986 | g29557 | i0 | 90.96 | 99.3854748603352 | 177 | 14 | 98 | 2 | 1 | 176 | 1176 | 1351 | Ochromonas danica strain SAG 933.7 28S ribosomal RNA gene, partial sequence | blastn | 17790 | 237 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 4911137 | 4911137 | PRJNA414225_P_NODE_33064_length_176_cov_4.661417_g32977_i0 | PRJNA414225 | 33064 | 176 | 4.661417 | 8.20409392 | Aphanomyces | 100860 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 2.85e-84 | NTclustered | gi|363498776|gb|JN662487.1| | 120398 | g32977 | i0 | 100 | 99.8806818181818 | 175 | 0 | 99 | 0 | 2 | 176 | 523 | 349 | Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 17579 | 324 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces stellatus | ||
| 4911236 | 4911236 | PRJNA414225_P_NODE_75864_length_163_cov_2.149123_g75777_i0 | PRJNA414225 | 75864 | 163 | 2.149123 | 3.50307049 | root | 1 | Root_unresolved | Root_unresolved | 291 | 2.64e-74 | NTclustered | gi|833494852|ref|XM_012915026.1| | 5866 | g75777 | i0 | 98.773 | 96.9877300613497 | 163 | 2 | 100 | 0 | 1 | 163 | 273 | 111 | Babesia bigemina hypothetical protein, conserved partial mRNA | blastn | 15809 | 291 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Piroplasmida | Babesiidae | Babesia | Babesia bigemina | ||
| 7461039 | 7461039 | PRJNA414225_P_NODE_2746_length_279_cov_2.195652_g2659_i0 | PRJNA414225 | 2746 | 279 | 2.195652 | 6.12586908 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 510 | 3.5299999999999996e-140 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g2659 | i0 | 99.642 | 92.8817204301075 | 279 | 1 | 100 | 0 | 1 | 279 | 981 | 1259 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25914 | 510 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10011210 | 10011210 | PRJNA414225_P_NODE_34268_length_176_cov_1.212598_g34181_i0 | PRJNA414225 | 34268 | 176 | 1.212598 | 2.13417248 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 313 | 6.1699999999999985e-81 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g34181 | i0 | 98.857 | 19.9147727272727 | 175 | 2 | 99 | 0 | 2 | 176 | 1451 | 1277 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 3505 | 313 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10622902 | 10622902 | PRJNA414225_P_NODE_81429_length_163_cov_0.894737_g81342_i0 | PRJNA414225 | 81429 | 163 | 0.894737 | 1.45842131 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 9.72e-59 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g81342 | i0 | 95.364 | 3.87730061349693 | 151 | 6 | 92 | 1 | 1 | 150 | 157473 | 157323 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 632 | 239 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 10622926 | 10622926 | PRJNA414225_P_NODE_8989_length_216_cov_0.814371_g8902_i0 | PRJNA414225 | 8989 | 216 | 0.814371 | 1.75904136 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 2.23e-71 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g8902 | i0 | 90.278 | 71.1898148148148 | 216 | 20 | 99 | 1 | 2 | 216 | 116677 | 116892 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 15377 | 281 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 11897792 | 11897792 | PRJNA414225_P_NODE_5210_length_241_cov_1.270833_g5123_i0 | PRJNA414225 | 5210 | 241 | 1.270833 | 3.06270753 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 5.62e-53 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g5123 | i0 | 91.772 | 33.9294605809129 | 158 | 13 | 98 | 0 | 1 | 158 | 302521 | 302678 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 8177 | 220 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14447770 | 14447770 | PRJNA414225_P_NODE_2492_length_287_cov_0.794118_g2405_i0 | PRJNA414225 | 2492 | 287 | 0.794118 | 2.27911866 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 6.31e-113 | NTclustered | gi|820695469|tpe|LN714488.1| | 572307 | g2405 | i0 | 93.31 | 36.7560975609756 | 284 | 19 | 100 | 0 | 4 | 287 | 116445 | 116162 | TPA_asm: Neospora caninum Liverpool, unplaced_1, complete genome | blastn | 10549 | 420 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 14447910 | 14447910 | PRJNA414225_P_NODE_9232_length_214_cov_1.854545_g9145_i0 | PRJNA414225 | 9232 | 214 | 1.854545 | 3.9687263 | Aphanomyces sp. | 1982524 | SAR_Eukaryotes | SAR_Eukaryotes | 396 | 7.559999999999996e-106 | NTclustered | gi|1578815424|gb|MK546601.1| | 1982524 | g9145 | i0 | 100 | 100.065420560748 | 214 | 0 | 100 | 0 | 1 | 214 | 352 | 565 | Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence | blastn | 21414 | 396 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces sp. | ||
| 16996402 | 16996402 | PRJNA414225_P_NODE_6234_length_232_cov_1.661202_g6147_i0 | PRJNA414225 | 6234 | 232 | 1.661202 | 3.85398864 | Anthophysa vegetans | 459040 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 5.3e-63 | NTclustered | gi|161015692|gb|EF681926.1| | 459040 | g6147 | i0 | 86.441 | 71.75 | 236 | 26 | 100 | 6 | 1 | 232 | 238 | 5 | Anthophysa vegetans strain HFCC30 28S ribosomal RNA gene, partial sequence | blastn | 16646 | 254 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Anthophysa | Anthophysa vegetans | |||
| 17660775 | 17660775 | PRJNA414225_P_NODE_82694_length_162_cov_3.601770_g82607_i0 | PRJNA414225 | 82694 | 162 | 3.60177 | 5.8348674 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|291495599|gb|GU823226.1| | 152704 | g82607 | i0 | 100 | 100 | 162 | 0 | 100 | 0 | 1 | 162 | 856 | 695 | Uncultured stramenopile clone BCA5F13RJ3F09 18S ribosomal RNA gene, partial sequence | blastn | 16200 | 300 | 1 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 20209413 | 20209413 | PRJNA414225_P_NODE_77036_length_163_cov_1.350877_g76949_i0 | PRJNA414225 | 77036 | 163 | 1.350877 | 2.20192951 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.004 | NTclustered | gi|855313788|ref|XM_013042842.1| | 12968 | g76949 | i0 | 100 | 2.28220858895706 | 29 | 0 | 18 | 0 | 135 | 163 | 1540 | 1512 | Blastocystis hominis mRNA | blastn | 372 | 54.7 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis hominis | |||
| 23371000 | 23371000 | PRJNA414225_P_NODE_379_length_679_cov_2.873016_g305_i0 | PRJNA414225 | 379 | 679 | 2.873016 | 19.50777864 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 1127 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g305 | i0 | 96.613 | 56.4418262150221 | 679 | 23 | 100 | 0 | 1 | 679 | 1531 | 2209 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 38324 | 1127 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 24645338 | 24645338 | PRJNA414225_P_NODE_500_length_586_cov_2.847300_g421_i0 | PRJNA414225 | 500 | 586 | 2.8473 | 16.685178 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 961 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g421 | i0 | 96.398 | 43.8959044368601 | 583 | 21 | 99 | 0 | 1 | 583 | 67 | 649 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 25723 | 961 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola |
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);;