contig_metadata
25 rows where bioproject = "PRJNA719595" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4537816 | 4537816 | PRJNA719595_P_NODE_5384_length_276_cov_1.536946_g5349_i0 | PRJNA719595 | 5384 | 276 | 1.536946 | 4.24197096 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 127 | 9.369999999999999e-35 | NR | KAJ1436092.1 | 483371 | g5349 | i0 | 85.4 | 0.891304347826087 | 82 | 12 | 89.1 | 0 | 274 | 29 | 88 | 169 | KAJ1436092.1 ribosomal protein L19/L19e domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 246 | 127 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 9637930 | 9637930 | PRJNA719595_P_NODE_5868_length_264_cov_1.225131_g5833_i0 | PRJNA719595 | 5868 | 264 | 1.225131 | 3.23434584 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 1.5499999999999999e-133 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g5833 | i0 | 100 | 17.5568181818182 | 264 | 0 | 100 | 0 | 1 | 264 | 342 | 605 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 4635 | 488 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 10913457 | 10913457 | PRJNA719595_P_NODE_6409_length_253_cov_0.866667_g6374_i0 | PRJNA719595 | 6409 | 253 | 0.866667 | 2.19266751 | Oomycota | 4762 | SAR_Eukaryotes | SAR_Eukaryotes | 143 | 2.1399999999999996e-37 | NR | DBA03560.1 | 4803 | g6374 | i0 | 84.5 | 36.8656126482213 | 84 | 13 | 99.6 | 0 | 2 | 253 | 512 | 595 | DBA03560.1 TPA: hypothetical protein N0F65_011461 [Lagenidium giganteum] | diamond | 9327 | 143 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 10913507 | 10913507 | PRJNA719595_P_NODE_8669_length_245_cov_0.906977_g8634_i0 | PRJNA719595 | 8669 | 245 | 0.906977 | 2.22209365 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 1.57e-63 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g8634 | i0 | 98.611 | 21.6489795918367 | 144 | 2 | 59 | 0 | 102 | 245 | 1238 | 1095 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 5304 | 255 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 17287475 | 17287475 | PRJNA719595_P_NODE_6254_length_256_cov_1.092896_g6219_i0 | PRJNA719595 | 6254 | 256 | 1.092896 | 2.79781376 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 230 | 1e-55 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6219 | i0 | 83.142 | 35.3046875 | 261 | 34 | 100 | 10 | 1 | 256 | 3730 | 3985 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 9038 | 230 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 18561270 | 18561270 | PRJNA719595_P_NODE_5255_length_279_cov_2.150485_g5220_i0 | PRJNA719595 | 5255 | 279 | 2.150485 | 5.99985315 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 138 | 1.88e-39 | NR | XP_004040146.1 | 5932 | g5220 | i0 | 79.7 | 2.55913978494624 | 79 | 16 | 84.9 | 0 | 238 | 2 | 2 | 80 | XP_004040146.1 hypothetical protein IMG5_000700 [Ichthyophthirius multifiliis] | diamond | 714 | 138 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 26767187 | 26767187 | PRJNA719595_P_NODE_9181_length_243_cov_0.917647_g9146_i0 | PRJNA719595 | 9181 | 243 | 0.917647 | 2.22988221 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 68.2 | 4.04e-11 | NR | XP_004029934.1 | 5932 | g9146 | i0 | 46.1 | 1.76543209876543 | 76 | 32 | 84 | 2 | 40 | 243 | 1 | 75 | XP_004029934.1 hypothetical protein IMG5_169980 [Ichthyophthirius multifiliis] | diamond | 429 | 68.2 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 26956959 | 26956959 | PRJNA719595_P_NODE_8542_length_246_cov_0.901734_g8507_i0 | PRJNA719595 | 8542 | 246 | 0.901734 | 2.21826564 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.59e-18 | NR | XP_001019311.2 | 312017 | g8507 | i0 | 57.5 | 0.890243902439024 | 73 | 29 | 89 | 1 | 1 | 219 | 937 | 1007 | XP_001019311.2 calcium-translocating P-type ATPase, PMCA-type protein [Tetrahymena thermophila SB210] | diamond | 219 | 89.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 27178276 | 27178276 | PRJNA719595_P_NODE_5082_length_284_cov_1.023697_g5047_i0 | PRJNA719595 | 5082 | 284 | 1.023697 | 2.90729948 | Cyclospora cayetanensis | 88456 | SAR_Eukaryotes | SAR_Eukaryotes | 67.8 | 5.78e-11 | NR | XP_022589176.1 | 88456 | g5047 | i0 | 52.3 | 2.72535211267606 | 65 | 31 | 68.7 | 0 | 5 | 199 | 227 | 291 | XP_022589176.1 60S ribosomal protein L7a [Cyclospora cayetanensis] | diamond | 774 | 67.8 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Cyclospora | Cyclospora cayetanensis | ||
| 28851914 | 28851914 | PRJNA719595_P_NODE_8628_length_245_cov_0.906977_g8593_i0 | PRJNA719595 | 8628 | 245 | 0.906977 | 2.22209365 | Symbiodinium sp. KB8 | 230985 | SAR_Eukaryotes | SAR_Eukaryotes | 90.5 | 5.65e-19 | NR | CAE7694817.1 | 230985 | g8593 | i0 | 56.3 | 0.979591836734694 | 80 | 35 | 98 | 0 | 244 | 5 | 250 | 329 | CAE7694817.1 unnamed protein product, partial [Symbiodinium sp. KB8] | diamond | 240 | 90.5 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. KB8 | |||
| 29010382 | 29010382 | PRJNA719595_P_NODE_8748_length_245_cov_0.906977_g8713_i0 | PRJNA719595 | 8748 | 245 | 0.906977 | 2.22209365 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 75.5 | 9.83e-14 | NR | XP_004030152.1 | 5932 | g8713 | i0 | 55.9 | 3.44081632653061 | 68 | 28 | 83.3 | 1 | 234 | 31 | 27 | 92 | XP_004030152.1 serine carboxypeptidase family protein, putative [Ichthyophthirius multifiliis] | diamond | 843 | 75.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 29672704 | 29672704 | PRJNA719595_P_NODE_7850_length_248_cov_0.891429_g7815_i0 | PRJNA719595 | 7850 | 248 | 0.891429 | 2.21074392 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 2.69e-28 | NR | KAJ0398756.1 | 114742 | g7815 | i0 | 69.5 | 2.9758064516129 | 82 | 25 | 99.2 | 0 | 247 | 2 | 104 | 185 | KAJ0398756.1 hypothetical protein P43SY_009824 [Pythium insidiosum] | diamond | 738 | 113 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 29830851 | 29830851 | PRJNA719595_P_NODE_6551_length_253_cov_0.866667_g6516_i0 | PRJNA719595 | 6551 | 253 | 0.866667 | 2.19266751 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 102 | 5.75e-23 | NR | XP_001030011.1 | 312017 | g6516 | i0 | 53 | 0.984189723320158 | 83 | 39 | 98.4 | 0 | 5 | 253 | 351 | 433 | XP_001030011.1 cation channel family protein [Tetrahymena thermophila SB210] | diamond | 249 | 102 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 29862476 | 29862476 | PRJNA719595_P_NODE_8631_length_245_cov_0.906977_g8596_i0 | PRJNA719595 | 8631 | 245 | 0.906977 | 2.22209365 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 84.7 | 5.86e-17 | NR | CAK9058267.1 | 1381693 | g8596 | i0 | 50.6 | 1.98367346938776 | 81 | 39 | 99.2 | 1 | 244 | 2 | 157 | 236 | CAK9058267.1 unnamed protein product [Durusdinium trenchii] | diamond | 486 | 84.7 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 29988901 | 29988901 | PRJNA719595_P_NODE_7551_length_249_cov_0.886364_g7516_i0 | PRJNA719595 | 7551 | 249 | 0.886364 | 2.20704636 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 104 | 9.6e-25 | NR | KRX09446.1 | 266149 | g7516 | i0 | 58.8 | 0.963855421686747 | 80 | 33 | 96.4 | 0 | 3 | 242 | 103 | 182 | KRX09446.1 hypothetical protein PPERSA_00725 [Pseudocohnilembus persalinus] | diamond | 240 | 104 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 30715470 | 30715470 | PRJNA719595_P_NODE_7134_length_251_cov_0.876404_g7099_i0 | PRJNA719595 | 7134 | 251 | 0.876404 | 2.19977404 | Tetrahymena thermophila SB21 | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 89.4 | 1.62e-18 | NR | XP_001007813.2 | 312017 | g7099 | i0 | 50 | 0.932270916334661 | 78 | 39 | 93.2 | 0 | 249 | 16 | 366 | 443 | XP_001007813.2 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] | diamond | 234 | 89.4 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 30810324 | 30810324 | PRJNA719595_P_NODE_4374_length_302_cov_1.703057_g4339_i0 | PRJNA719595 | 4374 | 302 | 1.703057 | 5.14323214 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 103 | 3e-25 | NR | KRX05597.1 | 266149 | g4339 | i0 | 54.5 | 1.00331125827815 | 101 | 42 | 99.3 | 2 | 302 | 3 | 1 | 98 | KRX05597.1 Ribosomal protein L6, alpha-beta domain [Pseudocohnilembus persalinus] | diamond | 303 | 103 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 31569277 | 31569277 | PRJNA719595_P_NODE_6956_length_251_cov_0.876404_g6921_i0 | PRJNA719595 | 6956 | 251 | 0.876404 | 2.19977404 | Paramecium octaurelia | 43137 | SAR_Eukaryotes | SAR_Eukaryotes | 118 | 1.28e-29 | NR | CAD8164998.1 | 43137 | g6921 | i0 | 68.8 | 2.86852589641434 | 80 | 25 | 95.6 | 0 | 242 | 3 | 12 | 91 | CAD8164998.1 unnamed protein product [Paramecium octaurelia] | diamond | 720 | 118 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium octaurelia | ||
| 31632201 | 31632201 | PRJNA719595_P_NODE_7476_length_249_cov_0.886364_g7441_i0 | PRJNA719595 | 7476 | 249 | 0.886364 | 2.20704636 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 49.3 | 1.86e-4 | NR | KAJ1437268.1 | 483371 | g7441 | i0 | 37.5 | 0.867469879518072 | 72 | 37 | 86.7 | 3 | 14 | 229 | 80 | 143 | KAJ1437268.1 WD40-repeat-containing domain protein [Ochromonadaceae sp. CCMP2298] | diamond | 216 | 49.3 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31695528 | 31695528 | PRJNA719595_P_NODE_7057_length_251_cov_0.876404_g7022_i0 | PRJNA719595 | 7057 | 251 | 0.876404 | 2.19977404 | Durusdinium trenchii | 1381693 | SAR_Eukaryotes | SAR_Eukaryotes | 123 | 9.14e-31 | NR | CAK9002984.1 | 1381693 | g7022 | i0 | 69.6 | 0.944223107569721 | 79 | 24 | 94.4 | 0 | 13 | 249 | 188 | 266 | CAK9002984.1 Pyruvate dehydrogenase E1 component subunit alpha-1 [Durusdinium trenchii] | diamond | 237 | 123 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Durusdinium | Durusdinium trenchii | |||
| 31980153 | 31980153 | PRJNA719595_P_NODE_6818_length_252_cov_0.871508_g6783_i0 | PRJNA719595 | 6818 | 252 | 0.871508 | 2.19620016 | Triparma columacea | 722753 | SAR_Eukaryotes | SAR_Eukaryotes | 59.3 | 6.14e-8 | NR | GMI38457.1 | 722753 | g6783 | i0 | 36.5 | 2.01190476190476 | 85 | 48 | 95.2 | 2 | 241 | 2 | 269 | 352 | GMI38457.1 hypothetical protein TrCOL_g1151 [Triparma columacea] | diamond | 507 | 59.3 | 1 | Eukaryota | Sar | Bolidophyceae | Parmales | Triparmaceae | Triparma | Triparma columacea | |||
| 31980154 | 31980154 | PRJNA719595_P_NODE_7418_length_250_cov_0.881356_g7383_i0 | PRJNA719595 | 7418 | 250 | 0.881356 | 2.20339 | Seminavis robusta | 568900 | SAR_Eukaryotes | SAR_Eukaryotes | 92.4 | 1.36e-19 | NR | CAB9516977.1 | 568900 | g7383 | i0 | 53.6 | 1.008 | 84 | 38 | 99.6 | 1 | 249 | 1 | 7 | 90 | CAB9516977.1 Protein SMG7 [Seminavis robusta] | diamond | 252 | 92.4 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculaceae | Seminavis | Seminavis robusta | ||
| 32612823 | 32612823 | PRJNA719595_P_NODE_9120_length_243_cov_0.917647_g9085_i0 | PRJNA719595 | 9120 | 243 | 0.917647 | 2.22988221 | Pythium insidiosum | 114742 | SAR_Eukaryotes | SAR_Eukaryotes | 45.4 | 0.00443 | NR | GLD91835.1 | 114742 | g9085 | i0 | 37.3 | 1.45679012345679 | 59 | 37 | 72.8 | 0 | 34 | 210 | 1143 | 1201 | GLD91835.1 hypothetical protein PINS_up000368 [Pythium insidiosum] | diamond | 354 | 45.4 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Pythium | Pythium insidiosum | ||
| 32675625 | 32675625 | PRJNA719595_P_NODE_7060_length_251_cov_0.876404_g7025_i0 | PRJNA719595 | 7060 | 251 | 0.876404 | 2.19977404 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 117 | 1.39e-28 | NR | CEO97960.1 | 37360 | g7025 | i0 | 68.7 | 0.99203187250996006 | 83 | 26 | 99.2 | 0 | 249 | 1 | 30 | 112 | CEO97960.1 hypothetical protein PBRA_006074 [Plasmodiophora brassicae] | diamond | 249 | 117 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 32833226 | 32833226 | PRJNA719595_P_NODE_9300_length_242_cov_0.923077_g9265_i0 | PRJNA719595 | 9300 | 242 | 0.923077 | 2.23384634 | Stylonychia lemnae | 5949 | SAR_Eukaryotes | SAR_Eukaryotes | 65.1 | 4.94e-10 | NR | CDW89939.1 | 5949 | g9265 | i0 | 39.2 | 0.979338842975207 | 79 | 36 | 97.9 | 1 | 237 | 1 | 403 | 469 | CDW89939.1 transducin beta-like protein 3 [Stylonychia lemnae] | diamond | 237 | 65.1 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Stylonychia | Stylonychia lemnae |
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);;