contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1226487" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 334845 | 334845 | PRJNA1226487_P_NODE_12721_length_414_cov_2.249267_g12621_i0 | PRJNA1226487 | 12721 | 414 | 2.249267 | 9.31196538 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 327 | 5.91e-85 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g12621 | i0 | 98.907 | 29.6256038647343 | 183 | 2 | 100 | 0 | 104 | 286 | 2060 | 1878 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 12265 | 327 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 334898 | 334898 | PRJNA1226487_P_NODE_33081_length_307_cov_2.786325_g32979_i0 | PRJNA1226487 | 33081 | 307 | 2.786325 | 8.55401775 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 558 | 1.38e-154 | NTclustered | gi|53829589|gb|AY582847.1| | 289359 | g32979 | i0 | 100 | 82.6938110749186 | 302 | 0 | 98 | 0 | 6 | 307 | 436 | 737 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 actin gene, partial cds | blastn | 25387 | 558 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 1609709 | 1609709 | PRJNA1226487_P_NODE_73422_length_244_cov_2.385965_g73320_i0 | PRJNA1226487 | 73422 | 244 | 2.385965 | 5.8217546 | Chilodonella piscicola | 1654720 | SAR_Eukaryotes | SAR_Eukaryotes | 337 | 5.429999999999998e-88 | NTclustered | gi|1389430804|gb|MH341632.1| | 1654720 | g73320 | i0 | 92.083 | 6.00409836065574 | 240 | 17 | 98 | 2 | 1 | 239 | 308 | 70 | Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence | blastn | 1465 | 337 | 1 | Eukaryota | Sar | Ciliophora | Phyllopharyngea | Chlamydodontida | Chilodonellidae | Chilodonella | Chilodonella piscicola | ||
| 2885849 | 2885849 | PRJNA1226487_P_NODE_38383_length_291_cov_11.403670_g38281_i0 | PRJNA1226487 | 38383 | 291 | 11.40367 | 33.1846797 | Wilbertia typica | 655661 | SAR_Eukaryotes | SAR_Eukaryotes | 95.3 | 4.42e-15 | NTclustered | gi|1418575077|gb|MH577585.1| | 655661 | g38281 | i0 | 90.411 | 19.9553264604811 | 73 | 5 | 25 | 2 | 70 | 141 | 112 | 183 | Wilbertia typica isolate PXM100628 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 5807 | 95.3 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Pleuronematida | Eurystomatellidae | Wilbertia | Wilbertia typica | ||
| 4161948 | 4161948 | PRJNA1226487_P_NODE_424_length_1255_cov_3.368866_g380_i0 | PRJNA1226487 | 424 | 1255 | 3.368866 | 42.2792683 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 2198 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g380 | i0 | 99.75 | 96.6286852589641 | 1199 | 3 | 96 | 0 | 52 | 1250 | 1238 | 40 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 121269 | 2198 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 5438259 | 5438259 | PRJNA1226487_P_NODE_61705_length_254_cov_10.640884_g61603_i0 | PRJNA1226487 | 61705 | 254 | 10.640884 | 27.02784536 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 455 | 1.5e-123 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g61603 | i0 | 99.598 | 1.63779527559055 | 249 | 1 | 98 | 0 | 1 | 249 | 73226 | 72978 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 416 | 455 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7988408 | 7988408 | PRJNA1226487_P_NODE_58327_length_259_cov_8.989247_g58225_i0 | PRJNA1226487 | 58327 | 259 | 8.989247 | 23.28214973 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 472 | 1.53e-128 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g58225 | i0 | 100 | 0.984555984555985 | 255 | 0 | 98 | 0 | 1 | 255 | 52198 | 51944 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 255 | 472 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 8699833 | 8699833 | PRJNA1226487_P_NODE_42027_length_285_cov_1.452830_g41925_i0 | PRJNA1226487 | 42027 | 285 | 1.45283 | 4.1405655 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.026 | NTclustered | gi|2558939|gb|AF025312.1|AF025312 | 5911 | g41925 | i0 | 96.667 | 0.645614035087719 | 30 | 1 | 11 | 0 | 239 | 268 | 2810 | 2839 | Tetrahymena thermophila cytoplasmic dynein heavy chain 1a gene, partial cds | blastn | 184 | 52.8 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8699838 | 8699838 | PRJNA1226487_P_NODE_50667_length_271_cov_6.151515_g50565_i0 | PRJNA1226487 | 50667 | 271 | 6.151515 | 16.67060565 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.05e-137 | NTclustered | gi|166046604|emb|CU367721.1| | 100861 | g50565 | i0 | 100 | 89.4612546125461 | 271 | 0 | 100 | 0 | 1 | 271 | 259 | 529 | Aphanomyces euteiches cDNA | blastn | 24244 | 501 | 1 | Eukaryota | Sar | Oomycota | Saprolegniomycetes | Saprolegniales | Verrucalvaceae | Aphanomyces | Aphanomyces euteiches | ||
| 10538750 | 10538750 | PRJNA1226487_P_NODE_1789_length_780_cov_2.504950_g1706_i0 | PRJNA1226487 | 1789 | 780 | 2.50495 | 19.53861 | Ochromonas danica | 2986 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 1.82e-127 | NTclustered | gi|11465862|ref|NC_002571.1| | 2986 | g1706 | i0 | 82.353 | 38.474358974359 | 544 | 92 | 69 | 3 | 239 | 780 | 5412 | 4871 | Ochromonas danica mitochondrion, complete genome | blastn | 30010 | 470 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Ochromonas | Ochromonas danica | |||
| 11813547 | 11813547 | PRJNA1226487_P_NODE_31490_length_312_cov_29.682008_g31388_i0 | PRJNA1226487 | 31490 | 312 | 29.682008 | 92.60786496 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 2.3399999999999998e-157 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g31388 | i0 | 100 | 0.983974358974359 | 307 | 0 | 98 | 0 | 1 | 307 | 38526 | 38832 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 307 | 568 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 14363900 | 14363900 | PRJNA1226487_P_NODE_3232_length_646_cov_11.668412_g3141_i0 | PRJNA1226487 | 3232 | 646 | 11.668412 | 75.37794152 | Albugo laibachii | 653948 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 2.08e-76 | NTclustered | gi|325196715|emb|FR827504.1| | 890382 | g3141 | i0 | 95.238 | 0.292569659442724 | 189 | 9 | 29 | 0 | 87 | 275 | 1 | 189 | Albugo laibachii Nc14, genomic contig CONTIG_4671_NC14_v4_189_105 | blastn | 189 | 300 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Albuginales | Albuginaceae | Albugo | Albugo laibachii | ||
| 15074392 | 15074392 | PRJNA1226487_P_NODE_20532_length_357_cov_17.091549_g20430_i0 | PRJNA1226487 | 20532 | 357 | 17.091549 | 61.01682993 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 643 | 4.379999999999998e-180 | NTclustered | gi|1409222722|gb|MH536656.1| | 88167 | g20430 | i0 | 99.715 | 95.9523809523809 | 351 | 1 | 98 | 0 | 7 | 357 | 1 | 351 | Poterioochromonas malhamensis strain SAG933-1a small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1 and 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 34255 | 643 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 19461017 | 19461017 | PRJNA1226487_P_NODE_63976_length_251_cov_1.730337_g63874_i0 | PRJNA1226487 | 63976 | 251 | 1.730337 | 4.34314587 | Plasmodium yoelii | 5861 | SAR_Eukaryotes | SAR_Eukaryotes | 52.8 | 0.023 | NTclustered | gi|1270521409|ref|XM_722283.2| | 5861 | g63874 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 185 | 212 | 281 | 308 | Plasmodium yoelii conserved Plasmodium protein, unknown function (PY17X_1106400), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Sar | Apicomplexa | Aconoidasida | Haemosporida | Plasmodiidae | Plasmodium | Plasmodium yoelii | ||
| 20736344 | 20736344 | PRJNA1226487_P_NODE_22977_length_345_cov_3.463235_g22875_i0 | PRJNA1226487 | 22977 | 345 | 3.463235 | 11.94816075 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 481 | 3.51e-131 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g22875 | i0 | 99.251 | 90.9159420289855 | 267 | 1 | 100 | 1 | 79 | 345 | 1904 | 1639 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 31366 | 481 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 22011743 | 22011743 | PRJNA1226487_P_NODE_67258_length_249_cov_0.875000_g67156_i0 | PRJNA1226487 | 67258 | 249 | 0.875 | 2.17875 | Kryptoperidinium foliaceum | 160619 | SAR_Eukaryotes | SAR_Eukaryotes | 126 | 1.31e-24 | NTclustered | gi|54300507|gb|AY713393.1| | 160619 | g67156 | i0 | 84.328 | 7.48192771084337 | 134 | 16 | 53 | 5 | 25 | 155 | 1101 | 970 | Kryptoperidinium foliaceum isolate KfolHSP90_6 heat shock protein 90 gene, partial cds | blastn | 1863 | 126 | 1 | Eukaryota | Sar | Dinophyceae | Peridiniales | Kryptoperidiniaceae | Kryptoperidinium | Kryptoperidinium foliaceum |
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);;