contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA450632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 439489 | 439489 | PRJNA450632_P_NODE_23401_length_153_cov_1.016949_g23222_i0 | PRJNA450632 | 23401 | 153 | 1.016949 | 1.55593197 | Phytophthora cinnamomi | 4785 | SAR_Eukaryotes | SAR_Eukaryotes | 156 | 9.29e-34 | NTclustered | gi|2795032670|ref|XM_067933158.1| | 4785 | g23222 | i0 | 85.256 | 2.05228758169935 | 156 | 17 | 100 | 5 | 1 | 153 | 187 | 339 | Phytophthora cinnamomi Mitochondrial Carrier (MC) Family (IUM83_08765), partial mRNA | blastn | 314 | 156 | 1 | Eukaryota | Sar | Oomycota | Peronosporomycetes | Peronosporales | Peronosporaceae | Phytophthora | Phytophthora cinnamomi | ||
| 11295680 | 11295680 | PRJNA450632_P_NODE_22309_length_157_cov_1.459016_g22130_i0 | PRJNA450632 | 22309 | 157 | 1.459016 | 2.29065512 | Tribonema | 2980 | SAR_Eukaryotes | SAR_Eukaryotes | 274 | 2.54e-69 | NTclustered | gi|176113|gb|M55286.1|TBNRR16S | 2981 | g22130 | i0 | 98.089 | 100.796178343949 | 157 | 3 | 100 | 0 | 1 | 157 | 766 | 922 | Tribonema aequale 16S ribosomal (small subunit) RNA | blastn | 15825 | 274 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema aequale | |||
| 11918102 | 11918102 | PRJNA450632_P_NODE_19710_length_170_cov_1.474074_g19531_i0 | PRJNA450632 | 19710 | 170 | 1.474074 | 2.5059258 | Tribonema sp. | 2679974 | SAR_Eukaryotes | SAR_Eukaryotes | 281 | 1.67e-71 | NTclustered | gi|2518133535|gb|OQ243223.1| | 2679974 | g19531 | i0 | 96.471 | 23.2411764705882 | 170 | 6 | 100 | 0 | 1 | 170 | 6154 | 5985 | Tribonema sp. strain GXU-A10 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and 28S-18S ribosomal RNA intergenic spacer, complete sequence | blastn | 3951 | 281 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema sp. | |||
| 13846060 | 13846060 | PRJNA450632_P_NODE_16051_length_196_cov_0.975155_g15872_i0 | PRJNA450632 | 16051 | 196 | 0.975155 | 1.9113038 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 298 | 1.97e-76 | NTclustered | gi|2307923332|ref|NC_066457.1| | 3016 | g15872 | i0 | 94.33 | 148.867346938776 | 194 | 11 | 99 | 0 | 3 | 196 | 76731 | 76538 | Sargassum fulvellum chloroplast, complete genome | blastn | 29178 | 300 | 0.993333333333333 | Eukaryota | Sar | Phaeophyceae | Fucales | Sargassaceae | Sargassum | Sargassum fulvellum | |||
| 13846082 | 13846082 | PRJNA450632_P_NODE_21231_length_162_cov_1.322835_g21052_i0 | PRJNA450632 | 21231 | 162 | 1.322835 | 2.1429927 | Tribonema | 2980 | SAR_Eukaryotes | SAR_Eukaryotes | 289 | 9.44e-74 | NTclustered | gi|2286039|emb|Y07979.1| | 2981 | g21052 | i0 | 98.773 | 99.6172839506173 | 163 | 1 | 100 | 1 | 1 | 162 | 1320 | 1158 | T.aequale 28S rRNA gene and ITS2 DNA | blastn | 16138 | 289 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema aequale | |||
| 17016645 | 17016645 | PRJNA450632_P_NODE_19154_length_174_cov_1.100719_g18975_i0 | PRJNA450632 | 19154 | 174 | 1.100719 | 1.91525106 | Tribonema aequale | 2981 | SAR_Eukaryotes | SAR_Eukaryotes | 311 | 2.19e-80 | NTclustered | gi|2286039|emb|Y07979.1| | 2981 | g18975 | i0 | 98.851 | 99.1666666666667 | 174 | 2 | 100 | 0 | 1 | 174 | 912 | 739 | T.aequale 28S rRNA gene and ITS2 DNA | blastn | 17255 | 311 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema aequale | |||
| 22769468 | 22769468 | PRJNA450632_P_NODE_14958_length_205_cov_1.294118_g14779_i0 | PRJNA450632 | 14958 | 205 | 1.294118 | 2.6529419 | Tribonematales | 2978 | SAR_Eukaryotes | SAR_Eukaryotes | 374 | 3.3599999999999997e-99 | NTclustered | gi|1591446687|gb|MK005105.1| | 303373 | g14779 | i0 | 99.512 | 167.453658536585 | 205 | 1 | 100 | 0 | 1 | 205 | 192 | 396 | Tribonema affine isolate S2F4-16 23S ribosomal RNA gene, partial sequence; chloroplast | blastn | 34328 | 374 | 1 | Eukaryota | Sar | Xanthophyceae | Tribonematales | Tribonemataceae | Tribonema | Tribonema affine |
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);;