contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA826497" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2503757 | 2503757 | PRJNA826497_S_NODE_7902_length_200_cov_6.113772_g7862_i0 | PRJNA826497 | 7902 | 200 | 6.113772 | 12.227544 | Ciliophora | 5878 | SAR_Eukaryotes | SAR_Eukaryotes | 364 | 1.96e-96 | NTclustered | gi|2624665746|gb|OR878271.1| | 210825 | g7862 | i0 | 99.5 | 94.095 | 200 | 1 | 100 | 0 | 1 | 200 | 653 | 852 | Glaucoma scintillans isolate LLH20220320 large subunit ribosomal RNA gene, partial sequence | blastn | 18819 | 364 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Glaucomidae | Glaucoma | Glaucoma scintillans | ||
| 7198800 | 7198800 | PRJNA826497_S_NODE_5386_length_223_cov_2.689474_g5346_i0 | PRJNA826497 | 5386 | 223 | 2.689474 | 5.99752702 | Microzonia abyssicola | 217214 | SAR_Eukaryotes | SAR_Eukaryotes | 128 | 3.1999999999999997e-25 | NTclustered | gi|2666682479|ref|NC_085312.1| | 217214 | g5346 | i0 | 83.824 | 14.3766816143498 | 136 | 21 | 62 | 1 | 8 | 142 | 27724 | 27859 | Syringoderma abyssicola plastid, complete genome | blastn | 3206 | 128 | 1 | Eukaryota | Sar | Phaeophyceae | Cutleriales | Cutleriaceae | Microzonia | Microzonia abyssicola | |||
| 9748640 | 9748640 | PRJNA826497_S_NODE_1508_length_304_cov_9.435424_g1468_i0 | PRJNA826497 | 1508 | 304 | 9.435424 | 28.68368896 | Cercomonas sp. HFCC548 | 458873 | SAR_Eukaryotes | SAR_Eukaryotes | 424 | 5.21e-114 | NTclustered | gi|161015713|gb|EF681947.1| | 458873 | g1468 | i0 | 94.834 | 89.3453947368421 | 271 | 14 | 89 | 0 | 18 | 288 | 1 | 271 | Cercomonas sp. HFCC548 28S ribosomal RNA gene, partial sequence | blastn | 27161 | 424 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. HFCC548 | |||
| 9748655 | 9748655 | PRJNA826497_S_NODE_17468_length_157_cov_4.459677_g17428_i0 | PRJNA826497 | 17468 | 157 | 4.459677 | 7.00169289 | Symbiodinium sp. clade F | 298136 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 4.63e-7 | NTclustered | gi|344227771|gb|JN558142.1| | 1075214 | g17428 | i0 | 97.436 | 1.96815286624204 | 39 | 1 | 25 | 0 | 117 | 155 | 418 | 380 | Symbiodinium sp. F5.2g clone 1 calmodulin gene, partial sequence | blastn | 309 | 67.6 | 1 | Eukaryota | Sar | Dinophyceae | Suessiales | Symbiodiniaceae | Symbiodinium | Symbiodinium sp. clade F | |||
| 9748693 | 9748693 | PRJNA826497_S_NODE_6508_length_211_cov_14.348315_g6468_i0 | PRJNA826497 | 6508 | 211 | 14.348315 | 30.27494465 | Ichthyophthirius multifiliis | 5932 | SAR_Eukaryotes | SAR_Eukaryotes | 54.7 | 0.005 | NTclustered | gi|471228422|ref|XM_004035045.1| | 5932 | g6468 | i0 | 100 | 0.137440758293839 | 29 | 0 | 14 | 0 | 67 | 95 | 1136 | 1164 | Ichthyophthirius multifiliis hypothetical protein (IMG5_106200) mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Ichthyophthirius | Ichthyophthirius multifiliis | |||
| 11024344 | 11024344 | PRJNA826497_S_NODE_15829_length_162_cov_5.395349_g15789_i0 | PRJNA826497 | 15829 | 162 | 5.395349 | 8.74046538 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 300 | 4.36e-77 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g15789 | i0 | 100 | 3 | 162 | 0 | 100 | 0 | 1 | 162 | 15811 | 15650 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 486 | 300 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 13574181 | 13574181 | PRJNA826497_S_NODE_2571_length_268_cov_18.936170_g2531_i0 | PRJNA826497 | 2571 | 268 | 18.93617 | 50.7489356 | Develorapax marinus | 1892415 | SAR_Eukaryotes | SAR_Eukaryotes | 244 | 3.77e-60 | NTclustered | gi|1059048665|gb|KX500026.1| | 1892415 | g2531 | i0 | 83.704 | 98.794776119403 | 270 | 33 | 99 | 9 | 4 | 268 | 285 | 22 | Develorapax marinus isolate Colp-4a 28S ribosomal RNA gene, partial sequence | blastn | 26477 | 244 | 1 | Eukaryota | Sar | Developea | Developayellaceae | Develorapax | Develorapax marinus | ||||
| 13574206 | 13574206 | PRJNA826497_S_NODE_6711_length_210_cov_3.344633_g6671_i0 | PRJNA826497 | 6711 | 210 | 3.344633 | 7.0237293 | Globisporangium ultimum | 2052682 | SAR_Eukaryotes | SAR_Eukaryotes | 381 | 2.069999999999999e-101 | NTclustered | gi|299830435|ref|NC_014280.1| | 2052682 | g6671 | i0 | 99.522 | 102.509523809524 | 209 | 1 | 99 | 0 | 1 | 209 | 9491 | 9699 | Pythium ultimum mitochondrion, complete genome | blastn | 21527 | 381 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium ultimum | ||
| 14848713 | 14848713 | PRJNA826497_S_NODE_4772_length_230_cov_2.472081_g4732_i0 | PRJNA826497 | 4772 | 230 | 2.472081 | 5.6857863 | uncultured Pseudocyrtolophosis | 2590482 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.05e-114 | NTclustered | gi|1691659327|gb|MN097001.1| | 2590482 | g4732 | i0 | 100 | 97.0130434782609 | 230 | 0 | 100 | 0 | 1 | 230 | 27 | 256 | Uncultured Pseudocyrtolophosis clone OTU123 small subunit ribosomal RNA gene, partial sequence | blastn | 22313 | 425 | 1 | Eukaryota | Sar | Ciliophora | Colpodea | Cyrtolophosidida | Cyrtolophosididae | uncultured Pseudocyrtolophosis | |||
| 18671980 | 18671980 | PRJNA826497_S_NODE_8255_length_198_cov_2.672727_g8215_i0 | PRJNA826497 | 8255 | 198 | 2.672727 | 5.29199946 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.5600000000000003e-80 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g8215 | i0 | 94.949 | 89.8484848484848 | 198 | 10 | 100 | 0 | 1 | 198 | 1548 | 1351 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 17790 | 311 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 19079833 | 19079833 | PRJNA826497_S_NODE_14395_length_167_cov_4.582090_g14355_i0 | PRJNA826497 | 14395 | 167 | 4.58209 | 7.6520903 | Pythiaceae | 4782 | SAR_Eukaryotes | SAR_Eukaryotes | 303 | 3.5e-78 | NTclustered | gi|292680103|dbj|AB468709.1| | 82942 | g14355 | i0 | 99.401 | 99.9461077844311 | 167 | 1 | 100 | 0 | 1 | 167 | 79 | 245 | Pythium nunn gene for large subunit ribosomal RNA, partial sequence, strain: UZ041 | blastn | 16691 | 303 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium nunn | ||
| 20354581 | 20354581 | PRJNA826497_S_NODE_18176_length_155_cov_4.024590_g18136_i0 | PRJNA826497 | 18176 | 155 | 4.02459 | 6.2381145 | Globisporangium | 1448052 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.49e-71 | NTclustered | gi|531037417|gb|AY598709.2| | 82942 | g18136 | i0 | 99.355 | 100.548387096774 | 155 | 1 | 100 | 0 | 1 | 155 | 575 | 729 | Globisporangium nunn strain CBS 808.96 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 | 15585 | 281 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Pythiales | Pythiaceae | Globisporangium | Globisporangium nunn | ||
| 21222717 | 21222717 | PRJNA826497_S_NODE_777_length_360_cov_2.626911_g737_i0 | PRJNA826497 | 777 | 360 | 2.626911 | 9.4568796 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 651 | 0 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g737 | i0 | 99.443 | 37.9944444444444 | 359 | 1 | 99 | 1 | 1 | 359 | 16238 | 15881 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 13678 | 651 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 22497357 | 22497357 | PRJNA826497_S_NODE_14838_length_165_cov_23.333333_g14798_i0 | PRJNA826497 | 14838 | 165 | 23.333333 | 38.49999945 | Cercozoa sp. W36p59t2LS | 563766 | SAR_Eukaryotes | SAR_Eukaryotes | 283 | 4.4899999999999995e-72 | NTclustered | gi|219524790|gb|EU709153.1| | 563766 | g14798 | i0 | 99.359 | 89.1151515151515 | 156 | 1 | 95 | 0 | 3 | 158 | 521 | 676 | Cercozoa sp. W36p59t2LS 18S ribosomal RNA gene, partial sequence | blastn | 14704 | 283 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. W36p59t2LS | ||||||
| 22905749 | 22905749 | PRJNA826497_S_NODE_10878_length_182_cov_5.241611_g10838_i0 | PRJNA826497 | 10878 | 182 | 5.241611 | 9.53973202 | Tetrahymena | 5890 | SAR_Eukaryotes | SAR_Eukaryotes | 215 | 1.87e-51 | NTclustered | gi|161728|gb|M86723.1|TETATUB | 5911 | g10838 | i0 | 94.891 | 62.478021978022 | 137 | 7 | 75 | 0 | 1 | 137 | 2601 | 2737 | Tetrahymena thermophila alpha-tubulin gene, complete cds | blastn | 11371 | 215 | 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);;