contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 944803 | 944803 | PRJNA971676_P_NODE_6981_length_328_cov_1.674510_g6892_i0 | PRJNA971676 | 6981 | 328 | 1.67451 | 5.4923928 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 606 | 5.249999999999998e-169 | NTclustered | gi|859811083|gb|KM818001.1| | 88167 | g6892 | i0 | 100 | 102.899390243902 | 328 | 0 | 100 | 0 | 1 | 328 | 1129 | 802 | Poterioochromonas malhamensis strain SAG 933.1c 23S ribosomal RNA gene, partial sequence; plastid | blastn | 33751 | 606 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 1266295 | 1266295 | PRJNA971676_P_NODE_10961_length_277_cov_1.132353_g10872_i0 | PRJNA971676 | 10961 | 277 | 1.132353 | 3.13661781 | Oligohymenophorea | 6020 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 1.03e-100 | NTclustered | gi|74829873|emb|CR932119.1| | 5888 | g10872 | i0 | 91.336 | 97.0397111913357 | 277 | 24 | 100 | 0 | 1 | 277 | 5195 | 4919 | Paramecium tetraurelia macronuclear, alpha-tubulin-related protein gene | blastn | 26880 | 379 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Peniculida | Parameciidae | Paramecium | Paramecium tetraurelia | ||
| 2220129 | 2220129 | PRJNA971676_P_NODE_5782_length_350_cov_1.667870_g5693_i0 | PRJNA971676 | 5782 | 350 | 1.66787 | 5.837545 | Tetrahymena pyriformis | 5908 | SAR_Eukaryotes | SAR_Eukaryotes | 460 | 4.64e-125 | NTclustered | gi|5701724|dbj|AB024694.1| | 5908 | g5693 | i0 | 90.251 | 2.40857142857143 | 359 | 25 | 99 | 6 | 1 | 349 | 360 | 2 | Tetrahymena pyriformis mRNA for 14-3-3 protein, complete cds | blastn | 843 | 460 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 3495385 | 3495385 | PRJNA971676_P_NODE_2483_length_487_cov_1.857488_g2394_i0 | PRJNA971676 | 2483 | 487 | 1.857488 | 9.04596656 | Phytophthora nicotianae | 4792 | SAR_Eukaryotes | SAR_Eukaryotes | 255 | 3.37e-63 | NTclustered | gi|675207712|ref|XM_008914493.1| | 761204 | g2394 | i0 | 79.515 | 96.3326488706365 | 371 | 66 | 75 | 8 | 47 | 412 | 393 | 28 | Phytophthora parasitica INRA-310 hsp70-like protein partial mRNA | blastn | 46914 | 255 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora nicotianae | ||
| 3818414 | 3818414 | PRJNA971676_P_NODE_19343_length_245_cov_0.895349_g19254_i0 | PRJNA971676 | 19343 | 245 | 0.895349 | 2.19360505 | Phytophthora | 4783 | SAR_Eukaryotes | SAR_Eukaryotes | 124 | 4.62e-24 | NTclustered | gi|2795061008|ref|XM_067940276.1| | 4785 | g19254 | i0 | 80.745 | 28.1102040816327 | 161 | 29 | 65 | 2 | 5 | 164 | 360 | 201 | Phytophthora cinnamomi 60S ribosomal protein L23a (IUM83_15460), partial mRNA | blastn | 6887 | 124 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 7322737 | 7322737 | PRJNA971676_P_NODE_23846_length_228_cov_2.483871_g23757_i0 | PRJNA971676 | 23846 | 228 | 2.483871 | 5.66322588 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 416 | 6.259999999999998e-112 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g23757 | i0 | 99.561 | 97.5526315789474 | 228 | 1 | 100 | 0 | 1 | 228 | 1807 | 1580 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 22242 | 416 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7644422 | 7644422 | PRJNA971676_P_NODE_14826_length_250_cov_0.870056_g14737_i0 | PRJNA971676 | 14826 | 250 | 0.870056 | 2.17514 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 329 | 9.34e-86 | NTclustered | gi|10812|emb|X05543.1| | 5911 | g14737 | i0 | 91.02 | 5.848 | 245 | 20 | 98 | 2 | 6 | 249 | 304 | 547 | Tetrahymena thermophila gene for histone H2B-1 from macronucleus | blastn | 1462 | 329 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8597480 | 8597480 | PRJNA971676_P_NODE_13267_length_255_cov_2.010989_g13178_i0 | PRJNA971676 | 13267 | 255 | 2.010989 | 5.12802195 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 333 | 7.3899999999999995e-87 | NTclustered | gi|829157134|ref|XM_001011598.2| | 312017 | g13178 | i0 | 90.196 | 1 | 255 | 25 | 100 | 0 | 1 | 255 | 590 | 844 | Tetrahymena thermophila SB210 60S ribosomal protein L5 partial mRNA | blastn | 255 | 333 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 8919415 | 8919415 | PRJNA971676_P_NODE_7367_length_322_cov_1.236948_g7278_i0 | PRJNA971676 | 7367 | 322 | 1.236948 | 3.98297256 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 512 | 1.1499999999999998e-140 | NTclustered | gi|10935|emb|X56693.1| | 5908 | g7278 | i0 | 95.342 | 145.130434782609 | 322 | 15 | 100 | 0 | 1 | 322 | 645 | 324 | Tetrahymena pyriformis TUF11 gene for ubiquitin-ribosomal protein fusion protein | blastn | 46732 | 516 | 0.992248062015504 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena pyriformis | ||
| 8919442 | 8919442 | PRJNA971676_P_NODE_9467_length_292_cov_1.141553_g9378_i0 | PRJNA971676 | 9467 | 292 | 1.141553 | 3.33333476 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 390 | 5.049999999999999e-104 | NTclustered | gi|161789|gb|M87504.1|TETHIS32A | 5911 | g9378 | i0 | 93.511 | 35.8801369863014 | 262 | 17 | 90 | 0 | 4 | 265 | 471 | 210 | Tetrahymena thermophila histone H3 (HHT2) gene, complete cds | blastn | 10477 | 390 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 11148155 | 11148155 | PRJNA971676_P_NODE_1409_length_625_cov_1.780797_g1322_i0 | PRJNA971676 | 1409 | 625 | 1.780797 | 11.12998125 | Pyrocystis lunula | 2972 | SAR_Eukaryotes | SAR_Eukaryotes | 750 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g1322 | i0 | 88.424 | 98.0128 | 622 | 72 | 99 | 0 | 4 | 625 | 1008 | 387 | Pyrocystis lunula actin mRNA, complete cds | blastn | 61258 | 750 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 11148198 | 11148198 | PRJNA971676_P_NODE_1649_length_586_cov_1.200780_g1562_i0 | PRJNA971676 | 1649 | 586 | 1.20078 | 7.0365708 | Lagenidium giganteum | 4803 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 4.989999999999999e-107 | NTclustered | gi|1219685856|gb|KY965925.1| | 1440116 | g1562 | i0 | 80.556 | 80.598976109215 | 540 | 89 | 90 | 15 | 16 | 544 | 203 | 737 | Lagenidium giganteum f. caninum isolate UF15-01 heat shock protein 90 (hsp90) gene, partial cds | blastn | 47231 | 401 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Lagenidium | Lagenidium giganteum | ||
| 11148228 | 11148228 | PRJNA971676_P_NODE_18229_length_246_cov_1.687861_g18140_i0 | PRJNA971676 | 18229 | 246 | 1.687861 | 4.15213806 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 7.04e-92 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g18140 | i0 | 92.276 | 93.5772357723577 | 246 | 19 | 100 | 0 | 1 | 246 | 1578 | 1333 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 23020 | 350 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13698162 | 13698162 | PRJNA971676_P_NODE_10431_length_282_cov_1.775120_g10342_i0 | PRJNA971676 | 10431 | 282 | 1.77512 | 5.0058384 | Labyrinthula terrestris | 382652 | SAR_Eukaryotes | SAR_Eukaryotes | 183 | 8.84e-42 | NTclustered | gi|94692241|gb|DQ486938.1| | 382652 | g10342 | i0 | 79.245 | 82.4574468085106 | 265 | 51 | 93 | 4 | 18 | 280 | 109 | 371 | Labyrinthula terrestris strain AZ-2 elongation factor 1 alpha gene, partial cds | blastn | 23253 | 183 | 1 | Eukaryota | Sar | Bigyra | Labyrinthulida | Labyrinthulaceae | Labyrinthula | Labyrinthula terrestris | |||
| 13698300 | 13698300 | PRJNA971676_P_NODE_19051_length_246_cov_0.890173_g18962_i0 | PRJNA971676 | 19051 | 246 | 0.890173 | 2.18982558 | Phytophthora sojae | 67593 | SAR_Eukaryotes | SAR_Eukaryotes | 226 | 1.2399999999999997e-54 | NTclustered | gi|695448559|ref|XM_009536718.1| | 67593 | g18962 | i0 | 83.74 | 67.6626016260163 | 246 | 32 | 99 | 6 | 1 | 245 | 630 | 868 | Phytophthora sojae ATP synthase beta subunit mRNA | blastn | 16645 | 226 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora sojae | ||
| 17522915 | 17522915 | PRJNA971676_P_NODE_9834_length_288_cov_1.074419_g9745_i0 | PRJNA971676 | 9834 | 288 | 1.074419 | 3.09432672 | Phytophthora hydrogena | 1286608 | SAR_Eukaryotes | SAR_Eukaryotes | 217 | 8.93e-52 | NTclustered | gi|1233050041|gb|KX252277.1| | 1286608 | g9745 | i0 | 85.167 | 72.6354166666667 | 209 | 31 | 73 | 0 | 23 | 231 | 222 | 14 | Phytophthora hydrogena isolate 44G8(authentic) heat shock protein 90 gene, partial cds | blastn | 20919 | 217 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora hydrogena | ||
| 18796460 | 18796460 | PRJNA971676_P_NODE_215_length_1388_cov_3.234221_g169_i0 | PRJNA971676 | 215 | 1388 | 3.234221 | 44.89098748 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | 289359 | SAR_Eukaryotes | SAR_Eukaryotes | 2241 | 0 | NTclustered | gi|53829555|gb|AY582830.1| | 289359 | g169 | i0 | 99.433 | 93.7312680115274 | 1234 | 7 | 89 | 0 | 70 | 1303 | 5 | 1238 | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 ef1a gene, partial cds | blastn | 130099 | 2241 | 1 | Eukaryota | Sar | Stramenopile sp. ex Nuclearia delicatula CCAP1552/1 | |||||||
| 20071151 | 20071151 | PRJNA971676_P_NODE_10536_length_281_cov_1.764423_g10447_i0 | PRJNA971676 | 10536 | 281 | 1.764423 | 4.95802863 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 342 | 1.3699999999999997e-89 | NTclustered | gi|829164475|ref|XM_971965.3| | 312017 | g10447 | i0 | 88.849 | 1.62277580071174 | 278 | 31 | 99 | 0 | 4 | 281 | 1049 | 772 | Tetrahymena thermophila SB210 protein transporter Sec61 alpha subunit partial mRNA | blastn | 456 | 342 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 21668835 | 21668835 | PRJNA971676_P_NODE_4297_length_391_cov_2.500000_g4208_i0 | PRJNA971676 | 4297 | 391 | 2.5 | 9.775 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 243 | 2.07e-59 | NTclustered | gi|161015642|gb|EF577233.1| | 373011 | g4208 | i0 | 85.714 | 33.2378516624041 | 231 | 31 | 59 | 2 | 1 | 230 | 230 | 1 | Spumella-like flagellate 194f alpha-tubulin gene, partial cds | blastn | 12996 | 243 | 1 | Eukaryota | Sar | Chrysophyceae | Chromulinales | Chromulinaceae | Spumella-like flagellate 194f | ||||
| 21668844 | 21668844 | PRJNA971676_P_NODE_497_length_981_cov_4.110132_g429_i0 | PRJNA971676 | 497 | 981 | 4.110132 | 40.32039492 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 1216 | 0 | NTclustered | gi|27450758|gb|AF508263.1| | 2972 | g429 | i0 | 89.093 | 98.5800203873598 | 981 | 103 | 99 | 4 | 1 | 979 | 1007 | 29 | Pyrocystis lunula actin mRNA, complete cds | blastn | 96707 | 1216 | 1 | Eukaryota | Sar | Dinophyceae | Gonyaulacales | Pyrocystaceae | Pyrocystis | Pyrocystis lunula | |||
| 22621799 | 22621799 | PRJNA971676_P_NODE_21578_length_243_cov_0.905882_g21489_i0 | PRJNA971676 | 21578 | 243 | 0.905882 | 2.20129326 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 449 | 6.65e-122 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g21489 | i0 | 100 | 98.3744855967078 | 243 | 0 | 100 | 0 | 1 | 243 | 15432 | 15674 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 23905 | 449 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 23897083 | 23897083 | PRJNA971676_P_NODE_17419_length_247_cov_1.327586_g17330_i0 | PRJNA971676 | 17419 | 247 | 1.327586 | 3.27913742 | Develorapax marinus | 1892415 | SAR_Eukaryotes | SAR_Eukaryotes | 141 | 4.63e-29 | NTclustered | gi|1059048665|gb|KX500026.1| | 1892415 | g17330 | i0 | 80.978 | 49.4251012145749 | 184 | 29 | 74 | 5 | 32 | 214 | 1897 | 2075 | Develorapax marinus isolate Colp-4a 28S ribosomal RNA gene, partial sequence | blastn | 12208 | 141 | 1 | Eukaryota | Sar | Developea | Developayellaceae | Develorapax | Develorapax marinus | ||||
| 25170897 | 25170897 | PRJNA971676_P_NODE_480_length_992_cov_6.972797_g414_i0 | PRJNA971676 | 480 | 992 | 6.972797 | 69.17014624 | Colponema vietnamica | 1492817 | SAR_Eukaryotes | SAR_Eukaryotes | 750 | 0 | NTclustered | gi|677286262|gb|KF997852.1| | 1492817 | g414 | i0 | 82.253 | 69.7772177419355 | 879 | 146 | 88 | 9 | 119 | 992 | 1336 | 463 | Colponema vietnamica from Viet Nam translation elongation factor 1-alpha (EF1A) mRNA, complete cds | blastn | 69219 | 750 | 1 | Eukaryota | Sar | Colponemida | Colponemidia | Colponema | Colponema vietnamica |
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);;