contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA397065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5515800 | 5515800 | PRJNA397065_S_NODE_7205_length_336_cov_14.371336_g6955_i0 | PRJNA397065 | 7205 | 336 | 14.371336 | 48.28768896 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 4.74e-80 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g6955 | i0 | 84.431 | 43.1339285714286 | 334 | 33 | 98 | 14 | 8 | 336 | 4022 | 3703 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14493 | 311 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 6789699 | 6789699 | PRJNA397065_S_NODE_10906_length_241_cov_13.500000_g10656_i0 | PRJNA397065 | 10906 | 241 | 13.5 | 32.535 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 315 | 2.51e-81 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g10656 | i0 | 90.417 | 100.248962655602 | 240 | 21 | 99 | 2 | 1 | 239 | 1679 | 1441 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 24160 | 315 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 13165741 | 13165741 | PRJNA397065_S_NODE_15291_length_184_cov_8.754839_g15041_i0 | PRJNA397065 | 15291 | 184 | 8.754839 | 16.10890376 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 180 | 6.9e-41 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g15041 | i0 | 84.492 | 18.9673913043478 | 187 | 23 | 100 | 6 | 1 | 184 | 2719 | 2902 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 3490 | 180 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14440885 | 14440885 | PRJNA397065_S_NODE_14112_length_196_cov_12655.239521_g13862_i0 | PRJNA397065 | 14112 | 196 | 12655.239521 | 24804.269461160002 | Thaumatomastix sp. CC002-Boundary Bay | 741090 | SAR_Eukaryotes | SAR_Eukaryotes | 263 | 7.189999999999999e-66 | NTclustered | gi|290760490|gb|GQ144693.1| | 741090 | g13862 | i0 | 99.31 | 73.9795918367347 | 145 | 1 | 74 | 0 | 1 | 145 | 2821 | 2965 | Thaumatomastix sp. CC002-Boundary Bay large subunit ribosomal RNA gene, partial sequence | blastn | 14500 | 263 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Thaumatomastigidae | Thaumatomastix | Thaumatomastix sp. CC002-Boundary Bay | ||
| 18263719 | 18263719 | PRJNA397065_S_NODE_5355_length_424_cov_10.473418_g5106_i0 | PRJNA397065 | 5355 | 424 | 10.473418 | 44.40729232 | Heteromita globosa | 45107 | SAR_Eukaryotes | SAR_Eukaryotes | 538 | 2.569999999999999e-148 | NTclustered | gi|238617605|gb|FJ973380.1| | 45107 | g5106 | i0 | 89.647 | 99.7688679245283 | 425 | 41 | 100 | 3 | 1 | 424 | 1679 | 1257 | Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence | blastn | 42302 | 538 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita globosa | |||
| 18931209 | 18931209 | PRJNA397065_S_NODE_5595_length_410_cov_5878.643045_g5346_i0 | PRJNA397065 | 5595 | 410 | 5878.643045 | 24102.4364845 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 521 | 2.5e-143 | NTclustered | gi|166084089|gb|EF024612.1| | 175275 | g5346 | i0 | 92.798 | 88.190243902439 | 361 | 24 | 88 | 2 | 52 | 410 | 390 | 30 | Cercozoa environmental sample clone Elev_18S_933 18S ribosomal RNA gene, partial sequence | blastn | 36158 | 521 | 1 | Eukaryota | Sar | Cercozoa | uncultured Cercozoa | ||||||
| 19537959 | 19537959 | PRJNA397065_S_NODE_7316_length_332_cov_9.075908_g7066_i0 | PRJNA397065 | 7316 | 332 | 9.075908 | 30.13201456 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 2.8299999999999996e-72 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g7066 | i0 | 83.082 | 42.5481927710843 | 331 | 39 | 98 | 14 | 8 | 332 | 4022 | 3703 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 14126 | 285 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 22088519 | 22088519 | PRJNA397065_S_NODE_17578_length_165_cov_8.610294_g17328_i0 | PRJNA397065 | 17578 | 165 | 8.610294 | 14.2069851 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 97.1 | 6.28e-16 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g17328 | i0 | 98.182 | 29.3515151515152 | 55 | 1 | 33 | 0 | 111 | 165 | 2353 | 2407 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 4843 | 97.1 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima |
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);;