contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA473641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 444785 | 444785 | PRJNA473641_P_NODE_11081_length_304_cov_1.658009_g10998_i0 | PRJNA473641 | 11081 | 304 | 1.658009 | 5.04034736 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 507 | 5.03e-139 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g10998 | i0 | 96.711 | 2.37828947368421 | 304 | 10 | 100 | 0 | 1 | 304 | 6819 | 7122 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 723 | 507 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 445255 | 445255 | PRJNA473641_P_NODE_4141_length_438_cov_2.583562_g4058_i0 | PRJNA473641 | 4141 | 438 | 2.583562 | 11.31600156 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 784 | 0 | NTclustered | gi|2234196641|dbj|LC627764.1| | 153251 | g4058 | i0 | 98.866 | 3.98630136986301 | 441 | 2 | 100 | 3 | 1 | 438 | 966 | 526 | Cryptocaryon irritans UT2 mRNA for agglutination/immobilization antigen, partial cds, clone: UT2_i_antigen_1 | blastn | 1746 | 784 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 1719689 | 1719689 | PRJNA473641_P_NODE_13662_length_279_cov_2.577670_g13579_i0 | PRJNA473641 | 13662 | 279 | 2.57767 | 7.1916993 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 499 | 7.63e-137 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g13579 | i0 | 98.925 | 100.268817204301 | 279 | 3 | 100 | 0 | 1 | 279 | 5616 | 5338 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 27975 | 499 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 2995870 | 2995870 | PRJNA473641_P_NODE_483_length_1037_cov_2.057054_g428_i0 | PRJNA473641 | 483 | 1037 | 2.057054 | 21.33164998 | Pseudo-nitzschia sabit | 1664502 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 1.72e-14 | NTclustered | gi|2852238230|gb|PQ498358.1| | 1664502 | g428 | i0 | 82.883 | 32.4146576663452 | 111 | 13 | 10 | 6 | 169 | 276 | 33333 | 33440 | Pseudo-nitzschia sabit isolate CNS00609 mitochondrion, complete genome | blastn | 33614 | 95.3 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Pseudo-nitzschia | Pseudo-nitzschia sabit | ||
| 5548696 | 5548696 | PRJNA473641_P_NODE_2225_length_564_cov_1.602851_g2143_i0 | PRJNA473641 | 2225 | 564 | 1.602851 | 9.04007964 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 427 | 7.91e-115 | NTclustered | gi|166043465|emb|CU359703.1| | 100861 | g2143 | i0 | 83.058 | 69.7978723404255 | 484 | 68 | 85 | 12 | 44 | 520 | 529 | 53 | Aphanomyces euteiches cDNA | blastn | 39366 | 427 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 6822885 | 6822885 | PRJNA473641_P_NODE_6026_length_378_cov_1.570492_g5943_i0 | PRJNA473641 | 6026 | 378 | 1.570492 | 5.93645976 | Aphanomyces euteiches | 100861 | SAR_Eukaryotes | SAR_Eukaryotes | 154 | 9.6e-33 | NTclustered | gi|166036439|emb|CU349481.1| | 100861 | g5943 | i0 | 80.905 | 6.48412698412698 | 199 | 34 | 52 | 2 | 3 | 199 | 558 | 754 | Aphanomyces euteiches cDNA | blastn | 2451 | 154 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 9372620 | 9372620 | PRJNA473641_P_NODE_14368_length_273_cov_1.570000_g14285_i0 | PRJNA473641 | 14368 | 273 | 1.57 | 4.2861 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 1.39e-59 | NTclustered | gi|698785784|ref|XM_009827634.1| | 112090 | g14285 | i0 | 86.425 | 95.1648351648352 | 221 | 30 | 81 | 0 | 26 | 246 | 163 | 383 | Aphanomyces astaci histone H3 partial mRNA | blastn | 25980 | 243 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 9373032 | 9373032 | PRJNA473641_P_NODE_6848_length_361_cov_9.906250_g6765_i0 | PRJNA473641 | 6848 | 361 | 9.90625 | 35.7615625 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 667 | 0 | NTclustered | gi|1004125725|gb|KU761582.1| | 153251 | g6765 | i0 | 100 | 99.6149584487535 | 361 | 0 | 100 | 0 | 1 | 361 | 2494 | 2134 | Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence | blastn | 35961 | 667 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 11298704 | 11298704 | PRJNA473641_P_NODE_3669_length_459_cov_5.196891_g3586_i0 | PRJNA473641 | 3669 | 459 | 5.196891 | 23.85372969 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 235 | 4.12e-57 | NTclustered | gi|698807229|ref|XM_009838342.1| | 112090 | g3586 | i0 | 84.979 | 68.3050108932462 | 233 | 34 | 51 | 1 | 226 | 457 | 299 | 67 | Aphanomyces astaci polyubiquitin mRNA | blastn | 31352 | 235 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 11923449 | 11923449 | PRJNA473641_P_NODE_1130_length_745_cov_3.431548_g1058_i0 | PRJNA473641 | 1130 | 745 | 3.431548 | 25.5650326 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 3.08e-85 | NTclustered | gi|471230286|ref|XM_004036375.1| | 5932 | g1058 | i0 | 75.61 | 24.8228187919463 | 697 | 153 | 92 | 15 | 1 | 689 | 646 | 1333 | Ichthyophthirius multifiliis hypothetical protein (IMG5_083250) mRNA, complete cds | blastn | 18493 | 329 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 13198381 | 13198381 | PRJNA473641_P_NODE_11391_length_301_cov_2.447368_g11308_i0 | PRJNA473641 | 11391 | 301 | 2.447368 | 7.36657768 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 3.819999999999999e-145 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g11308 | i0 | 98.658 | 91.6943521594684 | 298 | 3 | 99 | 1 | 1 | 297 | 5389 | 5686 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 27600 | 527 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 14473533 | 14473533 | PRJNA473641_P_NODE_1672_length_633_cov_2.612500_g1590_i0 | PRJNA473641 | 1672 | 633 | 2.6125 | 16.537125 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 1092 | 0 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g1590 | i0 | 97.937 | 57.9794628751975 | 630 | 13 | 99 | 0 | 4 | 633 | 6416 | 5787 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 36701 | 1092 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 17022365 | 17022365 | PRJNA473641_P_NODE_19934_length_248_cov_0.880000_g19851_i0 | PRJNA473641 | 19934 | 248 | 0.88 | 2.1824 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 359 | 1.18e-94 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g19851 | i0 | 92.771 | 46.1088709677419 | 249 | 17 | 100 | 1 | 1 | 248 | 32218 | 31970 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 11435 | 359 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 17022614 | 17022614 | PRJNA473641_P_NODE_6634_length_365_cov_1.880137_g6551_i0 | PRJNA473641 | 6634 | 365 | 1.880137 | 6.86250005 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 595 | 1.2799999999999998e-165 | NTclustered | gi|2431531581|ref|NC_070360.1| | 153251 | g6551 | i0 | 96.164 | 1 | 365 | 12 | 99 | 2 | 1 | 363 | 7088 | 7452 | Cryptocaryon irritans mitochondrion, complete genome | blastn | 365 | 595 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 18296464 | 18296464 | PRJNA473641_P_NODE_14175_length_275_cov_1.500000_g14092_i0 | PRJNA473641 | 14175 | 275 | 1.5 | 4.125 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 158 | 5.21e-34 | NTclustered | gi|698810055|ref|XM_009839755.1| | 112090 | g14092 | i0 | 77.407 | 1.82909090909091 | 270 | 58 | 98 | 3 | 1 | 269 | 1106 | 839 | Aphanomyces astaci transitional endoplasmic reticulum ATPase mRNA | blastn | 503 | 158 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 18296831 | 18296831 | PRJNA473641_P_NODE_4255_length_434_cov_1.033241_g4172_i0 | PRJNA473641 | 4255 | 434 | 1.033241 | 4.48426594 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 560 | 5.63e-155 | NTclustered | gi|1779767357|gb|MK861969.1| | 153251 | g4172 | i0 | 90.278 | 26.5299539170507 | 432 | 36 | 99 | 3 | 1 | 432 | 2105 | 1680 | Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds | blastn | 11514 | 560 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 20846823 | 20846823 | PRJNA473641_P_NODE_4237_length_434_cov_3.155125_g4154_i0 | PRJNA473641 | 4237 | 434 | 3.155125 | 13.6932425 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 58.4 | 0.001 | NTclustered | gi|914998613|ref|XM_013392164.1| | 5801 | g4154 | i0 | 91.111 | 0.175115207373272 | 45 | 0 | 10 | 3 | 71 | 112 | 121 | 164 | Eimeria acervulina hypothetical protein partial mRNA | blastn | 76 | 58.4 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 20846847 | 20846847 | PRJNA473641_P_NODE_5177_length_401_cov_1.021341_g5094_i0 | PRJNA473641 | 5177 | 401 | 1.021341 | 4.09557741 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 603 | 8.459999999999999e-168 | NTclustered | gi|1779767357|gb|MK861969.1| | 153251 | g5094 | i0 | 93.766 | 62.3266832917706 | 401 | 25 | 100 | 0 | 1 | 401 | 1603 | 1203 | Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds | blastn | 24993 | 603 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 22121711 | 22121711 | PRJNA473641_P_NODE_4938_length_408_cov_1.465672_g4855_i0 | PRJNA473641 | 4938 | 408 | 1.465672 | 5.97994176 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 555 | 2.45e-153 | NTclustered | gi|1779767357|gb|MK861969.1| | 153251 | g4855 | i0 | 91.379 | 3.77450980392157 | 406 | 34 | 99 | 1 | 1 | 406 | 1214 | 810 | Cryptocaryon irritans isolate GD1 dnaK mRNA, complete cds | blastn | 1540 | 555 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 22772471 | 22772471 | PRJNA473641_P_NODE_16438_length_256_cov_1.027322_g16355_i0 | PRJNA473641 | 16438 | 256 | 1.027322 | 2.62994432 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.1699999999999993e-52 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g16355 | i0 | 82.171 | 87.46875 | 258 | 42 | 100 | 4 | 1 | 256 | 532 | 787 | Pyrocystis lunula actin mRNA, complete cds | blastn | 22392 | 219 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 23397524 | 23397524 | PRJNA473641_P_NODE_8319_length_336_cov_7.422053_g8236_i0 | PRJNA473641 | 8319 | 336 | 7.422053 | 24.93809808 | Cryptocaryon irritans | 153251 | SAR_Eukaryotes | SAR_Eukaryotes | 621 | 1.9299999999999997e-173 | NTclustered | gi|1161057763|gb|KY440336.1| | 153251 | g8236 | i0 | 100 | 100.145833333333 | 336 | 0 | 100 | 0 | 1 | 336 | 1561 | 1226 | Cryptocaryon irritans isolate CN_CL_2012 18S ribosomal RNA gene, partial sequence | blastn | 33649 | 621 | 1 | Eukaryota | Sar | Ciliophora | Cryptocaryon | Cryptocaryon irritans | |||||
| 24671341 | 24671341 | PRJNA473641_P_NODE_4760_length_414_cov_1.354839_g4677_i0 | PRJNA473641 | 4760 | 414 | 1.354839 | 5.60903346 | Amphifilidae sp. H-1 | 1407012 | SAR_Eukaryotes | SAR_Eukaryotes | 717 | 0 | NTclustered | gi|550533551|dbj|AB856528.1| | 1407012 | g4677 | i0 | 97.837 | 72.0821256038647 | 416 | 7 | 100 | 2 | 1 | 414 | 456 | 41 | Amphifilidae sp. H-1 gene for 18S ribosomal RNA, partial sequence | blastn | 29842 | 717 | 1 | Eukaryota | Sar | Bigyra | Amphifilida | Amphifilaceae | Amphifilidae sp. H-1 |
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);;