contig_metadata
9 rows where bioproject = "PRJNA857143" and tax_clade = "CRuMs"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2119331 | 2119331 | PRJNA857143_S_NODE_25562_length_490_cov_2.832134_g24473_i0 | PRJNA857143 | 25562 | 490 | 2.832134 | 13.8774566 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 874 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g24473 | i0 | 100 | 56.8816326530612 | 473 | 0 | 97 | 0 | 18 | 490 | 16617 | 17089 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 27872 | 874 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 3395254 | 3395254 | PRJNA857143_S_NODE_943_length_1476_cov_6.605132_g740_i0 | PRJNA857143 | 943 | 1476 | 6.605132 | 97.49174832 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 2678 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g740 | i0 | 100 | 25.840108401084 | 1450 | 0 | 98 | 0 | 1 | 1450 | 44926 | 46375 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 38140 | 2678 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 9771502 | 9771502 | PRJNA857143_S_NODE_165788_length_255_cov_1.285714_g164695_i0 | PRJNA857143 | 165788 | 255 | 1.285714 | 3.2785707 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 472 | 1.5e-128 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g164695 | i0 | 100 | 91.4 | 255 | 0 | 100 | 0 | 1 | 255 | 17644 | 17390 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 23307 | 472 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 9771920 | 9771920 | PRJNA857143_S_NODE_21968_length_515_cov_2.739819_g20882_i0 | PRJNA857143 | 21968 | 515 | 2.739819 | 14.11006785 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 929 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g20882 | i0 | 99.225 | 34.9844660194175 | 516 | 2 | 100 | 2 | 1 | 515 | 49130 | 48616 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 18017 | 929 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 12322370 | 12322370 | PRJNA857143_S_NODE_136270_length_278_cov_1.024390_g135177_i0 | PRJNA857143 | 136270 | 278 | 1.02439 | 2.8478042 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 508 | 1.26e-139 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g135177 | i0 | 99.64 | 1 | 278 | 1 | 100 | 0 | 1 | 278 | 24414 | 24691 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 278 | 508 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 21246156 | 21246156 | PRJNA857143_S_NODE_39737_length_425_cov_6.647727_g38645_i0 | PRJNA857143 | 39737 | 425 | 6.647727 | 28.25283975 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 780 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g38645 | i0 | 99.765 | 70.0870588235294 | 425 | 1 | 100 | 0 | 1 | 425 | 44873 | 44449 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 29787 | 780 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 22519546 | 22519546 | PRJNA857143_S_NODE_103738_length_309_cov_1.343220_g102645_i0 | PRJNA857143 | 103738 | 309 | 1.34322 | 4.1505498 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 510 | 3.96e-140 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g102645 | i0 | 100 | 1.14239482200647 | 276 | 0 | 94 | 0 | 34 | 309 | 3040 | 2765 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 353 | 510 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 23796315 | 23796315 | PRJNA857143_S_NODE_50599_length_394_cov_4.595016_g49506_i0 | PRJNA857143 | 50599 | 394 | 4.595016 | 18.10436304 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 723 | 0 | NTclustered | gi|1016881912|ref|NC_029886.1| | 190327 | g49506 | i0 | 100 | 0.99238578680203 | 391 | 0 | 99 | 0 | 4 | 394 | 26370 | 25980 | Diphylleia rotans isolate NIES-3764 mitochondrion, complete genome | blastn | 391 | 723 | 1 | Eukaryota | CRuMs | Collodictyonidae | Diphylleia | Diphylleia rotans | |||||
| 30434561 | 30434561 | PRJNA857143_S_NODE_173513_length_251_cov_1.252809_g172420_i0 | PRJNA857143 | 173513 | 251 | 1.252809 | 3.14455059 | Diphylleia rotans | 190327 | Root_unresolved | Root_unresolved | 79 | 7.31e-15 | NR | YP_009245579.1 | 190327 | g172420 | i0 | 43 | 1.02788844621514 | 86 | 41 | 93.2 | 1 | 234 | 1 | 505 | 590 | YP_009245579.1 NADH dehydrogenase subunit 5 [Diphylleia rotans] | diamond | 258 | 79 | 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);;