contig_metadata
22 rows where analysis = "blastn", bioproject = "PRJNA1156092" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2853890 | 2853890 | PRJNA1156092_P_NODE_2963_length_578_cov_1.364356_g2835_i0 | PRJNA1156092 | 2963 | 578 | 1.364356 | 7.88597768 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 979 | 0 | NTclustered | gi|1389430805|gb|MH341633.1| | 1938391 | g2835 | i0 | 97.232 | 61.2474048442907 | 578 | 16 | 100 | 0 | 1 | 578 | 2328 | 1751 | Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence | blastn | 35401 | 979 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 3587576 | 3587576 | PRJNA1156092_P_NODE_14963_length_300_cov_1.348018_g14833_i0 | PRJNA1156092 | 14963 | 300 | 1.348018 | 4.044054 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 555 | 1.7399999999999995e-153 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g14833 | i0 | 100 | 97.6733333333333 | 300 | 0 | 100 | 0 | 1 | 300 | 954 | 1253 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 29302 | 555 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 3587739 | 3587739 | PRJNA1156092_P_NODE_383_length_1324_cov_3.382094_g322_i0 | PRJNA1156092 | 383 | 1324 | 3.382094 | 44.77892456 | Blastocystis | 12967 | SAR_Eukaryotes | SAR_Eukaryotes | 248 | 1.61e-60 | NTclustered | gi|156617365|gb|EF494738.1| | 463135 | g322 | i0 | 76.827 | 35.4010574018127 | 479 | 87 | 35 | 18 | 559 | 1023 | 4252 | 3784 | Blastocystis sp. BT-1 tRNA-Asn, tRNA-Leu, tRNA-Met, and tRNA-Asp genes, complete sequence; NADH dehydrogenase subunit 3 (nad3) gene, complete cds; tRNA-Met and tRNA-Pro genes, complete sequence; NADH dehydrogenase subunit 6 (nad6) gene, complete cds; small subunit ribosomal RNA and tRNA-Met genes, complete sequence; and large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 46871 | 248 | 1 | Eukaryota | Sar | Bigyra | Opalinata | Blastocystidae | Blastocystis | Blastocystis sp. BT-1 | |||
| 4129922 | 4129922 | PRJNA1156092_P_NODE_6684_length_412_cov_1.451327_g6554_i0 | PRJNA1156092 | 6684 | 412 | 1.451327 | 5.97946724 | Aphanomyces astaci | 112090 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 4.7700000000000003e-51 | NTclustered | gi|698791735|ref|XM_009830598.1| | 112090 | g6554 | i0 | 80.333 | 18.3859223300971 | 300 | 46 | 71 | 11 | 1 | 292 | 462 | 168 | Aphanomyces astaci malate dehydrogenase, NAD-dependent mRNA | blastn | 7575 | 215 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces astaci | ||
| 5405711 | 5405711 | PRJNA1156092_P_NODE_13265_length_315_cov_1.892562_g13135_i0 | PRJNA1156092 | 13265 | 315 | 1.892562 | 5.9615703 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 527 | 4.02e-145 | NTclustered | gi|300676719|gb|GQ377693.1| | 151077 | g13135 | i0 | 96.825 | 86.615873015873 | 315 | 10 | 100 | 0 | 1 | 315 | 355 | 41 | Chilodonella uncinata gcr5-like mRNA, partial sequence | blastn | 27284 | 527 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 5406054 | 5406054 | PRJNA1156092_P_NODE_4925_length_465_cov_1.137755_g4796_i0 | PRJNA1156092 | 4925 | 465 | 1.137755 | 5.29056075 | Colpoda sp. | 41631 | SAR_Eukaryotes | SAR_Eukaryotes | 664 | 0 | NTclustered | gi|3341414|emb|X94349.1| | 41631 | g4796 | i0 | 92.473 | 98.447311827957 | 465 | 33 | 99 | 2 | 2 | 465 | 550 | 1013 | Colpoda sp. gene encoding for beta-tubulin, partial | blastn | 45778 | 664 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda sp. | ||
| 6680499 | 6680499 | PRJNA1156092_P_NODE_13246_length_315_cov_2.954545_g13116_i0 | PRJNA1156092 | 13246 | 315 | 2.954545 | 9.30681675 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 150 | 1.02e-31 | NTclustered | gi|829188944|ref|XM_001031587.2| | 312017 | g13116 | i0 | 84.076 | 0.498412698412698 | 157 | 23 | 50 | 2 | 87 | 242 | 204 | 49 | Tetrahymena thermophila SB210 60S ribosomal L7Ae-like protein partial mRNA | blastn | 157 | 150 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 7956083 | 7956083 | PRJNA1156092_P_NODE_3487_length_538_cov_4.600000_g3358_i0 | PRJNA1156092 | 3487 | 538 | 4.6 | 24.748 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 845 | 0 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3358 | i0 | 94.991 | 74.2546468401487 | 539 | 25 | 100 | 2 | 1 | 538 | 551 | 14 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 39949 | 845 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 10506481 | 10506481 | PRJNA1156092_P_NODE_15829_length_293_cov_0.895455_g15699_i0 | PRJNA1156092 | 15829 | 293 | 0.895455 | 2.62368315 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.48e-67 | NTclustered | gi|146185323|ref|XM_001031586.2| | 312017 | g15699 | i0 | 86.722 | 7.97952218430034 | 241 | 32 | 82 | 0 | 1 | 241 | 151 | 391 | Tetrahymena thermophila SB210 40S ribosomal protein S13 partial mRNA | blastn | 2338 | 268 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 10506585 | 10506585 | PRJNA1156092_P_NODE_2349_length_641_cov_1.311620_g2223_i0 | PRJNA1156092 | 2349 | 641 | 1.31162 | 8.4074842 | Colpoda inflata | 5980 | SAR_Eukaryotes | SAR_Eukaryotes | 675 | 0 | NTclustered | gi|4063575|gb|AF056098.1|AF056098 | 5980 | g2223 | i0 | 89.623 | 73.7519500780031 | 530 | 55 | 83 | 0 | 109 | 638 | 1226 | 697 | Colpoda inflata translation elongation factor 1-alpha (TEF1) gene, partial cds | blastn | 47275 | 675 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Colpodida | Colpodidae | Colpoda | Colpoda inflata | ||
| 13056247 | 13056247 | PRJNA1156092_P_NODE_11691_length_331_cov_1.193798_g11561_i0 | PRJNA1156092 | 11691 | 331 | 1.193798 | 3.95147138 | Oxytricha granulifera | 5947 | SAR_Eukaryotes | SAR_Eukaryotes | 272 | 2.2e-68 | NTclustered | gi|21215206|gb|AF510205.1| | 5947 | g11561 | i0 | 93.085 | 51.963746223565 | 188 | 10 | 56 | 2 | 1 | 185 | 1290 | 1477 | Oxytricha granulifera beta-tubulin gene, complete cds | blastn | 17200 | 272 | 1 | Eukaryota | Sar | Ciliophora | Spirotrichea | Sporadotrichida | Oxytrichidae | Oxytricha | Oxytricha granulifera | ||
| 15064937 | 15064937 | PRJNA1156092_P_NODE_26812_length_246_cov_1.335260_g26682_i0 | PRJNA1156092 | 26812 | 246 | 1.33526 | 3.2847396 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 121 | 6.01e-23 | NTclustered | gi|161847|gb|M37892.1|TETRPROL21 | 5911 | g26682 | i0 | 79.412 | 2.59756097560976 | 170 | 35 | 69 | 0 | 59 | 228 | 947 | 1116 | Tetrahymena thermophila ribosomal protein L21 gene, complete cds | blastn | 639 | 121 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 16879897 | 16879897 | PRJNA1156092_P_NODE_23874_length_249_cov_1.085227_g23744_i0 | PRJNA1156092 | 23874 | 249 | 1.085227 | 2.70221523 | Chilodonella hexasticha | 1938391 | SAR_Eukaryotes | SAR_Eukaryotes | 444 | 3.18e-120 | NTclustered | gi|1389430803|gb|MH341631.1| | 1938391 | g23744 | i0 | 98.795 | 99.9036144578313 | 249 | 3 | 100 | 0 | 1 | 249 | 922 | 674 | Chilodonella hexasticha strain C. hexasticha SC large subunit ribosomal RNA gene, partial sequence | blastn | 24876 | 444 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella hexasticha | ||
| 16879959 | 16879959 | PRJNA1156092_P_NODE_27454_length_246_cov_0.890173_g27324_i0 | PRJNA1156092 | 27454 | 246 | 0.890173 | 2.18982558 | Paramecium tetraurelia | 5888 | SAR_Eukaryotes | SAR_Eukaryotes | 135 | 2.14e-27 | NTclustered | gi|2386222277|ref|XM_001427428.2| | 5888 | g27324 | i0 | 78.774 | 1.26829268292683 | 212 | 37 | 85 | 7 | 1 | 208 | 792 | 999 | Paramecium tetraurelia uncharacterized protein (GSPATT00030705001), mRNA | blastn | 312 | 135 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 16879983 | 16879983 | PRJNA1156092_P_NODE_2874_length_586_cov_1.947368_g2746_i0 | PRJNA1156092 | 2874 | 586 | 1.947368 | 11.41157648 | Chilodonella uncinata | 151077 | SAR_Eukaryotes | SAR_Eukaryotes | 935 | 0 | NTclustered | gi|110645063|gb|DQ665311.1| | 151077 | g2746 | i0 | 97.112 | 28 | 554 | 16 | 100 | 0 | 1 | 554 | 406 | 959 | Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear | blastn | 16408 | 935 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella uncinata | ||
| 17614835 | 17614835 | PRJNA1156092_P_NODE_12214_length_325_cov_1.928571_g12084_i0 | PRJNA1156092 | 12214 | 325 | 1.928571 | 6.26785575 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 3.87e-16 | NTclustered | gi|325195237|emb|FR826032.1| | 890382 | g12084 | i0 | 96.61 | 46.9753846153846 | 59 | 2 | 18 | 0 | 266 | 324 | 207 | 265 | Albugo laibachii Nc14, genomic contig CONTIG_3119_NC14_v4_456_35141 | blastn | 15267 | 99 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 18154513 | 18154513 | PRJNA1156092_P_NODE_19775_length_265_cov_1.223958_g19645_i0 | PRJNA1156092 | 19775 | 265 | 1.223958 | 3.2434887 | Pseudocohnilembus persalinus | 266149 | SAR_Eukaryotes | SAR_Eukaryotes | 80.5 | 1.11e-10 | NTclustered | gi|2072713056|gb|MH608212.2| | 266149 | g19645 | i0 | 85.185 | 0.969811320754717 | 81 | 9 | 31 | 3 | 1 | 81 | 37541 | 37464 | Pseudocohnilembus persalinus mitochondrion | blastn | 257 | 80.5 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Philasterida | Pseudocohnilembidae | Pseudocohnilembus | Pseudocohnilembus persalinus | ||
| 19428663 | 19428663 | PRJNA1156092_P_NODE_10236_length_347_cov_1.405109_g10106_i0 | PRJNA1156092 | 10236 | 347 | 1.405109 | 4.87572823 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 220 | 8.51e-53 | NTclustered | gi|829189869|ref|XM_001031057.3| | 312017 | g10106 | i0 | 78.198 | 1.64265129682997 | 344 | 75 | 99 | 0 | 2 | 345 | 2143 | 2486 | Tetrahymena thermophila SB210 elongation factor 2, putative partial mRNA | blastn | 570 | 220 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 21439223 | 21439223 | PRJNA1156092_P_NODE_7357_length_396_cov_1.191950_g7227_i0 | PRJNA1156092 | 7357 | 396 | 1.19195 | 4.720122 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 134 | 1.32e-26 | NTclustered | gi|315570342|tpg|BK007933.1| | 5911 | g7227 | i0 | 79.592 | 2.91666666666667 | 196 | 32 | 48 | 4 | 208 | 396 | 291 | 97 | TPA_exp: Tetrahymena thermophila 40S ribosomal protein rpS26e mRNA, complete cds | blastn | 1155 | 134 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 22714130 | 22714130 | PRJNA1156092_P_NODE_21278_length_254_cov_2.546961_g21148_i0 | PRJNA1156092 | 21278 | 254 | 2.546961 | 6.46928094 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.01e-40 | NTclustered | gi|50261276|ref|NC_005984.1| | 4770 | g21148 | i0 | 83.5 | 79.7874015748032 | 200 | 25 | 77 | 6 | 59 | 253 | 10445 | 10249 | Saprolegnia ferax mitochondrion, complete genome | blastn | 20266 | 180 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Saprolegniaceae | Saprolegnia | Saprolegnia ferax | ||
| 23255164 | 23255164 | PRJNA1156092_P_NODE_30719_length_243_cov_0.905882_g30589_i0 | PRJNA1156092 | 30719 | 243 | 0.905882 | 2.20129326 | Placidida sp. | 2810146 | SAR_Eukaryotes | SAR_Eukaryotes | 209 | 1.23e-49 | NTclustered | gi|2048770113|gb|MT042855.1| | 2810146 | g30589 | i0 | 83.043 | 90.5144032921811 | 230 | 39 | 95 | 0 | 1 | 230 | 479 | 250 | Placidida sp. strain HFCC739 60S ribosomal protein L10 mRNA, complete cds | blastn | 21995 | 209 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidida sp. | |||||
| 24528557 | 24528557 | PRJNA1156092_P_NODE_11560_length_332_cov_1.482625_g11430_i0 | PRJNA1156092 | 11560 | 332 | 1.482625 | 4.922315 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 268 | 2.8499999999999994e-67 | NTclustered | gi|161736|gb|L01416.1|TETBTUBUB | 5911 | g11430 | i0 | 83.505 | 55.355421686747 | 291 | 45 | 87 | 3 | 44 | 332 | 122 | 411 | Tetrahymena thermophila beta-tubulin (BTU2) gene, complete cds | blastn | 18378 | 268 | 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);;