contig_metadata
7 rows where bioproject = "PRJNA993416", tax_clade = "Opisthokonta" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4803740 | 4803740 | PRJNA993416_P_NODE_15124_length_244_cov_0.900585_g15019_i0 | PRJNA993416 | 15124 | 244 | 0.900585 | 2.1974274 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 451 | 1.86e-122 | NTclustered | gi|1831513325|ref|NM_001380321.1| | 6239 | g15019 | i0 | 100 | 7.32377049180328 | 244 | 0 | 100 | 0 | 1 | 244 | 267 | 24 | Caenorhabditis elegans Phosphate transporter (pitr-1), partial mRNA | blastn | 1787 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 11179383 | 11179383 | PRJNA993416_P_NODE_9329_length_280_cov_1.333333_g9224_i0 | PRJNA993416 | 9329 | 280 | 1.333333 | 3.7333324 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 510 | 3.54e-140 | NTclustered | gi|1734327237|ref|NM_067046.4| | 6239 | g9224 | i0 | 99.643 | 3.11428571428571 | 280 | 0 | 100 | 1 | 1 | 280 | 3035 | 2757 | Caenorhabditis elegans Ribosomal protein S6 kinase beta (rsks-1), mRNA | blastn | 872 | 510 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16278683 | 16278683 | PRJNA993416_P_NODE_15613_length_242_cov_1.822485_g15508_i0 | PRJNA993416 | 15613 | 242 | 1.822485 | 4.4104137 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 448 | 2.3799999999999995e-121 | NTclustered | gi|412975849|emb|FO080163.2| | 6239 | g15508 | i0 | 100 | 3.20661157024793 | 242 | 0 | 100 | 0 | 1 | 242 | 6136 | 6377 | Caenorhabditis elegans Cosmid B0303, complete sequence | blastn | 776 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18827502 | 18827502 | PRJNA993416_P_NODE_10015_length_274_cov_1.373134_g9910_i0 | PRJNA993416 | 10015 | 274 | 1.373134 | 3.76238716 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 507 | 4.47e-139 | NTclustered | gi|1972299397|ref|NM_001392708.1| | 6239 | g9910 | i0 | 100 | 3.86131386861314 | 274 | 0 | 100 | 0 | 1 | 274 | 354 | 627 | Caenorhabditis elegans Mediator of RNA polymerase II transcription subunit 17 (mdt-17), mRNA | blastn | 1058 | 507 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 18827609 | 18827609 | PRJNA993416_P_NODE_15615_length_242_cov_1.822485_g15510_i0 | PRJNA993416 | 15615 | 242 | 1.822485 | 4.4104137 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 448 | 2.3799999999999995e-121 | NTclustered | gi|1845969912|ref|NM_001262221.3| | 6239 | g15510 | i0 | 100 | 4 | 242 | 0 | 100 | 0 | 1 | 242 | 370 | 129 | Caenorhabditis elegans Protein zwilch homolog (zwl-1), mRNA | blastn | 968 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25201912 | 25201912 | PRJNA993416_P_NODE_12540_length_251_cov_0.865169_g12435_i0 | PRJNA993416 | 12540 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.1499999999999996e-124 | NTclustered | gi|687865887|emb|LK928299.1| | 6239 | g12435 | i0 | 99.603 | 10.0398406374502 | 252 | 0 | 100 | 1 | 1 | 251 | 2310 | 2561 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000178 | blastn | 2520 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 31992150 | 31992150 | PRJNA993416_P_NODE_14418_length_246_cov_0.878613_g14313_i0 | PRJNA993416 | 14418 | 246 | 0.878613 | 2.16138798 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 4.9e-25 | NR | CAD22112.1 | 6317 | g14313 | i0 | 69.3 | 365.390243902439 | 75 | 23 | 91.5 | 0 | 2 | 226 | 114 | 188 | CAD22112.1 tubulin, partial [Ostertagia ostertagi] | diamond | 89886 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi |
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);;