contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA450343" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1713900 | 1713900 | PRJNA450343_P_NODE_12242_length_164_cov_0.886957_g12174_i0 | PRJNA450343 | 12242 | 164 | 0.886957 | 1.45460948 | Bacillaria paxillifer | 3003 | SAR_Eukaryotes | SAR_Eukaryotes | 241 | 2.72e-59 | NTclustered | gi|2202538966|gb|OM891872.1| | 3003 | g12174 | i0 | 93.252 | 81.609756097561 | 163 | 11 | 99 | 0 | 2 | 164 | 4698 | 4536 | Bacillaria paxillifer small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 13384 | 241 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Bacillariales | Bacillariaceae | Bacillaria | Bacillaria paxillifer | ||
| 6816851 | 6816851 | PRJNA450343_P_NODE_8406_length_187_cov_1.471014_g8338_i0 | PRJNA450343 | 8406 | 187 | 1.471014 | 2.75079618 | Chlorellidium tetrabotrys | 243652 | SAR_Eukaryotes | SAR_Eukaryotes | 324 | 3.07e-84 | NTclustered | gi|46020003|emb|AJ580949.1| | 243652 | g8338 | i0 | 100 | 91.4812834224599 | 175 | 0 | 94 | 0 | 12 | 186 | 1 | 175 | Chlorellidium tetrabotrys partial 18S rRNA gene, strain SAG 5.90 | blastn | 17107 | 324 | 1 | Eukaryota | Sar | Xanthophyceae | Mischococcales | Botryochloridaceae | Chlorellidium | Chlorellidium tetrabotrys | |||
| 8745490 | 8745490 | PRJNA450343_P_NODE_2967_length_312_cov_2.631179_g2899_i0 | PRJNA450343 | 2967 | 312 | 2.631179 | 8.20927848 | root | 1 | Root_unresolved | Root_unresolved | 569 | 6.509999999999998e-158 | NTclustered | gi|291495600|gb|GU823227.1| | 152704 | g2899 | i0 | 99.679 | 100.019230769231 | 312 | 0 | 100 | 1 | 1 | 312 | 579 | 269 | Uncultured stramenopile clone A93F14RM1E05 18S ribosomal RNA gene, partial sequence | blastn | 31206 | 571 | 0.996497373029772 | Eukaryota | Sar | uncultured stramenopile | |||||||
| 9366941 | 9366941 | PRJNA450343_P_NODE_11268_length_166_cov_0.871795_g11200_i0 | PRJNA450343 | 11268 | 166 | 0.871795 | 1.4471797 | Tetrahymena thermophila | 5911 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 1.0199999999999999e-43 | NTclustered | gi|146161228|ref|XM_971777.2| | 312017 | g11200 | i0 | 87.273 | 0.993975903614458 | 165 | 21 | 99 | 0 | 1 | 165 | 94 | 258 | Tetrahymena thermophila SB210 ribosomal protein L11, amine-terminal domain protein partial mRNA | blastn | 165 | 189 | 1 | Eukaryota | Sar | Ciliophora | Oligohymenophorea | Hymenostomatida | Tetrahymenidae | Tetrahymena | Tetrahymena thermophila | ||
| 13192589 | 13192589 | PRJNA450343_P_NODE_11791_length_165_cov_0.879310_g11723_i0 | PRJNA450343 | 11791 | 165 | 0.87931 | 1.4508615 | Cryptosporidium viatorum | 1176757 | SAR_Eukaryotes | SAR_Eukaryotes | 113 | 6.240000000000001e-21 | NTclustered | gi|441431303|gb|JX978273.1| | 1176757 | g11723 | i0 | 98.438 | 16.6484848484848 | 64 | 1 | 59 | 0 | 1 | 64 | 1887 | 1824 | Cryptosporidium viatorum isolate Swec025 70 kDa heat shock protein (HSP70) gene, partial cds | blastn | 2747 | 113 | 1 | Eukaryota | Sar | Apicomplexa | Conoidasida | Eucoccidiorida | Cryptosporidiidae | Cryptosporidium | Cryptosporidium viatorum | ||
| 18290681 | 18290681 | PRJNA450343_P_NODE_11935_length_165_cov_0.879310_g11867_i0 | PRJNA450343 | 11935 | 165 | 0.87931 | 1.4508615 | Naviculales sp. | 2126271 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.66e-74 | NTclustered | gi|2633519340|gb|OR805654.1| | 2126271 | g11867 | i0 | 98.182 | 197.878787878788 | 165 | 3 | 100 | 0 | 1 | 165 | 121253 | 121417 | Naviculales sp. strain SZCZO2114 plastid, complete genome | blastn | 32650 | 289 | 1 | Eukaryota | Sar | Bacillariophyta | Bacillariophyceae | Naviculales | Naviculales sp. |
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);;