contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA980587" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7333663 | 7333663 | PRJNA980587_P_NODE_6306_length_1143_cov_2.504673_g5786_i0 | PRJNA980587 | 6306 | 1143 | 2.504673 | 28.62841239 | Rosculus hawesi | 2231161 | SAR_Eukaryotes | SAR_Eukaryotes | 2061 | 0 | NTclustered | gi|1402550477|gb|MH488763.1| | 2231161 | g5786 | i0 | 99.214 | 18.5459317585302 | 1145 | 5 | 100 | 2 | 1 | 1143 | 12 | 1154 | Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence | blastn | 21198 | 2061 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus hawesi | ||||
| 8608290 | 8608290 | PRJNA980587_P_NODE_2327_length_1852_cov_33.892636_g2059_i1 | PRJNA980587 | 2327 | 1852 | 33.892636 | 627.69161872 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 326 | 1.02e-83 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g2059 | i1 | 75.06 | 32.6549676025918 | 834 | 141 | 51 | 49 | 851 | 1670 | 1747 | 967 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 60477 | 326 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 8608315 | 8608315 | PRJNA980587_P_NODE_25387_length_490_cov_14.916067_g24595_i0 | PRJNA980587 | 25387 | 490 | 14.916067 | 73.0887283 | Viridiuvalis adhaerens | 1977046 | SAR_Eukaryotes | SAR_Eukaryotes | 99 | 6.05e-16 | NTclustered | gi|1248454657|dbj|LC229572.1| | 1977046 | g24595 | i0 | 82.727 | 11.7673469387755 | 110 | 19 | 22 | 0 | 1 | 110 | 2850 | 2959 | Viridiuvalis adhaerens gene for 28S ribosomal RNA, partial sequence | blastn | 5766 | 99 | 1 | Eukaryota | Sar | Cercozoa | Chlorarachniophyceae | Viridiuvalis | Viridiuvalis adhaerens | ||||
| 11159321 | 11159321 | PRJNA980587_P_NODE_63529_length_284_cov_2.957346_g62736_i0 | PRJNA980587 | 63529 | 284 | 2.957346 | 8.39886264 | Rosculus sp. VDelafont-2023a | 3079709 | SAR_Eukaryotes | SAR_Eukaryotes | 518 | 2.15e-142 | NTclustered | gi|2589370978|gb|OR644361.1| | 3079709 | g62736 | i0 | 99.647 | 9.33802816901408 | 283 | 1 | 99 | 0 | 2 | 284 | 1677 | 1395 | Rosculus sp. VDelafont-2023a isolate AJ1 small subunit ribosomal RNA gene, partial sequence | blastn | 2652 | 518 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. VDelafont-2023a | ||||
| 14983238 | 14983238 | PRJNA980587_P_NODE_1692_length_2079_cov_9.729811_g1505_i0 | PRJNA980587 | 1692 | 2079 | 9.729811 | 202.28277069 | Rosculus sp. | 2231160 | SAR_Eukaryotes | SAR_Eukaryotes | 3064 | 0 | NTclustered | gi|1402550476|gb|MH488762.1| | 2231160 | g1505 | i0 | 93.451 | 27.965848965849 | 2092 | 93 | 99 | 30 | 2 | 2079 | 2082 | 21 | Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence | blastn | 58141 | 3064 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus sp. | ||||
| 16259177 | 16259177 | PRJNA980587_P_NODE_89613_length_244_cov_0.900585_g88820_i0 | PRJNA980587 | 89613 | 244 | 0.900585 | 2.1974274 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 279 | 9.27e-71 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g88820 | i0 | 87.347 | 28.2540983606557 | 245 | 30 | 100 | 1 | 1 | 244 | 2219 | 1975 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 6894 | 279 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 17533450 | 17533450 | PRJNA980587_P_NODE_31974_length_423_cov_7.845714_g31181_i0 | PRJNA980587 | 31974 | 423 | 7.845714 | 33.18737022 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 189 | 2.98e-43 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g31181 | i0 | 80.709 | 6.21040189125296 | 254 | 39 | 59 | 9 | 174 | 423 | 2836 | 2589 | Rosculus vulgaris isolate CCA sequence | blastn | 2627 | 189 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris | ||||
| 20082152 | 20082152 | PRJNA980587_P_NODE_38676_length_376_cov_6.584158_g37883_i0 | PRJNA980587 | 38676 | 376 | 6.584158 | 24.75643408 | Rosculus vulgaris | 2231165 | SAR_Eukaryotes | SAR_Eukaryotes | 357 | 6.77e-94 | NTclustered | gi|1402550474|gb|MH488760.1| | 2231165 | g37883 | i0 | 84.293 | 37.406914893617 | 382 | 42 | 100 | 13 | 1 | 376 | 2202 | 2571 | Rosculus vulgaris isolate CCA sequence | blastn | 14065 | 357 | 1 | Eukaryota | Sar | Cercozoa | Guttulinopsidae | Rosculus | Rosculus vulgaris |
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);;