contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Foraminifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5467652 | 5467652 | PRJNA168635_P_NODE_15905_length_201_cov_1.105263_g15489_i0 | PRJNA168635 | 15905 | 201 | 1.105263 | 2.22157863 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 67.6 | 6.24e-7 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g15489 | i0 | 100 | 1.19402985074627 | 36 | 0 | 18 | 0 | 1 | 36 | 117 | 152 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 240 | 67.6 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata | |||
| 5467668 | 5467668 | PRJNA168635_P_NODE_16685_length_196_cov_1.142857_g16269_i0 | PRJNA168635 | 16685 | 196 | 1.142857 | 2.23999972 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.68e-7 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g16269 | i0 | 100 | 0.346938775510204 | 37 | 0 | 19 | 0 | 1 | 37 | 116 | 152 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 68 | 69.4 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata | |||
| 8706965 | 8706965 | PRJNA168635_P_NODE_18267_length_188_cov_3.633094_g17851_i0 | PRJNA168635 | 18267 | 188 | 3.633094 | 6.83021672 | Psammophaga | 164096 | SAR_Eukaryotes | SAR_Eukaryotes | 195 | 2.53e-45 | NTclustered | gi|345107630|emb|FR754392.1| | 944412 | g17851 | i0 | 86.387 | 97.6170212765958 | 191 | 11 | 99 | 11 | 1 | 187 | 45 | 224 | Psammophaga sp. 12325 partial 18S rRNA gene, isolate 12325, clone 26 | blastn | 18352 | 196 | 0.994897959183674 | Eukaryota | Sar | Foraminifera | Psammophaga | Psammophaga sp. 12325 | |||||
| 10568427 | 10568427 | PRJNA168635_P_NODE_16009_length_200_cov_2.238411_g15593_i0 | PRJNA168635 | 16009 | 200 | 2.238411 | 4.476822 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.73e-7 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g15593 | i0 | 100 | 0.345 | 37 | 0 | 19 | 0 | 1 | 37 | 116 | 152 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 69 | 69.4 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata | |||
| 11843025 | 11843025 | PRJNA168635_P_NODE_17670_length_191_cov_1.098592_g17254_i0 | PRJNA168635 | 17670 | 191 | 1.098592 | 2.09831072 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.63e-7 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g17254 | i0 | 93.478 | 0.413612565445026 | 46 | 3 | 24 | 0 | 2 | 47 | 117 | 162 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 79 | 69.4 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata | |||
| 14393676 | 14393676 | PRJNA168635_P_NODE_28372_length_166_cov_0.820513_g27956_i0 | PRJNA168635 | 28372 | 166 | 0.820513 | 1.36205158 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 60.2 | 8.31e-5 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g27956 | i0 | 97.222 | 0.216867469879518 | 36 | 0 | 21 | 1 | 132 | 166 | 152 | 117 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 36 | 60.2 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata | |||
| 20765884 | 20765884 | PRJNA168635_P_NODE_14237_length_214_cov_1.157576_g13821_i0 | PRJNA168635 | 14237 | 214 | 1.157576 | 2.47721264 | Bulimina marginata | 313259 | SAR_Eukaryotes | SAR_Eukaryotes | 69.4 | 1.87e-7 | NTclustered | gi|528530886|emb|HG316295.1| | 313259 | g13821 | i0 | 100 | 0.327102803738318 | 37 | 0 | 17 | 0 | 1 | 37 | 116 | 152 | Bulimina marginata partial mRNA for Rps2, isolate buli01, clone UN09088 | blastn | 70 | 69.4 | 1 | Eukaryota | Sar | Foraminifera | Rotaliida | Buliminidae | Bulimina | Bulimina marginata |
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);;