contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA287283" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2922851 | 2922851 | PRJNA287283_P_NODE_3783_length_327_cov_1.233577_g3559_i0 | PRJNA287283 | 3783 | 327 | 1.233577 | 4.03379679 | Prorocentrum minimum | 39449 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 7.97e-53 | NTclustered | gi|37727275|gb|AY169231.1| | 39449 | g3559 | i0 | 79.062 | 15.5749235474006 | 320 | 67 | 98 | 0 | 1 | 320 | 336 | 655 | Prorocentrum minimum clone end10b ribulose 1,5-bisphosphate carboxylase oxygenase form II (rbc3) mRNA, partial cds; nuclear gene for chloroplast product | blastn | 5093 | 220 | 1 | Eukaryota | Sar | Dinophyceae | Prorocentrales | Prorocentraceae | Prorocentrum | Prorocentrum minimum | |||
| 4199311 | 4199311 | PRJNA287283_P_NODE_3724_length_330_cov_0.967509_g3500_i0 | PRJNA287283 | 3724 | 330 | 0.967509 | 3.1927797 | Piscinoodinium sp. | 2862367 | SAR_Eukaryotes | SAR_Eukaryotes | 588 | 1.9099999999999998e-163 | NTclustered | gi|2594576236|gb|OR704324.1| | 2862367 | g3500 | i0 | 98.788 | 99.4787878787879 | 330 | 4 | 100 | 0 | 1 | 330 | 51 | 380 | Piscinoodinium sp. isolate Andaman-PSIII small subunit ribosomal RNA gene, partial sequence | blastn | 32828 | 588 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Piscinoodinium | Piscinoodinium sp. | |||
| 5475599 | 5475599 | PRJNA287283_P_NODE_2865_length_383_cov_1.224242_g2641_i0 | PRJNA287283 | 2865 | 383 | 1.224242 | 4.68884686 | Amphidinium carterae | 2961 | SAR_Eukaryotes | SAR_Eukaryotes | 309 | 1.9600000000000003e-79 | NTclustered | gi|193890883|gb|EU742748.1| | 2961 | g2641 | i0 | 84.967 | 76.4046997389034 | 306 | 45 | 80 | 1 | 67 | 372 | 96 | 400 | Amphidinium carterae strain CCMP1314 clone cB2_ps truncated actin mRNA, complete cds | blastn | 29263 | 309 | 1 | Eukaryota | Sar | Dinophyceae | Amphidiniales | Amphidiniaceae | Amphidinium | Amphidinium carterae | |||
| 5475603 | 5475603 | PRJNA287283_P_NODE_5305_length_258_cov_1.814634_g5081_i0 | PRJNA287283 | 5305 | 258 | 1.814634 | 4.68175572 | Gymnodinium aureolum | 107757 | SAR_Eukaryotes | SAR_Eukaryotes | 200 | 7.93e-47 | NTclustered | gi|422900967|gb|JX262544.1| | 107757 | g5081 | i0 | 81.124 | 14.3372093023256 | 249 | 47 | 97 | 0 | 10 | 258 | 857 | 609 | Gymnodinium aureolum heat shock protein 90 (hsp90) gene, partial cds | blastn | 3699 | 200 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Gymnodiniaceae | Gymnodinium | Gymnodinium aureolum | |||
| 8025474 | 8025474 | PRJNA287283_P_NODE_7307_length_202_cov_1.127517_g7083_i0 | PRJNA287283 | 7307 | 202 | 1.127517 | 2.27758434 | Trichodina centrostrigata | 1682383 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.3e-99 | NTclustered | gi|1685826183|gb|MN071233.1| | 1682383 | g7083 | i0 | 100 | 57.6683168316832 | 202 | 0 | 100 | 0 | 1 | 202 | 771 | 570 | Trichodina centrostrigata isolate Q1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 11649 | 374 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Mobilida | Trichodinidae | Trichodina | Trichodina centrostrigata | ||
| 9300252 | 9300252 | PRJNA287283_P_NODE_4448_length_295_cov_1.305785_g4224_i0 | PRJNA287283 | 4448 | 295 | 1.305785 | 3.85206575 | Margalefidinium polykrikoides | 77300 | SAR_Eukaryotes | SAR_Eukaryotes | 231 | 3.2799999999999997e-56 | NTclustered | gi|906410606|gb|KP010829.1| | 77300 | g4224 | i0 | 82.692 | 4.5864406779661 | 260 | 45 | 88 | 0 | 13 | 272 | 2054 | 1795 | Cochlodinium polykrikoides heat shock protein 90 (HSP90) mRNA, complete cds | blastn | 1353 | 231 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Gymnodiniaceae | Margalefidinium | Margalefidinium polykrikoides | |||
| 11850826 | 11850826 | PRJNA287283_P_NODE_10430_length_175_cov_0.918033_g10206_i0 | PRJNA287283 | 10430 | 175 | 0.918033 | 1.60655775 | Symbiodinium muscatinei | 128924 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 5.12e-27 | NTclustered | gi|32454982|gb|AY314974.1| | 128924 | g10206 | i0 | 88.288 | 0.634285714285714 | 111 | 13 | 63 | 0 | 1 | 111 | 138 | 248 | Symbiodinium muscatinei glyceraldehyde-3-phosphate dehydrogenase (smgap2) mRNA, complete cds | blastn | 111 | 134 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium muscatinei | |||
| 12537690 | 12537690 | PRJNA287283_P_NODE_2210_length_445_cov_1.793367_g1987_i0 | PRJNA287283 | 2210 | 445 | 1.793367 | 7.98048315 | Suessiaceae | 89955 | SAR_Eukaryotes | SAR_Eukaryotes | 673 | 0 | NTclustered | gi|18476145|gb|AY036080.1| | 89957 | g1987 | i0 | 93.96 | 99.1955056179775 | 447 | 23 | 100 | 4 | 1 | 445 | 277 | 721 | Polarella glacialis strain CCMP1383 large subunit ribosomal RNA gene, partial sequence | blastn | 44142 | 678 | 0.992625368731563 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 13126029 | 13126029 | PRJNA287283_P_NODE_8851_length_181_cov_1.367188_g8627_i0 | PRJNA287283 | 8851 | 181 | 1.367188 | 2.47461028 | Durusdinium sp. | 2486700 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 6.759999999999998e-41 | NTclustered | gi|1888575071|gb|MN148731.1| | 2486700 | g8627 | i0 | 84.53 | 1.55801104972376 | 181 | 28 | 100 | 0 | 1 | 181 | 371 | 191 | Durusdinium sp. ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) mRNA, partial cds | blastn | 282 | 180 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium sp. | |||
| 15674906 | 15674906 | PRJNA287283_P_NODE_3733_length_329_cov_2.090580_g3509_i0 | PRJNA287283 | 3733 | 329 | 2.09058 | 6.8780082 | Kryptoperidinium triquetrum | 66468 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 3.6e-76 | NTclustered | gi|54399509|gb|AY729485.1| | 66468 | g3509 | i0 | 83.232 | 0.996960486322188 | 328 | 51 | 99 | 4 | 4 | 329 | 1104 | 779 | Heterocapsa triquetra EF-1 alpha-like protein (efl) mRNA, complete cds | blastn | 328 | 298 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Kryptoperidiniaceae | Kryptoperidinium | Kryptoperidinium triquetrum | |||
| 15674913 | 15674913 | PRJNA287283_P_NODE_6333_length_227_cov_0.965517_g6109_i0 | PRJNA287283 | 6333 | 227 | 0.965517 | 2.19172359 | Amphidinium carterae | 2961 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.4999999999999999e-33 | NTclustered | gi|317134990|gb|GU373020.1| | 2961 | g6109 | i0 | 87.5 | 6.38325991189427 | 136 | 15 | 59 | 2 | 30 | 164 | 470 | 336 | Amphidinium carterae strain CCMP1314 clone 2 ribosomal protein S27a (RP-S27a) mRNA, complete cds | blastn | 1449 | 156 | 1 | Eukaryota | Sar | Dinophyceae | Amphidiniales | Amphidiniaceae | Amphidinium | Amphidinium carterae | |||
| 15674918 | 15674918 | PRJNA287283_P_NODE_7233_length_203_cov_2.413333_g7009_i0 | PRJNA287283 | 7233 | 203 | 2.413333 | 4.89906599 | Symbiodinium kawagutii | 104179 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 4.82e-18 | NTclustered | gi|512784092|gb|KC940714.1| | 104179 | g7009 | i0 | 80.292 | 4 | 137 | 27 | 67 | 0 | 1 | 137 | 216 | 80 | Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064221954(5'-), partial sequence | blastn | 812 | 104 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium kawagutii | |||
| 15674924 | 15674924 | PRJNA287283_P_NODE_9273_length_179_cov_3.095238_g9049_i0 | PRJNA287283 | 9273 | 179 | 3.095238 | 5.54047602 | Dinophyceae sp. | 1918384 | SAR_Eukaryotes | SAR_Eukaryotes | 159 | 8.689999999999998e-35 | NTclustered | gi|2509715033|gb|MZ825179.1| | 1918384 | g9049 | i0 | 82.955 | 0.983240223463687 | 176 | 30 | 98 | 0 | 4 | 179 | 509 | 334 | Dinophyceae sp. clone C-119214 heat shock protein 90 (Hsp90) mRNA, complete cds | blastn | 176 | 159 | 1 | Eukaryota | Sar | Dinophyceae | Dinophyceae sp. | ||||||
| 16949569 | 16949569 | PRJNA287283_P_NODE_10274_length_176_cov_0.910569_g10050_i0 | PRJNA287283 | 10274 | 176 | 0.910569 | 1.60260144 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 2.99e-49 | NTclustered | gi|471226989|ref|XM_004032470.1| | 5932 | g10050 | i0 | 88.757 | 6.25 | 169 | 19 | 96 | 0 | 8 | 176 | 237 | 69 | Ichthyophthirius multifiliis ubiquitin family protein, putative (IMG5_120960) mRNA, complete cds | blastn | 1100 | 207 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 17636811 | 17636811 | PRJNA287283_P_NODE_6074_length_234_cov_1.287293_g5850_i0 | PRJNA287283 | 6074 | 234 | 1.287293 | 3.01226562 | Gonyaulacales | 40984 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 3.0699999999999996e-95 | NTclustered | gi|281331145|dbj|AB433583.1| | 2926 | g5850 | i0 | 94.468 | 92.7606837606838 | 235 | 11 | 100 | 2 | 1 | 234 | 777 | 1010 | Alexandrium tamarense chloroplast psbD mRNA for photosystem II protein D2, partial cds | blastn | 21706 | 361 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Alexandrium | Alexandrium tamarense | |||
| 19498112 | 19498112 | PRJNA287283_P_NODE_3516_length_339_cov_1.174825_g3292_i0 | PRJNA287283 | 3516 | 339 | 1.174825 | 3.98265675 | Polarella glacialis | 89957 | SAR_Eukaryotes | SAR_Eukaryotes | 219 | 2.9799999999999998e-52 | NTclustered | gi|35210459|dbj|AB106692.1| | 89957 | g3292 | i0 | 83.475 | 3.29498525073746 | 236 | 37 | 69 | 2 | 105 | 339 | 1 | 235 | Polarella glacialis GapC3 mRNA for glyceraldehyde-3-phosphate dehydrogenase, partial cds | blastn | 1117 | 219 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Polarella | Polarella glacialis | |||
| 19498119 | 19498119 | PRJNA287283_P_NODE_5836_length_241_cov_0.909574_g5612_i0 | PRJNA287283 | 5836 | 241 | 0.909574 | 2.19207334 | Cystoisospora suis | 483139 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.53e-24 | NTclustered | gi|2795629584|ref|XM_068068822.1| | 483139 | g5612 | i0 | 85.124 | 10.8796680497925 | 121 | 18 | 50 | 0 | 119 | 239 | 1605 | 1485 | Cystoisospora suis tubulin alpha chain (CSUI_008696), mRNA | blastn | 2622 | 124 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Cystoisospora | Cystoisospora suis | ||
| 19498120 | 19498120 | PRJNA287283_P_NODE_6316_length_227_cov_1.609195_g6092_i0 | PRJNA287283 | 6316 | 227 | 1.609195 | 3.65287265 | Leiocephalium pseudosanguineum | 2304654 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 4.9799999999999995e-88 | NTclustered | gi|983169665|dbj|LC068840.1| | 2304654 | g6092 | i0 | 93.392 | 100.04845814978 | 227 | 15 | 100 | 0 | 1 | 227 | 2512 | 2738 | Leiocephalium pseudosanguineum genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, strain: it12-10kt | blastn | 22711 | 337 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Suessiaceae | Leiocephalium | Leiocephalium pseudosanguineum | |||
| 19498123 | 19498123 | PRJNA287283_P_NODE_7296_length_202_cov_1.476510_g7072_i0 | PRJNA287283 | 7296 | 202 | 1.47651 | 2.9825502 | Symbiodinium kawagutii | 104179 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.13e-46 | NTclustered | gi|512793196|gb|KC949818.1| | 104179 | g7072 | i0 | 86.592 | 5.45544554455446 | 179 | 24 | 89 | 0 | 17 | 195 | 434 | 256 | Symbiodinium kawagutii strain CCMP2468 clone SymkaFL1061064215408(5'-), partial sequence | blastn | 1102 | 198 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium kawagutii | |||
| 20185233 | 20185233 | PRJNA287283_P_NODE_6116_length_233_cov_1.244444_g5892_i0 | PRJNA287283 | 6116 | 233 | 1.244444 | 2.89955452 | Symbiodiniaceae | 252141 | SAR_Eukaryotes | SAR_Eukaryotes | 198 | 2.5299999999999998e-46 | NTclustered | gi|117937764|gb|EF036594.1| | 2951 | g5892 | i0 | 82.171 | 57.9742489270386 | 258 | 20 | 100 | 17 | 1 | 233 | 1295 | 1039 | Symbiodinium microadriaticum strain CCMP 830 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial | blastn | 13508 | 198 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 22048634 | 22048634 | PRJNA287283_P_NODE_2178_length_449_cov_1.292929_g1955_i0 | PRJNA287283 | 2178 | 449 | 1.292929 | 5.80525121 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 1.08e-82 | NTclustered | gi|309254050|gb|GU553986.1| | 187300 | g1955 | i0 | 81.795 | 47.2271714922049 | 390 | 63 | 86 | 7 | 1 | 386 | 453 | 68 | uncultured dinoflagellate clone AP-cDNA6-4 mRNA sequence | blastn | 21205 | 320 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 23324216 | 23324216 | PRJNA287283_P_NODE_10439_length_175_cov_0.918033_g10215_i0 | PRJNA287283 | 10439 | 175 | 0.918033 | 1.60655775 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 254 | 3.77e-63 | NTclustered | gi|471229096|ref|XM_004035365.1| | 5932 | g10215 | i0 | 93.529 | 0.971428571428571 | 170 | 11 | 97 | 0 | 1 | 170 | 230 | 61 | Ichthyophthirius multifiliis ribosomal phosphoprotein, putative (IMG5_099550) mRNA, complete cds | blastn | 170 | 254 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 23324222 | 23324222 | PRJNA287283_P_NODE_5059_length_267_cov_1.710280_g4835_i0 | PRJNA287283 | 5059 | 267 | 1.71028 | 4.5664476 | Akashiwo sanguinea | 143672 | SAR_Eukaryotes | SAR_Eukaryotes | 178 | 3.86e-40 | NTclustered | gi|311063244|gb|GU295192.1| | 143672 | g4835 | i0 | 79.07 | 3.68539325842697 | 258 | 54 | 97 | 0 | 1 | 258 | 1342 | 1599 | Akashiwo sanguinea heat shock protein 90 gene, partial cds | blastn | 984 | 178 | 1 | Eukaryota | Sar | Dinophyceae | Gymnodiniales | Gymnodiniaceae | Akashiwo | Akashiwo sanguinea |
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);;