contig_metadata
8 rows where bioproject = "PRJNA1122875", tax_clade = "CRuMs" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4104830 | 4104830 | PRJNA1122875_P_NODE_42304_length_253_cov_1.711111_g42080_i0 | PRJNA1122875 | 42304 | 253 | 1.711111 | 4.32911083 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 468 | 1.92e-127 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g42080 | i0 | 100 | 78.1660079051383 | 253 | 0 | 100 | 0 | 1 | 253 | 21414 | 21666 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 19776 | 468 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 4105047 | 4105047 | PRJNA1122875_P_NODE_8304_length_567_cov_12.904858_g8086_i0 | PRJNA1122875 | 8304 | 567 | 12.904858 | 73.17054486 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 970 | 0 | NTclustered | gi|1200177731|gb|MF039365.1| | 190327 | g8086 | i0 | 97.544 | 34.2910052910053 | 570 | 9 | 100 | 4 | 1 | 567 | 2835 | 3402 | Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 19443 | 970 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 9205430 | 9205430 | PRJNA1122875_P_NODE_14128_length_443_cov_3.402703_g13904_i0 | PRJNA1122875 | 14128 | 443 | 3.402703 | 15.07397429 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 819 | 0 | NTclustered | gi|1200177731|gb|MF039365.1| | 190327 | g13904 | i0 | 100 | 63.510158013544 | 443 | 0 | 100 | 0 | 1 | 443 | 1770 | 1328 | Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 28135 | 819 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 10481284 | 10481284 | PRJNA1122875_P_NODE_3249_length_825_cov_11.702128_g3066_i0 | PRJNA1122875 | 3249 | 825 | 11.702128 | 96.542556 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 1507 | 0 | NTclustered | gi|1200177731|gb|MF039365.1| | 190327 | g3066 | i0 | 99.636 | 29.8242424242424 | 825 | 3 | 100 | 0 | 1 | 825 | 5063 | 4239 | Diphylleia rotans isolate D_NIES3764 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 24605 | 1507 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 13031263 | 13031263 | PRJNA1122875_P_NODE_2631_length_885_cov_3.060345_g2469_i0 | PRJNA1122875 | 2631 | 885 | 3.060345 | 27.08405325 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 1629 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g2469 | i0 | 99.887 | 54.6745762711864 | 885 | 1 | 100 | 0 | 1 | 885 | 16355 | 17239 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 48387 | 1629 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 15580408 | 15580408 | PRJNA1122875_P_NODE_24353_length_337_cov_1.166667_g24129_i0 | PRJNA1122875 | 24353 | 337 | 1.166667 | 3.93166779 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 617 | 2.4999999999999997e-172 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g24129 | i0 | 99.703 | 1.42433234421365 | 337 | 1 | 100 | 0 | 1 | 337 | 55497 | 55833 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 480 | 617 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 19403710 | 19403710 | PRJNA1122875_P_NODE_48756_length_246_cov_0.890173_g48532_i0 | PRJNA1122875 | 48756 | 246 | 0.890173 | 2.18982558 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 455 | 1.4500000000000002e-123 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g48532 | i0 | 100 | 2.54878048780488 | 246 | 0 | 100 | 0 | 1 | 246 | 29597 | 29352 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 627 | 455 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 24503634 | 24503634 | PRJNA1122875_P_NODE_38180_length_269_cov_1.010204_g37956_i0 | PRJNA1122875 | 38180 | 269 | 1.010204 | 2.71744876 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 497 | 2.63e-136 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g37956 | i0 | 100 | 71.1375464684015 | 269 | 0 | 100 | 0 | 1 | 269 | 17250 | 17518 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 19136 | 497 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans |
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);;