contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB75230" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1410565 | 1410565 | PRJEB75230_P_NODE_119222_length_251_cov_0.865169_g119040_i0 | PRJEB75230 | 119222 | 251 | 0.865169 | 2.17157419 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 62.1 | 3.78e-5 | NTclustered | gi|687022689|emb|LM525603.1| | 174720 | g119040 | i0 | 97.222 | 0.143426294820717 | 36 | 1 | 14 | 0 | 206 | 241 | 115401 | 115436 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000015 | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 1411435 | 1411435 | PRJEB75230_P_NODE_18682_length_391_cov_1.327044_g18500_i0 | PRJEB75230 | 18682 | 391 | 1.327044 | 5.18874204 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 54.7 | 0.01 | NTclustered | gi|268576584|ref|XM_002643226.1| | 6238 | g18500 | i0 | 100 | 0.0741687979539642 | 29 | 0 | 7 | 0 | 159 | 187 | 128 | 100 | Caenorhabditis briggsae Protein CBG08144 (CBG08144), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 3963717 | 3963717 | PRJEB75230_P_NODE_63824_length_295_cov_1.387387_g63642_i0 | PRJEB75230 | 63824 | 295 | 1.387387 | 4.09279165 | Loa loa | 7209 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|312092089|ref|XM_003147166.1| | 7209 | g63642 | i0 | 100 | 0.0983050847457627 | 29 | 0 | 10 | 0 | 264 | 292 | 147 | 175 | Loa loa hypothetical protein partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 5240677 | 5240677 | PRJEB75230_P_NODE_9845_length_473_cov_18.597500_g9663_i0 | PRJEB75230 | 9845 | 473 | 18.5975 | 87.966175 | Pristionchus pauli | 376545 | Nematoda | Nematoda | 281 | 5.39e-71 | NTclustered | gi|150982019|gb|EF634598.1| | 376545 | g9663 | i0 | 80.939 | 4.2938689217759 | 362 | 63 | 76 | 6 | 67 | 425 | 37 | 395 | Pristionchus pauli large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 2031 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pauli | |
| 6514975 | 6514975 | PRJEB75230_P_NODE_186066_length_226_cov_2.411765_g185884_i0 | PRJEB75230 | 186066 | 226 | 2.411765 | 5.4505889 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 204 | 5.25e-48 | NTclustered | gi|687022656|emb|LM525570.1| | 174720 | g185884 | i0 | 86.486 | 78.2433628318584 | 185 | 25 | 82 | 0 | 42 | 226 | 200443 | 200627 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000005 | blastn | 17683 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 12890493 | 12890493 | PRJEB75230_P_NODE_23751_length_369_cov_1.250000_g23569_i0 | PRJEB75230 | 23751 | 369 | 1.25 | 4.6125 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.035 | NTclustered | gi|687865584|emb|LK927629.1| | 6239 | g23569 | i0 | 96.774 | 0.168021680216802 | 31 | 1 | 8 | 0 | 292 | 322 | 161885 | 161855 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0000011 | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 15438337 | 15438337 | PRJEB75230_P_NODE_114573_length_253_cov_1.283333_g114391_i0 | PRJEB75230 | 114573 | 253 | 1.283333 | 3.24683249 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|351060467|emb|FO080963.1| | 6239 | g114391 | i0 | 94.286 | 0.276679841897233 | 35 | 1 | 14 | 1 | 129 | 163 | 60372 | 60339 | Caenorhabditis elegans YAC Y23H5B, complete sequence | blastn | 70 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16713843 | 16713843 | PRJEB75230_P_NODE_40534_length_327_cov_1.204724_g40352_i0 | PRJEB75230 | 40534 | 327 | 1.204724 | 3.93944748 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 211 | 4.79e-50 | NTclustered | gi|2445372511|ref|XM_053729906.1| | 31234 | g40352 | i0 | 82.377 | 17.045871559633 | 244 | 41 | 74 | 2 | 1 | 243 | 631 | 873 | Caenorhabditis remanei uncharacterized protein (GCK72_013604), partial mRNA | blastn | 5574 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 17987455 | 17987455 | PRJEB75230_P_NODE_114595_length_253_cov_1.283333_g114413_i0 | PRJEB75230 | 114595 | 253 | 1.283333 | 3.24683249 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|690019424|emb|LM526939.1| | 174720 | g114413 | i0 | 100 | 0.221343873517787 | 28 | 0 | 11 | 0 | 142 | 169 | 4653 | 4680 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0001279 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 23948714 | 23948714 | PRJEB75230_P_NODE_7579_length_520_cov_9.955257_g7397_i0 | PRJEB75230 | 7579 | 520 | 9.955257 | 51.7673364 | Pristionchus | 54125 | Nematoda | Nematoda | 154 | 1.36e-32 | NTclustered | gi|524845312|gb|KC819366.1| | 1355913 | g7397 | i0 | 80.18 | 22.3673076923077 | 222 | 30 | 41 | 11 | 68 | 282 | 49 | 263 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 20 (rps-20) mRNA, partial cds | blastn | 11631 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus |
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);;