contig_metadata
12 rows where bioproject = "PRJNA889065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 863317 | 863317 | PRJNA889065_S_NODE_15481_length_247_cov_1.352941_g15243_i0 | PRJNA889065 | 15481 | 247 | 1.352941 | 3.34176427 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 457 | 4.05e-124 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g15243 | i0 | 100 | 34.1052631578947 | 247 | 0 | 100 | 0 | 1 | 247 | 344 | 590 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 8424 | 457 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2138780 | 2138780 | PRJNA889065_S_NODE_18782_length_224_cov_28.861878_g18544_i0 | PRJNA889065 | 18782 | 224 | 28.861878 | 64.65060672 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 414 | 2.1999999999999996e-111 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g18544 | i0 | 100 | 57.2723214285714 | 224 | 0 | 100 | 0 | 1 | 224 | 2911 | 2688 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 12829 | 414 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 2517804 | 2517804 | PRJNA889065_S_NODE_5182_length_412_cov_15.021680_g4944_i0 | PRJNA889065 | 5182 | 412 | 15.02168 | 61.8893216 | Bodomorpha | 188949 | SAR_Eukaryotes | SAR_Eukaryotes | 754 | 0 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g4944 | i0 | 99.757 | 100.507281553398 | 412 | 0 | 100 | 1 | 1 | 412 | 1031 | 621 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 41409 | 754 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 4691687 | 4691687 | PRJNA889065_S_NODE_11524_length_283_cov_2.333333_g11286_i0 | PRJNA889065 | 11524 | 283 | 2.333333 | 6.60333239 | Cercomonas agilis | 310805 | SAR_Eukaryotes | SAR_Eukaryotes | 207 | 5.27e-49 | NTclustered | gi|58414956|gb|AY748813.1| | 310805 | g11286 | i0 | 86.316 | 93.4310954063604 | 190 | 26 | 67 | 0 | 1 | 190 | 39 | 228 | Cercomonas agilis polyubiquitin (UBQ) gene, partial cds | blastn | 26441 | 207 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas agilis | |||
| 7241501 | 7241501 | PRJNA889065_S_NODE_31266_length_172_cov_1.426357_g31028_i0 | PRJNA889065 | 31266 | 172 | 1.426357 | 2.45333404 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 318 | 1.2899999999999999e-82 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g31028 | i0 | 100 | 100.901162790698 | 172 | 0 | 100 | 0 | 1 | 172 | 1323 | 1152 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 17355 | 318 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 9791267 | 9791267 | PRJNA889065_S_NODE_21968_length_207_cov_4.176829_g21730_i0 | PRJNA889065 | 21968 | 207 | 4.176829 | 8.64603603 | Paracercomonas marina | 372086 | SAR_Eukaryotes | SAR_Eukaryotes | 350 | 5.74e-92 | NTclustered | gi|88792583|gb|DQ386164.1| | 372086 | g21730 | i0 | 97.101 | 29 | 207 | 6 | 100 | 0 | 1 | 207 | 1988 | 2194 | Paracercomonas marina 28S ribosomal RNA gene, partial sequence | blastn | 6003 | 350 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Paracercomonas | Paracercomonas marina | |||
| 12342532 | 12342532 | PRJNA889065_S_NODE_4110_length_454_cov_6.944039_g3876_i0 | PRJNA889065 | 4110 | 454 | 6.944039 | 31.52593706 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 826 | 0 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g3876 | i0 | 99.778 | 68.4030837004405 | 450 | 1 | 99 | 0 | 1 | 450 | 1665 | 2114 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 31055 | 826 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 14891412 | 14891412 | PRJNA889065_S_NODE_5732_length_393_cov_13.225714_g5494_i0 | PRJNA889065 | 5732 | 393 | 13.225714 | 51.97705602 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 568 | 3.02e-157 | NTclustered | gi|224996436|gb|FJ654268.1| | 188950 | g5494 | i0 | 97.329 | 33.0712468193384 | 337 | 4 | 85 | 2 | 61 | 393 | 2 | 337 | Bodomorpha minima 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 12997 | 568 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16166028 | 16166028 | PRJNA889065_S_NODE_14493_length_254_cov_11.014218_g14255_i0 | PRJNA889065 | 14493 | 254 | 11.014218 | 27.97611372 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 470 | 5.37e-128 | NTclustered | gi|238617602|gb|FJ973377.1| | 188950 | g14255 | i0 | 100 | 31.3582677165354 | 254 | 0 | 100 | 0 | 1 | 254 | 2410 | 2157 | Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence | blastn | 7965 | 470 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 16166144 | 16166144 | PRJNA889065_S_NODE_5653_length_396_cov_3.861190_g5415_i0 | PRJNA889065 | 5653 | 396 | 3.86119 | 15.2903124 | Esquamula lacrimiformis | 1176540 | SAR_Eukaryotes | SAR_Eukaryotes | 320 | 9.41e-83 | NTclustered | gi|409971369|dbj|AB714271.1| | 1176540 | g5415 | i0 | 82.642 | 52.780303030303 | 386 | 43 | 97 | 16 | 14 | 396 | 4039 | 3675 | Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence | blastn | 20901 | 320 | 1 | Eukaryota | Sar | Cercozoa | Imbricatea | Thaumatomonadida | Esquamula | Esquamula lacrimiformis | |||
| 19989950 | 19989950 | PRJNA889065_S_NODE_17776_length_230_cov_5.631016_g17538_i0 | PRJNA889065 | 17776 | 230 | 5.631016 | 12.9513368 | Bodomorpha minima | 188950 | SAR_Eukaryotes | SAR_Eukaryotes | 425 | 1.05e-114 | NTclustered | gi|33309639|gb|AF411276.1| | 188950 | g17538 | i0 | 100 | 83.3 | 230 | 0 | 100 | 0 | 1 | 230 | 1687 | 1458 | Bodomorpha minima 18S ribosomal RNA gene, complete sequence | blastn | 19159 | 425 | 1 | Eukaryota | Sar | Cercozoa | Glissomonadida | Viridiraptoridae | Bodomorpha | Bodomorpha minima | |||
| 21644366 | 21644366 | PRJNA889065_S_NODE_28937_length_179_cov_3.463235_g28699_i0 | PRJNA889065 | 28937 | 179 | 3.463235 | 6.19919065 | Cercomonadidae | 45108 | SAR_Eukaryotes | SAR_Eukaryotes | 331 | 1.74e-86 | NTclustered | gi|33309627|gb|AF411270.1| | 100933 | g28699 | i0 | 100 | 99.9888268156425 | 179 | 0 | 100 | 0 | 1 | 179 | 1619 | 1441 | Cercomonas longicauda 18S ribosomal RNA gene, complete sequence | blastn | 17898 | 331 | 1 | Eukaryota | Sar | Cercozoa | Cercomonadida | Cercomonadidae | Cercomonas | Cercomonas longicauda |
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);;