contig_metadata
9 rows where bioproject = "PRJEB43370", tax_clade = "Sar" and tax_phylum = "Cercozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1334506 | 1334506 | PRJEB43370_P_NODE_1982_length_309_cov_1.584615_g1939_i0 | PRJEB43370 | 1982 | 309 | 1.584615 | 4.89646035 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 466 | 8.7e-127 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g1939 | i0 | 93.91 | 58.8381877022654 | 312 | 14 | 100 | 5 | 1 | 309 | 1769 | 2078 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 18181 | 466 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 1334541 | 1334541 | PRJEB43370_P_NODE_5042_length_201_cov_1.644737_g4999_i0 | PRJEB43370 | 5042 | 201 | 1.644737 | 3.30592137 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 176 | 9.94e-40 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g4999 | i0 | 87.261 | 47.2636815920398 | 157 | 17 | 78 | 3 | 3 | 158 | 2216 | 2370 | Rosculus vulgaris isolate CCA sequence | blastn | 9500 | 176 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 2610168 | 2610168 | PRJEB43370_P_NODE_843_length_475_cov_1.687793_g800_i0 | PRJEB43370 | 843 | 475 | 1.687793 | 8.01701675 | Chlorarachniophyceae sp. P314 | 467060 | SAR_Eukaryotes | SAR_Eukaryotes | 196 | 2.02e-45 | NTclustered | gi|220983378|dbj|AB453014.1| | 467060 | g800 | i0 | 77.249 | 41.72 | 378 | 59 | 79 | 17 | 90 | 463 | 1471 | 1117 | Chlorarachniophyceae sp. P314 gene for nuclear large subunit ribosomal RNA, partial sequence | blastn | 19817 | 196 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Chlorarachniophyceae sp. P314 | |||||
| 3886343 | 3886343 | PRJEB43370_P_NODE_6704_length_177_cov_1.625000_g6661_i0 | PRJEB43370 | 6704 | 177 | 1.625 | 2.87625 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 322 | 1.03e-83 | NTclustered | gi|238617630|gb|FJ973394.1| | 188950 | g6661 | i0 | 99.435 | 71.3559322033898 | 177 | 1 | 100 | 0 | 1 | 177 | 496 | 320 | Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds | blastn | 12630 | 322 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 11193305 | 11193305 | PRJEB43370_P_NODE_6349_length_182_cov_1.563910_g6306_i0 | PRJEB43370 | 6349 | 182 | 1.56391 | 2.8463162 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 89 | 6.58e-19 | NR | MES1909605.1 | 1215613 | g6306 | i0 | 86.7 | 4.48351648351648 | 45 | 6 | 74.2 | 0 | 47 | 181 | 3 | 47 | MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 816 | 89 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM | ||||||
| 17911781 | 17911781 | PRJEB43370_P_NODE_4875_length_204_cov_1.670968_g4832_i0 | PRJEB43370 | 4875 | 204 | 1.670968 | 3.40877472 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 294 | 2.68e-75 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g4832 | i0 | 96.133 | 16.3676470588235 | 181 | 6 | 88 | 1 | 23 | 202 | 3 | 183 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 3339 | 294 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 19185743 | 19185743 | PRJEB43370_P_NODE_8756_length_166_cov_1.230769_g8713_i0 | PRJEB43370 | 8756 | 166 | 1.230769 | 2.04307654 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 185 | 1.3099999999999999e-42 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g8713 | i0 | 87.5 | 9.52409638554217 | 168 | 12 | 100 | 8 | 1 | 166 | 2560 | 2720 | Rosculus vulgaris isolate CCA sequence | blastn | 1581 | 185 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 31803321 | 31803321 | PRJEB43370_P_NODE_5977_length_187_cov_1.405797_g5934_i0 | PRJEB43370 | 5977 | 187 | 1.405797 | 2.62884039 | Heteromita sp. PRA-74 | 323453 | SAR_Eukaryotes | SAR_Eukaryotes | 88.6 | 2.2e-19 | NR | ADK26624.1 | 323453 | g5934 | i0 | 64.5 | 1.98930481283422 | 62 | 22 | 99.5 | 0 | 1 | 186 | 185 | 246 | ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] | diamond | 372 | 88.6 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Heteromitidae | Heteromita | Heteromita sp. PRA-74 | |||
| 32531359 | 32531359 | PRJEB43370_P_NODE_1499_length_356_cov_2.960912_g1456_i0 | PRJEB43370 | 1499 | 356 | 2.960912 | 10.54084672 | Cercozoa sp. M6MM | 1215613 | SAR_Eukaryotes | SAR_Eukaryotes | 107 | 1.14e-25 | NR | MES1912576.1 | 1215613 | g1456 | i0 | 42 | 0.943820224719101 | 112 | 65 | 94.4 | 0 | 1 | 336 | 163 | 274 | MES1912576.1 hypothetical protein [Cercozoa sp. M6MM] | diamond | 336 | 107 | 1 | Eukaryota | Sar | Cercozoa | Cercozoa sp. M6MM |
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);;