contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6821240 | 6821240 | PRJNA473201_P_NODE_27986_length_372_cov_3.096990_g27244_i0 | PRJNA473201 | 27986 | 372 | 3.09699 | 11.5208028 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 161 | 5.63e-35 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g27244 | i0 | 80.717 | 28.502688172043 | 223 | 29 | 58 | 11 | 63 | 278 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 10603 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 10648077 | 10648077 | PRJNA473201_P_NODE_65189_length_252_cov_11.960894_g64447_i0 | PRJNA473201 | 65189 | 252 | 11.960894 | 30.14145288 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|687865727|emb|LK927732.1| | 6239 | g64447 | i0 | 100 | 0.23015873015873 | 29 | 0 | 12 | 0 | 222 | 250 | 79462 | 79434 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000178 | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 10648428 | 10648428 | PRJNA473201_P_NODE_82749_length_242_cov_0.911243_g82007_i0 | PRJNA473201 | 82749 | 242 | 0.911243 | 2.20520806 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 87.9 | 5.98e-13 | NTclustered | gi|150982147|gb|EF634662.1| | 452809 | g82007 | i0 | 86.25 | 0.611570247933884 | 80 | 11 | 33 | 0 | 163 | 242 | 410 | 331 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 148 | 87.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 14473312 | 14473312 | PRJNA473201_P_NODE_84712_length_241_cov_0.916667_g83970_i0 | PRJNA473201 | 84712 | 241 | 0.916667 | 2.20916747 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 446 | 8.519999999999999e-121 | NTclustered | gi|1831511604|ref|NM_001268223.3| | 6239 | g83970 | i0 | 100 | 6.37344398340249 | 241 | 0 | 100 | 0 | 1 | 241 | 1116 | 876 | Caenorhabditis elegans uncharacterized protein (brp-1), partial mRNA | blastn | 1536 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15746373 | 15746373 | PRJNA473201_P_NODE_33513_length_342_cov_28.334572_g32771_i0 | PRJNA473201 | 33513 | 342 | 28.334572 | 96.90423624 | Philometra sp. HZ-2022 | 3016125 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|2416169854|gb|OM469015.1| | 3016125 | g32771 | i0 | 100 | 0.087719298245614 | 30 | 0 | 9 | 0 | 77 | 106 | 5557 | 5586 | Philometra sp. HZ-2022 mitochondrion, complete genome | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Philometridae | Philometra | Philometra sp. HZ-2022 | |
| 17021800 | 17021800 | PRJNA473201_P_NODE_73594_length_247_cov_0.885057_g72852_i0 | PRJNA473201 | 73594 | 247 | 0.885057 | 2.18609079 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|687866048|emb|LK927941.1| | 6239 | g72852 | i0 | 100 | 0.340080971659919 | 28 | 0 | 11 | 0 | 47 | 74 | 3614 | 3641 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000060 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19569471 | 19569471 | PRJNA473201_P_NODE_35756_length_333_cov_1.180769_g35014_i0 | PRJNA473201 | 35756 | 333 | 1.180769 | 3.93196077 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 616 | 8.87e-172 | NTclustered | gi|1972264646|ref|NM_066119.9| | 6239 | g35014 | i0 | 100 | 93.3663663663664 | 333 | 0 | 100 | 0 | 1 | 333 | 1177 | 845 | Caenorhabditis elegans Elongation factor 1-alpha (eef-1A.1), mRNA | blastn | 31091 | 616 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 24669533 | 24669533 | PRJNA473201_P_NODE_18060_length_467_cov_5.177665_g17318_i0 | PRJNA473201 | 18060 | 467 | 5.177665 | 24.17969555 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 292 | 2.4599999999999993e-74 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g17318 | i0 | 81.492 | 4.83083511777302 | 362 | 61 | 77 | 6 | 62 | 420 | 37 | 395 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2256 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli |
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);;