contig_metadata
19 rows where bioproject = "PRJNA1057075" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1451225 | 1451225 | PRJNA1057075_S_NODE_10182_length_155_cov_5.764151_g10083_i0 | PRJNA1057075 | 10182 | 155 | 5.764151 | 8.93443405 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 2.53e-59 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g10083 | i0 | 99.248 | 65 | 133 | 1 | 86 | 0 | 2 | 134 | 1289 | 1421 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 10075 | 241 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 4839337 | 4839337 | PRJNA1057075_S_NODE_3664_length_231_cov_1968.186813_g3565_i0 | PRJNA1057075 | 3664 | 231 | 1968.186813 | 4546.51153803 | Chilodonella | 151076 | SAR_Eukaryotes | SAR_Eukaryotes | 291 | 4.02e-74 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g3565 | i0 | 95.58 | 40.1645021645022 | 181 | 8 | 78 | 0 | 46 | 226 | 370 | 190 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 9278 | 291 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 5279346 | 5279346 | PRJNA1057075_S_NODE_4105_length_221_cov_1.744186_g4006_i0 | PRJNA1057075 | 4105 | 221 | 1.744186 | 3.85465106 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 87.9 | 5.37e-13 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g4006 | i0 | 94.643 | 6.55656108597285 | 56 | 3 | 25 | 0 | 1 | 56 | 848 | 903 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 1449 | 87.9 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 12930315 | 12930315 | PRJNA1057075_S_NODE_2511_length_264_cov_10.600000_g2412_i0 | PRJNA1057075 | 2511 | 264 | 10.6 | 27.984 | Poteriospumella lacustris | 1117027 | SAR_Eukaryotes | SAR_Eukaryotes | 392 | 1.25e-104 | NTclustered | gi|2295553597|gb|OP378946.1| | 1117027 | g2412 | i0 | 93.87 | 63.0643939393939 | 261 | 14 | 98 | 2 | 5 | 264 | 18 | 277 | Poteriospumella lacustris isolate 1532 large subunit ribosomal RNA gene, partial sequence | blastn | 16649 | 392 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Dinobryaceae | Poteriospumella | Poteriospumella lacustris | |||
| 14205274 | 14205274 | PRJNA1057075_S_NODE_2212_length_275_cov_449.575221_g2113_i0 | PRJNA1057075 | 2212 | 275 | 449.575221 | 1236.33185775 | Leukarachnion sp. ATCC PRA-24 | 568390 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 1.11e-40 | NTclustered | gi|2727570083|gb|PP760457.1| | 568390 | g2113 | i0 | 84.699 | 29.8 | 183 | 25 | 65 | 2 | 1 | 180 | 2294 | 2476 | Leukarachnion sp. ATCC PRA-24 culture ATCC:BJ-24B2 mitochondrion, complete genome | blastn | 8195 | 180 | 1 | Eukaryota | Sar | Leukarachnion sp. ATCC PRA-24 | |||||||
| 15479403 | 15479403 | PRJNA1057075_S_NODE_2353_length_269_cov_52640.877273_g2254_i0 | PRJNA1057075 | 2353 | 269 | 52640.877273 | 141603.95986437 | Placidida sp. | 2810146 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.43e-24 | NTclustered | gi|2048770203|gb|MT042900.1| | 2810146 | g2254 | i0 | 83.212 | 18.2230483271375 | 137 | 23 | 51 | 0 | 10 | 146 | 257 | 393 | Placidida sp. strain HFCC1258 ribosomal protein S15A mRNA, complete cds | blastn | 4902 | 126 | 1 | Eukaryota | Sar | Bigyra | Placidida | Placidida sp. | |||||
| 15479411 | 15479411 | PRJNA1057075_S_NODE_3853_length_227_cov_1.398876_g3754_i0 | PRJNA1057075 | 3853 | 227 | 1.398876 | 3.17544852 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 420 | 4.81e-113 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g3754 | i0 | 100 | 103.066079295154 | 227 | 0 | 100 | 0 | 1 | 227 | 954 | 728 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 23396 | 420 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 16753487 | 16753487 | PRJNA1057075_S_NODE_1134_length_340_cov_9.426117_g1035_i0 | PRJNA1057075 | 1134 | 340 | 9.426117 | 32.0487978 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 586 | 7.119999999999998e-163 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g1035 | i0 | 99.08 | 93.7735294117647 | 326 | 3 | 96 | 0 | 15 | 340 | 1396 | 1071 | Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31883 | 586 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 19302325 | 19302325 | PRJNA1057075_S_NODE_8716_length_165_cov_4.362069_g8617_i0 | PRJNA1057075 | 8716 | 165 | 4.362069 | 7.19741385 | Pseudellipsoidion edaphicum | 1431838 | SAR_Eukaryotes | SAR_Eukaryotes | 292 | 7.47e-75 | NTclustered | gi|1567482280|ref|NC_040299.1| | 1431838 | g8617 | i0 | 98.78 | 126.818181818182 | 164 | 2 | 99 | 0 | 1 | 164 | 39597 | 39760 | Pseudellipsoidion edaphicum strain CAUP Q 401 plastid, complete genome | blastn | 20925 | 292 | 1 | Eukaryota | Sar | Eustigmatophyceae | Eustigmatales | Neomonodaceae | Pseudellipsoidion | Pseudellipsoidion edaphicum | |||
| 21853462 | 21853462 | PRJNA1057075_S_NODE_5178_length_200_cov_1.993377_g5079_i0 | PRJNA1057075 | 5178 | 200 | 1.993377 | 3.986754 | Phaeodactylum tricornutum | 2850 | SAR_Eukaryotes | SAR_Eukaryotes | 111 | 2.83e-20 | NTclustered | gi|219123891|ref|XM_002182214.1| | 556484 | g5079 | i0 | 85.714 | 1.05 | 105 | 15 | 53 | 0 | 21 | 125 | 321 | 425 | Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA | blastn | 210 | 111 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Phaeodactylaceae | Phaeodactylum | Phaeodactylum tricornutum | ||
| 23128900 | 23128900 | PRJNA1057075_S_NODE_4199_length_219_cov_1.482353_g4100_i0 | PRJNA1057075 | 4199 | 219 | 1.482353 | 3.24635307 | Neospora caninum | 29176 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 3.17e-15 | NTclustered | gi|820693004|tpe|LN714485.1| | 572307 | g4100 | i0 | 86.364 | 1.15525114155251 | 88 | 10 | 40 | 2 | 83 | 169 | 854581 | 854667 | TPA_asm: Neospora caninum Liverpool, chromosome chrX, complete genome | blastn | 253 | 95.3 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Sarcocystidae | Neospora | Neospora caninum | ||
| 24402569 | 24402569 | PRJNA1057075_S_NODE_2980_length_249_cov_490.885000_g2881_i0 | PRJNA1057075 | 2980 | 249 | 490.885 | 1222.30365 | Hydrurus foetidus | 2996 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 4.74e-19 | NTclustered | gi|219903754|emb|FM955257.1| | 2996 | g2881 | i0 | 89.535 | 33.9839357429719 | 86 | 7 | 34 | 2 | 19 | 102 | 1765 | 1850 | Hydrurus foetidus partial 28S rRNA gene | blastn | 8462 | 108 | 1 | Eukaryota | Sar | Chrysophyceae | Hydrurales | Hydruraceae | Hydrurus | Hydrurus foetidus | |||
| 26908772 | 26908772 | PRJNA1057075_S_NODE_1562_length_308_cov_1.779923_g1463_i0 | PRJNA1057075 | 1562 | 308 | 1.779923 | 5.48216284 | Symbiodinium microadriaticum | 2951 | SAR_Eukaryotes | SAR_Eukaryotes | 108 | 3.59e-27 | NR | CAE7473169.1 | 2951 | g1463 | i0 | 78.5 | 0.633116883116883 | 65 | 14 | 63.3 | 0 | 307 | 113 | 140 | 204 | CAE7473169.1 RPS8 [Symbiodinium microadriaticum] | diamond | 195 | 108 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium microadriaticum | |||
| 27288155 | 27288155 | PRJNA1057075_S_NODE_4023_length_223_cov_1.965517_g3924_i0 | PRJNA1057075 | 4023 | 223 | 1.965517 | 4.38310291 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 81.6 | 3.37e-18 | NR | KAJ1419208.1 | 483371 | g3924 | i0 | 72.9 | 1.30493273542601 | 48 | 13 | 64.6 | 0 | 212 | 69 | 48 | 95 | KAJ1419208.1 ribosomal protein L31e-domain-containing protein [Ochromonadaceae sp. CCMP2298] | diamond | 291 | 81.6 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 28646091 | 28646091 | PRJNA1057075_S_NODE_8407_length_167_cov_2.864407_g8308_i0 | PRJNA1057075 | 8407 | 167 | 2.864407 | 4.78355969 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 45.1 | 0.00204 | NR | KAJ1421113.1 | 483371 | g8308 | i0 | 70 | 0.538922155688623 | 30 | 9 | 53.9 | 0 | 167 | 78 | 576 | 605 | KAJ1421113.1 hypothetical protein B484DRAFT_433346 [Ochromonadaceae sp. CCMP2298] | diamond | 90 | 45.1 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 30912043 | 30912043 | PRJNA1057075_S_NODE_6754_length_180_cov_1.763359_g6655_i0 | PRJNA1057075 | 6754 | 180 | 1.763359 | 3.1740462 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 8.72e-9 | NR | KAJ1411071.1 | 483371 | g6655 | i0 | 80 | 1.23333333333333 | 35 | 7 | 58.3 | 0 | 180 | 76 | 96 | 130 | KAJ1411071.1 50S ribosomal protein L30e-like protein [Ochromonadaceae sp. CCMP2298] | diamond | 222 | 58.2 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 31140766 | 31140766 | PRJNA1057075_S_NODE_9295_length_162_cov_1.380531_g9196_i0 | PRJNA1057075 | 9295 | 162 | 1.380531 | 2.23646022 | Tribonema minus | 303371 | SAR_Eukaryotes | SAR_Eukaryotes | 72.4 | 3.94e-13 | NR | KAG5177030.1 | 303371 | g9196 | i0 | 73 | 0.685185185185185 | 37 | 10 | 68.5 | 0 | 3 | 113 | 380 | 416 | KAG5177030.1 putative cysteine protease family C01A [Tribonema minus] | diamond | 111 | 72.4 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema minus | |||
| 32026840 | 32026840 | PRJNA1057075_S_NODE_3738_length_230_cov_3.994475_g3639_i0 | PRJNA1057075 | 3738 | 230 | 3.994475 | 9.1872925 | Ochromonadaceae sp. CCMP2298 | 483371 | SAR_Eukaryotes | SAR_Eukaryotes | 60.8 | 8.45e-10 | NR | KAJ1414916.1 | 483371 | g3639 | i0 | 46.7 | 0.978260869565217 | 75 | 25 | 78.3 | 1 | 4 | 183 | 37 | 111 | KAJ1414916.1 ribosomal protein L6, partial [Ochromonadaceae sp. CCMP2298] | diamond | 225 | 60.8 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Ochromonadaceae sp. CCMP2298 | ||||
| 32271936 | 32271936 | PRJNA1057075_S_NODE_458_length_438_cov_249.344473_g370_i0 | PRJNA1057075 | 458 | 438 | 249.344473 | 1092.12879174 | root | 1 | Root_unresolved | Root_unresolved | 46.6 | 0.0126 | NR | XP_013349759.1 | 44415 | g370 | i0 | 87 | 0.349315068493151 | 23 | 3 | 15.8 | 0 | 419 | 351 | 116 | 138 | XP_013349759.1 uncharacterized protein EMH_0029470 [Eimeria mitis] | diamond | 153 | 46.6 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Eimeriidae | Eimeria | Eimeria mitis |
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);;