contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJEB6097" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1400055 | 1400055 | PRJEB6097_S_NODE_2542_length_282_cov_14.599190_g2488_i0 | PRJEB6097 | 2542 | 282 | 14.59919 | 41.1697158 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 520 | 5.93e-143 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2488 | i0 | 100 | 99.8971631205674 | 281 | 0 | 99 | 0 | 2 | 282 | 328 | 48 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 28171 | 520 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 3542810 | 3542810 | PRJEB6097_S_NODE_5663_length_192_cov_4.598726_g5609_i0 | PRJEB6097 | 5663 | 192 | 4.598726 | 8.82955392 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 355 | 1.13e-93 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g5609 | i0 | 100 | 100.807291666667 | 192 | 0 | 100 | 0 | 1 | 192 | 1537 | 1346 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 19355 | 355 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 6095436 | 6095436 | PRJEB6097_S_NODE_6245_length_165_cov_3.800000_g6191_i0 | PRJEB6097 | 6245 | 165 | 3.8 | 6.27 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 305 | 9.59e-79 | NTclustered | gi|1695780|gb|U42448.1|CAU42448 | 45110 | g6191 | i0 | 100 | 100.315151515152 | 165 | 0 | 100 | 0 | 1 | 165 | 379 | 215 | Cercomonas ATCC50316 18S ribosomal RNA gene, complete sequence | blastn | 16552 | 305 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas sp. ATCC 50316 | |||
| 6095437 | 6095437 | PRJEB6097_S_NODE_6445_length_159_cov_2.258065_g6391_i0 | PRJEB6097 | 6445 | 159 | 2.258065 | 3.59032335 | Poterioochromonas | 88166 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 1.98e-75 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g6391 | i0 | 100 | 100.358490566038 | 159 | 0 | 100 | 0 | 1 | 159 | 1180 | 1338 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 15957 | 294 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 7369769 | 7369769 | PRJEB6097_S_NODE_506_length_434_cov_29013.070175_g452_i0 | PRJEB6097 | 506 | 434 | 29013.070175 | 125916.7245595 | root | 1 | Root_unresolved | Root_unresolved | 392 | 2.1699999999999998e-104 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g452 | i0 | 99.535 | 44.241935483871 | 215 | 1 | 50 | 0 | 220 | 434 | 8330 | 8116 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 19201 | 392 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 9052843 | 9052843 | PRJEB6097_S_NODE_4748_length_248_cov_3.389671_g4694_i0 | PRJEB6097 | 4748 | 248 | 3.389671 | 8.40638408 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 370 | 5.45e-98 | NTclustered | gi|2088238071|ref|NC_056910.1| | 88167 | g4694 | i0 | 99.507 | 75.3266129032258 | 203 | 1 | 82 | 0 | 1 | 203 | 15712 | 15510 | Poterioochromonas malhamensis strain SZCZR2049 plastid, complete genome | blastn | 18681 | 370 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 12879228 | 12879228 | PRJEB6097_S_NODE_6631_length_154_cov_2.075630_g6577_i0 | PRJEB6097 | 6631 | 154 | 2.07563 | 3.1964702 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 169 | 1.2e-37 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6577 | i0 | 95.283 | 44.7272727272727 | 106 | 5 | 69 | 0 | 3 | 108 | 3751 | 3856 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 6888 | 169 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 14153975 | 14153975 | PRJEB6097_S_NODE_192_length_505_cov_25064.421277_g138_i0 | PRJEB6097 | 192 | 505 | 25064.421277 | 126575.32744885 | Vorticella sp. 4 JG-2011 | 1295638 | SAR_Eukaryotes | SAR_Eukaryotes | 488 | 3.179999999999999e-133 | NTclustered | gi|512134943|gb|JX178902.1| | 1295638 | g138 | i0 | 98.556 | 54.8554455445545 | 277 | 3 | 55 | 1 | 230 | 505 | 1396 | 1120 | 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 | 27702 | 488 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Sessilida | Vorticellidae | Vorticella | Vorticella sp. 4 JG-2011 | ||
| 15427984 | 15427984 | PRJEB6097_S_NODE_4873_length_245_cov_3.785714_g4819_i0 | PRJEB6097 | 4873 | 245 | 3.785714 | 9.2749993 | Helicotheca tamesis | 374047 | SAR_Eukaryotes | SAR_Eukaryotes | 86.1 | 2.18e-12 | NTclustered | gi|2248495790|ref|NC_063455.1| | 374047 | g4819 | i0 | 84.444 | 4.26530612244898 | 90 | 11 | 36 | 3 | 131 | 219 | 5273 | 5360 | Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome | blastn | 1045 | 86.1 | 1 | Eukaryota | Sar | Bacillariophyta | Mediophyceae | Lithodesmiales | Lithodesmiaceae | Helicotheca | Helicotheca tamesis | ||
| 16702260 | 16702260 | PRJEB6097_S_NODE_434_length_450_cov_28391.645783_g380_i0 | PRJEB6097 | 434 | 450 | 28391.645783 | 127762.4060235 | Poterioochromonas malhamensis | 88167 | SAR_Eukaryotes | SAR_Eukaryotes | 401 | 3.759999999999999e-107 | NTclustered | gi|323690576|gb|GU935635.1| | 88167 | g380 | i0 | 100 | 27.8111111111111 | 217 | 0 | 48 | 0 | 234 | 450 | 2022 | 1806 | Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence | blastn | 12515 | 401 | 1 | Eukaryota | Sar | Synurophyceae | Ochromonadales | Ochromonadaceae | Poterioochromonas | Poterioochromonas malhamensis | |||
| 17977161 | 17977161 | PRJEB6097_S_NODE_6275_length_164_cov_3.410853_g6221_i0 | PRJEB6097 | 6275 | 164 | 3.410853 | 5.59379892 | Colponema vietnamica | 1492817 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 1.01e-33 | NTclustered | gi|1280963088|gb|MG202006.1| | 1492817 | g6221 | i0 | 91.304 | 111.707317073171 | 115 | 9 | 70 | 1 | 51 | 164 | 11280 | 11166 | Colponema vietnamica strain Colp-7a mitochondrion | blastn | 18320 | 156 | 1 | Eukaryota | Sar | Colponemida | Colponemidia | Colponema | Colponema vietnamica | ||||
| 18843899 | 18843899 | PRJEB6097_S_NODE_515_length_432_cov_29693.395466_g461_i0 | PRJEB6097 | 515 | 432 | 29693.395466 | 128275.46841312 | root | 1 | Root_unresolved | Root_unresolved | 374 | 7.829999999999997e-99 | NTclustered | gi|10832|emb|X54512.1| | 5911 | g461 | i0 | 98.14 | 42.6759259259259 | 215 | 2 | 49 | 2 | 1 | 213 | 8116 | 8330 | T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA | blastn | 18436 | 374 | 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);;