contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1073712" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1462185 | 1462185 | PRJNA1073712_P_NODE_8222_length_280_cov_1.304348_g8139_i0 | PRJNA1073712 | 8222 | 280 | 1.304348 | 3.6521744 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.79e-78 | NTclustered | gi|829196136|ref|XM_001025866.3| | 312017 | g8139 | i0 | 87.547 | 0.946428571428571 | 265 | 31 | 94 | 2 | 17 | 280 | 510 | 247 | Tetrahymena thermophila SB210 translationally-controlled tumor-like protein partial mRNA | blastn | 265 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2291519 | 2291519 | PRJNA1073712_P_NODE_14742_length_245_cov_0.895349_g14659_i0 | PRJNA1073712 | 14742 | 245 | 0.895349 | 2.19360505 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 403 | 5.299999999999998e-108 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14659 | i0 | 96.327 | 68.9795918367347 | 245 | 9 | 100 | 0 | 1 | 245 | 214 | 458 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 16900 | 403 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2738179 | 2738179 | PRJNA1073712_P_NODE_16463_length_242_cov_0.911243_g16380_i0 | PRJNA1073712 | 16463 | 242 | 0.911243 | 2.20520806 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 193 | 1.23e-44 | NTclustered | gi|829185314|ref|XM_001031847.2| | 312017 | g16380 | i0 | 92.537 | 0.553719008264463 | 134 | 10 | 55 | 0 | 109 | 242 | 720 | 587 | Tetrahymena thermophila SB210 60S ribosomal protein L7 partial mRNA | blastn | 134 | 193 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 2738229 | 2738229 | PRJNA1073712_P_NODE_8663_length_275_cov_1.386139_g8580_i0 | PRJNA1073712 | 8663 | 275 | 1.386139 | 3.81188225 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 3.97e-45 | NTclustered | gi|657012367|gb|KF302531.1| | 2850 | g8580 | i0 | 83.568 | 24.3563636363636 | 213 | 29 | 76 | 6 | 4 | 213 | 225 | 16 | Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds | blastn | 6698 | 195 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 3566803 | 3566803 | PRJNA1073712_P_NODE_4223_length_351_cov_1.158273_g4140_i0 | PRJNA1073712 | 4223 | 351 | 1.158273 | 4.06553823 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 405 | 2.21e-108 | NTclustered | gi|3861467|emb|AJ012585.1| | 5911 | g4140 | i0 | 88.788 | 5.51851851851852 | 330 | 37 | 94 | 0 | 11 | 340 | 3135 | 2806 | Tetrahymena thermophila macronuclear gene encoding ribosomal protein L3, exons 1-2 | blastn | 1937 | 405 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 4013974 | 4013974 | PRJNA1073712_P_NODE_11544_length_250_cov_2.033898_g11461_i0 | PRJNA1073712 | 11544 | 250 | 2.033898 | 5.084745 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 462 | 8.83e-126 | NTclustered | gi|325195820|emb|FR826611.1| | 890382 | g11461 | i0 | 100 | 21.136 | 250 | 0 | 100 | 0 | 1 | 250 | 278 | 29 | Albugo laibachii Nc14, genomic contig CONTIG_3778_NC14_v4_313_8 | blastn | 5284 | 462 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 6565509 | 6565509 | PRJNA1073712_P_NODE_11006_length_252_cov_1.290503_g10923_i0 | PRJNA1073712 | 11006 | 252 | 1.290503 | 3.25206756 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 6.89e-127 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g10923 | i0 | 100 | 100.043650793651 | 252 | 0 | 100 | 0 | 1 | 252 | 1548 | 1799 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 25211 | 466 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 6565526 | 6565526 | PRJNA1073712_P_NODE_12726_length_248_cov_0.880000_g12643_i0 | PRJNA1073712 | 12726 | 248 | 0.88 | 2.1824 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 2.7e-51 | NTclustered | gi|675199240|ref|XM_008910257.1| | 761204 | g12643 | i0 | 82.661 | 89.8145161290323 | 248 | 37 | 100 | 3 | 1 | 248 | 785 | 1026 | Phytophthora parasitica INRA-310 ATP synthase subunit beta, mitochondrial mRNA | blastn | 22274 | 215 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 6565609 | 6565609 | PRJNA1073712_P_NODE_7566_length_287_cov_1.598131_g7483_i0 | PRJNA1073712 | 7566 | 287 | 1.598131 | 4.58663597 | Paulinella micropora | 1928728 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 3.2e-51 | NTclustered | gi|1389527547|dbj|LC383946.1| | 1928728 | g7483 | i0 | 83.772 | 115.383275261324 | 228 | 35 | 79 | 2 | 27 | 253 | 687 | 913 | Paulinella micropora gene for polyubiquitin, complete cds | blastn | 33115 | 215 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Euglyphida | Paulinellidae | Paulinella | Paulinella micropora | ||
| 7840251 | 7840251 | PRJNA1073712_P_NODE_4187_length_352_cov_1.103943_g4104_i0 | PRJNA1073712 | 4187 | 352 | 1.103943 | 3.88587936 | Aurantiochytrium sp. | 1689870 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 1.5e-20 | NTclustered | gi|1236772359|gb|MF766429.1| | 1689870 | g4104 | i0 | 84.956 | 28.3181818181818 | 113 | 16 | 32 | 1 | 109 | 221 | 1872 | 1983 | Aurantiochytrium sp. strain CCAP_4062/3 large subunit ribosomal RNA gene, partial sequence | blastn | 9968 | 113 | 1 | Eukaryota | Sar | Bigyra | Thraustochytrida | Thraustochytriidae | Aurantiochytrium | Aurantiochytrium sp. | |||
| 8669413 | 8669413 | PRJNA1073712_P_NODE_6147_length_309_cov_1.889831_g6064_i0 | PRJNA1073712 | 6147 | 309 | 1.889831 | 5.83957779 | Caryotricha | 500583 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 4.53e-45 | NTclustered | gi|759083508|gb|KM222125.1| | 1004043 | g6064 | i0 | 94.444 | 41.0453074433657 | 126 | 7 | 41 | 0 | 175 | 300 | 1281 | 1156 | Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence | blastn | 12683 | 195 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Kiitrichida | Kiitrichidae | Caryotricha | Caryotricha minuta | ||
| 9944337 | 9944337 | PRJNA1073712_P_NODE_13728_length_246_cov_1.554913_g13645_i0 | PRJNA1073712 | 13728 | 246 | 1.554913 | 3.82508598 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 1.54e-78 | NTclustered | gi|315570322|tpg|BK007923.1| | 5911 | g13645 | i0 | 89.024 | 2.99593495934959 | 246 | 27 | 100 | 0 | 1 | 246 | 183 | 428 | TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS16e mRNA, complete cds | blastn | 737 | 305 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11666264 | 11666264 | PRJNA1073712_P_NODE_17030_length_241_cov_0.916667_g16947_i0 | PRJNA1073712 | 17030 | 241 | 0.916667 | 2.20916747 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 211 | 3.38e-50 | NTclustered | gi|229594318|ref|XM_001030083.3| | 312017 | g16947 | i0 | 84.404 | 0.904564315352697 | 218 | 31 | 90 | 3 | 4 | 219 | 217 | 1 | Tetrahymena thermophila SB210 40S ribosomal protein S3 partial mRNA | blastn | 218 | 211 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12941326 | 12941326 | PRJNA1073712_P_NODE_13811_length_246_cov_0.890173_g13728_i0 | PRJNA1073712 | 13811 | 246 | 0.890173 | 2.18982558 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 348 | 2.53e-91 | NTclustered | gi|829153590|ref|XM_001010934.3| | 312017 | g13728 | i0 | 92.245 | 0.995934959349594 | 245 | 19 | 99 | 0 | 1 | 245 | 263 | 19 | Tetrahymena thermophila SB210 transcription factor BTF3a partial mRNA | blastn | 245 | 348 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 12941369 | 12941369 | PRJNA1073712_P_NODE_2611_length_412_cov_212.566372_g2528_i0 | PRJNA1073712 | 2611 | 412 | 212.566372 | 875.77345264 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 5.96e-75 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g2528 | i0 | 93.5 | 49.3131067961165 | 200 | 10 | 48 | 3 | 1 | 197 | 3656 | 3855 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20317 | 294 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14216333 | 14216333 | PRJNA1073712_P_NODE_8152_length_281_cov_1.062500_g8069_i0 | PRJNA1073712 | 8152 | 281 | 1.0625 | 2.985625 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|1270517201|ref|XM_720130.2| | 5861 | g8069 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 114 | 141 | 339 | 312 | Plasmodium yoelii conserved Plasmodium protein, unknown function (PY17X_0107800), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 15490138 | 15490138 | PRJNA1073712_P_NODE_1053_length_577_cov_2.607143_g970_i0 | PRJNA1073712 | 1053 | 577 | 2.607143 | 15.04321511 | Lecythium sp. 3678_261K | 238773 | SAR_Eukaryotes | SAR_Eukaryotes | 784 | 0 | NTclustered | gi|33089893|gb|AY283756.1| | 238773 | g970 | i0 | 92.086 | 97.7625649913345 | 556 | 44 | 96 | 0 | 22 | 577 | 765 | 210 | Lecythium sp. 3678_261K actin gene, partial cds | blastn | 56409 | 784 | 1 | Eukaryota | Sar | Cercozoa | Thecofilosea | Tectofilosida | Chlamydophryidae | Lecythium | Lecythium sp. 3678_261K | ||
| 18039312 | 18039312 | PRJNA1073712_P_NODE_635_length_712_cov_1.926448_g558_i0 | PRJNA1073712 | 635 | 712 | 1.926448 | 13.71630976 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 1155 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g558 | i0 | 99.219 | 91.6685393258427 | 640 | 5 | 90 | 0 | 1 | 640 | 644 | 5 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 65268 | 1155 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 18039323 | 18039323 | PRJNA1073712_P_NODE_7615_length_287_cov_1.014019_g7532_i0 | PRJNA1073712 | 7615 | 287 | 1.014019 | 2.91023453 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 270 | 6.7299999999999984e-68 | NTclustered | gi|829194699|ref|XM_001025224.3| | 312017 | g7532 | i0 | 84.962 | 0.926829268292683 | 266 | 40 | 93 | 0 | 15 | 280 | 1 | 266 | Tetrahymena thermophila SB210 S25 ribosomal protein partial mRNA | blastn | 266 | 270 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 18039332 | 18039332 | PRJNA1073712_P_NODE_9355_length_268_cov_1.553846_g9272_i0 | PRJNA1073712 | 9355 | 268 | 1.553846 | 4.16430728 | Aphanomyces invadans | 157072 | SAR_Eukaryotes | SAR_Eukaryotes | 228 | 3.8e-55 | NTclustered | gi|673016107|ref|XM_008863793.1| | 157072 | g9272 | i0 | 82.593 | 8.63805970149254 | 270 | 35 | 96 | 6 | 1 | 258 | 340 | 71 | Aphanomyces invadans hypothetical protein partial mRNA | blastn | 2315 | 228 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces invadans | ||
| 19313276 | 19313276 | PRJNA1073712_P_NODE_12836_length_248_cov_0.880000_g12753_i0 | PRJNA1073712 | 12836 | 248 | 0.88 | 2.1824 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 259 | 1.23e-64 | NTclustered | gi|118385632|ref|XM_001025944.1| | 312017 | g12753 | i0 | 85.484 | 1 | 248 | 36 | 100 | 0 | 1 | 248 | 666 | 419 | Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA | blastn | 248 | 259 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 24413452 | 24413452 | PRJNA1073712_P_NODE_11220_length_251_cov_0.865169_g11137_i0 | PRJNA1073712 | 11220 | 251 | 0.865169 | 2.17157419 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 2.6100000000000006e-86 | NTclustered | gi|829164593|ref|XM_972055.3| | 312017 | g11137 | i0 | 90.438 | 1 | 251 | 24 | 100 | 0 | 1 | 251 | 2131 | 2381 | Tetrahymena thermophila SB210 cytoplasmic-like aconitate hydratase partial mRNA | blastn | 251 | 331 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila |
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);;