contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA884104" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3411023 | 3411023 | PRJNA884104_S_NODE_17783_length_477_cov_26.153465_g17043_i0 | PRJNA884104 | 17783 | 477 | 26.153465 | 124.75202805 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 281 | 5.44e-71 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g17043 | i0 | 80.939 | 4.73165618448637 | 362 | 63 | 75 | 6 | 50 | 408 | 395 | 37 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2257 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 5963628 | 5963628 | PRJNA884104_S_NODE_21005_length_440_cov_9.019074_g20262_i0 | PRJNA884104 | 21005 | 440 | 9.019074 | 39.6839256 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 337 | 1.0499999999999996e-87 | NTclustered | gi|268559799|ref|XM_002646027.1| | 6238 | g20262 | i0 | 87.671 | 68.5 | 292 | 32 | 66 | 4 | 9 | 298 | 1018 | 1307 | Caenorhabditis briggsae Protein CBG07939 (CBG07939), partial mRNA | blastn | 30140 | 337 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 5963973 | 5963973 | PRJNA884104_S_NODE_39025_length_331_cov_0.895349_g38282_i0 | PRJNA884104 | 39025 | 331 | 0.895349 | 2.96360519 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 63.9 | 1.44e-5 | NTclustered | gi|268574307|ref|XM_002642085.1| | 6238 | g38282 | i0 | 95 | 1.5226586102719 | 40 | 2 | 12 | 0 | 290 | 329 | 664 | 625 | Caenorhabditis briggsae Protein CBG18078 (CBG18078), partial mRNA | blastn | 504 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 11064800 | 11064800 | PRJNA884104_S_NODE_66069_length_256_cov_1.256831_g65326_i0 | PRJNA884104 | 66069 | 256 | 1.256831 | 3.21748736 | Necator americanus | 51031 | Nematoda | Nematoda | 75 | 4.97e-9 | NTclustered | gi|915267734|ref|XM_013445986.1| | 51031 | g65326 | i0 | 81.053 | 0.37109375 | 95 | 16 | 37 | 2 | 8 | 101 | 265 | 358 | Necator americanus uncharacterized protein (RB195_007271), partial mRNA | blastn | 95 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 12340798 | 12340798 | PRJNA884104_S_NODE_8990_length_673_cov_13.983333_g8288_i0 | PRJNA884104 | 8990 | 673 | 13.983333 | 94.10783109 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 161 | 1.0699999999999999e-34 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g8288 | i0 | 80.717 | 17.2912332838039 | 223 | 29 | 32 | 11 | 213 | 428 | 49 | 264 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 11637 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 19986843 | 19986843 | PRJNA884104_S_NODE_10296_length_629_cov_8.782374_g9582_i0 | PRJNA884104 | 10296 | 629 | 8.782374 | 55.24113246 | Pristionchus bulgaricus | 1486442 | Nematoda | Nematoda | 172 | 4.59e-38 | NTclustered | gi|610559349|gb|KJ395523.1| | 1486442 | g9582 | i0 | 81.532 | 7.34817170111288 | 222 | 27 | 34 | 11 | 213 | 427 | 49 | 263 | Pristionchus bulgaricus isolate sp18 ribosomal protein (rps-20) gene, partial cds | blastn | 4622 | 172 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus bulgaricus | |
| 21263263 | 21263263 | PRJNA884104_S_NODE_68017_length_251_cov_2.561798_g67274_i0 | PRJNA884104 | 68017 | 251 | 2.561798 | 6.43011298 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 165 | 2.8e-36 | NTclustered | gi|11095074|gb|AC084625.1|CBRG45C19 | 6238 | g67274 | i0 | 86.184 | 2.28685258964143 | 152 | 21 | 61 | 0 | 100 | 251 | 1389 | 1540 | Caenorhabditis briggsae cosmid G45C19, complete sequence | blastn | 574 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae |
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);;