contig_metadata
21 rows where bioproject = "PRJNA1195551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 322643 | 322643 | PRJNA1195551_S_NODE_9001_length_306_cov_4.365759_g8648_i0 | PRJNA1195551 | 9001 | 306 | 4.365759 | 13.35922254 | uncultured dinoflagellate | 187300 | SAR_Eukaryotes | SAR_Eukaryotes | 137 | 7.6599999999999985e-28 | NTclustered | gi|309255118|gb|GU555054.1| | 187300 | g8648 | i0 | 85.075 | 12.016339869281 | 134 | 20 | 44 | 0 | 173 | 306 | 306 | 173 | uncultured dinoflagellate clone ML1_1061048824671 mRNA sequence | blastn | 3677 | 137 | 1 | Eukaryota | Sar | Dinophyceae | uncultured dinoflagellate | ||||||
| 1597236 | 1597236 | PRJNA1195551_S_NODE_5582_length_367_cov_6.220126_g5229_i0 | PRJNA1195551 | 5582 | 367 | 6.220126 | 22.82786242 | Perkinsus | 28000 | SAR_Eukaryotes | SAR_Eukaryotes | 136 | 6.209999999999999e-37 | NR | KAF4656891.1 | 330153 | g5229 | i0 | 77.1 | 12.1634877384196 | 83 | 19 | 67.8 | 0 | 6 | 254 | 191 | 273 | KAF4656891.1 hypothetical protein FOL47_008703, partial [Perkinsus chesapeaki] | diamond | 4464 | 137 | 0.992700729927007 | Eukaryota | Sar | Perkinsozoa | Perkinsida | Perkinsidae | Perkinsus | Perkinsus chesapeaki | |||
| 6700427 | 6700427 | PRJNA1195551_S_NODE_17526_length_237_cov_1.106383_g17173_i0 | PRJNA1195551 | 17526 | 237 | 1.106383 | 2.62212771 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 82.4 | 2.71e-11 | NTclustered | gi|695429697|ref|XM_009531962.1| | 67593 | g17173 | i0 | 89.231 | 19.4556962025316 | 65 | 7 | 27 | 0 | 2 | 66 | 242 | 306 | Phytophthora sojae hypothetical protein mRNA | blastn | 4611 | 82.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 7975931 | 7975931 | PRJNA1195551_S_NODE_26947_length_195_cov_1.424658_g26594_i0 | PRJNA1195551 | 26947 | 195 | 1.424658 | 2.7780831 | Spumella sinechrysos | 2849684 | SAR_Eukaryotes | SAR_Eukaryotes | 361 | 2.46e-95 | NTclustered | gi|2055919754|gb|MZ420312.1| | 2849684 | g26594 | i0 | 100 | 99.1589743589744 | 195 | 0 | 100 | 0 | 1 | 195 | 220 | 26 | Spumella sinechrysos strain Hwarim032418A7 large subunit ribosomal RNA gene, partial sequence | blastn | 19336 | 361 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella | Spumella sinechrysos | |||
| 9250458 | 9250458 | PRJNA1195551_S_NODE_20928_length_219_cov_2.141176_g20575_i0 | PRJNA1195551 | 20928 | 219 | 2.141176 | 4.68917544 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 97.4 | 1.09e-22 | NR | KAL3796718.1 | 29204 | g20575 | i0 | 71.9 | 121.561643835616 | 64 | 18 | 87.7 | 0 | 219 | 28 | 198 | 261 | KAL3796718.1 hypothetical protein HJC23_010018 [Cyclotella cryptica] | diamond | 26622 | 98.2 | 0.991853360488798 | Eukaryota | Sar | Bacillariophyta | Coscinodiscophyceae | Stephanodiscales | Stephanodiscaceae | Cyclotella | Cyclotella cryptica | ||
| 11801076 | 11801076 | PRJNA1195551_S_NODE_20950_length_219_cov_1.788235_g20597_i0 | PRJNA1195551 | 20950 | 219 | 1.788235 | 3.91623465 | Eimeria maxima | 5804 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|915147194|ref|XM_013483103.1| | 5804 | g20597 | i0 | 96.875 | 0.785388127853881 | 32 | 1 | 15 | 0 | 95 | 126 | 3242 | 3211 | Eimeria maxima hypothetical protein, conserved partial mRNA | blastn | 172 | 54.7 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria maxima | ||
| 15625368 | 15625368 | PRJNA1195551_S_NODE_29313_length_187_cov_2.630435_g28960_i0 | PRJNA1195551 | 29313 | 187 | 2.630435 | 4.91891345 | Wobblia lunata | 104657 | SAR_Eukaryotes | SAR_Eukaryotes | 257 | 3.1600000000000004e-64 | NTclustered | gi|2163288121|gb|MZ440312.1| | 104657 | g28960 | i0 | 91.444 | 99.3262032085562 | 187 | 16 | 100 | 0 | 1 | 187 | 1081 | 1267 | Wobblia lunata strain NIES-1015 alpha-tubulin mRNA, complete cds | blastn | 18574 | 257 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidiaceae | Wobblia | Wobblia lunata | |||
| 15625369 | 15625369 | PRJNA1195551_S_NODE_29373_length_187_cov_1.702899_g29020_i0 | PRJNA1195551 | 29373 | 187 | 1.702899 | 3.18442113 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 6.79e-66 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g29020 | i0 | 91.979 | 51.1604278074866 | 187 | 15 | 100 | 0 | 1 | 187 | 213 | 27 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 9567 | 263 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 17620873 | 17620873 | PRJNA1195551_S_NODE_32634_length_178_cov_1.581395_g32281_i0 | PRJNA1195551 | 32634 | 178 | 1.581395 | 2.8148831 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 6.21e-86 | NTclustered | gi|2065561668|gb|MZ540265.1| | 44029 | g32281 | i0 | 100 | 100 | 178 | 0 | 100 | 0 | 1 | 178 | 893 | 716 | Paramecium jenningsi isolate UR02 small subunit ribosomal RNA gene, partial sequence | blastn | 17800 | 329 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium jenningsi | ||
| 19448638 | 19448638 | PRJNA1195551_S_NODE_31916_length_180_cov_0.969466_g31563_i0 | PRJNA1195551 | 31916 | 180 | 0.969466 | 1.7450388 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.015 | NTclustered | gi|145528242|ref|XM_001449884.1| | 5888 | g31563 | i0 | 100 | 0.155555555555556 | 28 | 0 | 16 | 0 | 135 | 162 | 274 | 301 | Paramecium tetraurelia uncharacterized protein (GSPATT00016911001), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 25269239 | 25269239 | PRJNA1195551_S_NODE_12640_length_270_cov_5.760181_g12287_i0 | PRJNA1195551 | 12640 | 270 | 5.760181 | 15.5524887 | root | 1 | Root_unresolved | Root_unresolved | 130 | 1.11e-25 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g12287 | i0 | 88.182 | 16.4518518518519 | 110 | 12 | 40 | 1 | 1 | 109 | 2454 | 2345 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 4442 | 130 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 26679763 | 26679763 | PRJNA1195551_S_NODE_14921_length_253_cov_4.720588_g14568_i0 | PRJNA1195551 | 14921 | 253 | 4.720588 | 11.94308764 | Symbiodiniaceae | 252141 | SAR_Eukaryotes | SAR_Eukaryotes | 85.5 | 1.45e-19 | NR | CAE7595067.1 | 1519616 | g14568 | i0 | 59 | 11.098814229249 | 78 | 29 | 92.5 | 1 | 250 | 17 | 13 | 87 | CAE7595067.1 RPL31 [Symbiodinium sp. CCMP2456] | diamond | 2808 | 85.5 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. CCMP2456 | |||
| 26977530 | 26977530 | PRJNA1195551_S_NODE_38742_length_165_cov_2.241379_g38389_i0 | PRJNA1195551 | 38742 | 165 | 2.241379 | 3.69827535 | Pelagophyceae sp. CCMP2 | 1982007 | SAR_Eukaryotes | SAR_Eukaryotes | 82 | 1.84e-16 | NR | KAJ1456784.1 | 483370 | g38389 | i0 | 73.6 | 1.89090909090909 | 53 | 14 | 96.4 | 0 | 165 | 7 | 456 | 508 | KAJ1456784.1 Aldehyde/histidinol dehydrogenase [Pelagophyceae sp. CCMP2097] | diamond | 312 | 82 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagophyceae sp. CCMP2097 | ||||||
| 27609618 | 27609618 | PRJNA1195551_S_NODE_24504_length_204_cov_1.006452_g24151_i0 | PRJNA1195551 | 24504 | 204 | 1.006452 | 2.05316208 | Blastocystis sp. subtype 4 | 944170 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0414 | NR | XP_014525269.1 | 944170 | g24151 | i0 | 38.3 | 0.691176470588235 | 47 | 29 | 69.1 | 0 | 44 | 184 | 365 | 411 | XP_014525269.1 hypothetical protein JH06_4687 [Blastocystis sp. subtype 4] | diamond | 141 | 42 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. subtype 4 | |||
| 27767630 | 27767630 | PRJNA1195551_S_NODE_6064_length_354_cov_5.016393_g5711_i0 | PRJNA1195551 | 6064 | 354 | 5.016393 | 17.75803122 | Pelagophyceae sp. CCMP2 | 1982007 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 8.5e-25 | NR | KAJ1462677.1 | 483370 | g5711 | i0 | 53.5 | 0.728813559322034 | 86 | 40 | 72.9 | 0 | 350 | 93 | 458 | 543 | KAJ1462677.1 peptidase S8/S53 domain-containing protein [Pelagophyceae sp. CCMP2097] | diamond | 258 | 108 | 1 | Eukaryota | Sar | Pelagophyceae | Pelagophyceae sp. CCMP2097 | ||||||
| 27862031 | 27862031 | PRJNA1195551_S_NODE_37685_length_167_cov_1.322034_g37332_i0 | PRJNA1195551 | 37685 | 167 | 1.322034 | 2.20779678 | Eimeria acervulina | 5801 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 4.71e-9 | NR | XP_013246568.1 | 5801 | g37332 | i0 | 54.7 | 1.90419161676647 | 53 | 24 | 95.2 | 0 | 7 | 165 | 255 | 307 | XP_013246568.1 prohibitin, putative [Eimeria acervulina] | diamond | 318 | 60.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria acervulina | ||
| 28398903 | 28398903 | PRJNA1195551_S_NODE_37666_length_167_cov_1.533898_g37313_i0 | PRJNA1195551 | 37666 | 167 | 1.533898 | 2.56160966 | Globisporangium splendens | 82926 | SAR_Eukaryotes | SAR_Eukaryotes | 42 | 0.0255 | NR | KAF1331135.1 | 82926 | g37313 | i0 | 39.6 | 0.952095808383233 | 53 | 31 | 93.4 | 1 | 166 | 11 | 151 | 203 | KAF1331135.1 hypothetical protein FI667_g4463, partial [Globisporangium splendens] | diamond | 159 | 42 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium splendens | ||
| 28481028 | 28481028 | PRJNA1195551_S_NODE_29086_length_188_cov_1.496403_g28733_i0 | PRJNA1195551 | 29086 | 188 | 1.496403 | 2.81323764 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 47.8 | 4.01e-5 | NR | KAJ8556926.1 | 4785 | g28733 | i0 | 45.9 | 4.86702127659574 | 61 | 27 | 97.3 | 1 | 184 | 2 | 21 | 75 | KAJ8556926.1 hypothetical protein ON010_g9042 [Phytophthora cinnamomi] | diamond | 915 | 47.8 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 30262295 | 30262295 | PRJNA1195551_S_NODE_37812_length_167_cov_0.881356_g37459_i0 | PRJNA1195551 | 37812 | 167 | 0.881356 | 1.47186452 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 56.6 | 1.66e-7 | NR | XP_001016313.1 | 312017 | g37459 | i0 | 42.9 | 1.0059880239521 | 56 | 31 | 98.8 | 1 | 166 | 2 | 316 | 371 | XP_001016313.1 eukaryotic aspartyl protease [Tetrahymena thermophila SB210] | diamond | 168 | 56.6 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 31260536 | 31260536 | PRJNA1195551_S_NODE_17455_length_237_cov_3.808511_g17102_i0 | PRJNA1195551 | 17455 | 237 | 3.808511 | 9.02617107 | Bacillariaceae | 33852 | SAR_Eukaryotes | SAR_Eukaryotes | 112 | 1.41e-27 | NR | CAJ1937478.1 | 2856 | g17102 | i0 | 69.7 | 1.92405063291139 | 76 | 23 | 96.2 | 0 | 9 | 236 | 246 | 321 | CAJ1937478.1 unnamed protein product [Cylindrotheca closterium] | diamond | 456 | 112 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Cylindrotheca | Cylindrotheca closterium | ||
| 31893051 | 31893051 | PRJNA1195551_S_NODE_35097_length_172_cov_1.878049_g34744_i0 | PRJNA1195551 | 35097 | 172 | 1.878049 | 3.23024428 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 61.6 | 3.13e-9 | NR | RHY33897.1 | 157072 | g34744 | i0 | 65.2 | 4.95348837209302 | 46 | 16 | 80.2 | 0 | 142 | 5 | 502 | 547 | RHY33897.1 hypothetical protein DYB32_003863, partial [Aphanomyces invadans] | diamond | 852 | 61.6 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans |
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);;