contig_metadata
17 rows where bioproject = "PRJNA290839", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 372906 | 372906 | PRJNA290839_P_NODE_1541_length_243_cov_0.917647_g1520_i0 | PRJNA290839 | 1541 | 243 | 0.917647 | 2.22988221 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 274 | 4.29e-69 | NTclustered | gi|2158425340|ref|XM_045242542.1| | 6238 | g1520 | i0 | 91.089 | 0.831275720164609 | 202 | 18 | 83 | 0 | 30 | 231 | 396 | 195 | Caenorhabditis briggsae Protein CBG15099 (CBG15099), partial mRNA | blastn | 202 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 10576830 | 10576830 | PRJNA290839_P_NODE_1389_length_246_cov_0.901734_g1368_i0 | PRJNA290839 | 1389 | 246 | 0.901734 | 2.21826564 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 244 | 3.42e-60 | NTclustered | gi|2158425965|ref|XM_045244938.1| | 6238 | g1368 | i0 | 93.827 | 0.776422764227642 | 162 | 10 | 78 | 0 | 85 | 246 | 1234 | 1073 | Caenorhabditis briggsae Protein CBG03843 (CBG03843), partial mRNA | blastn | 191 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 10576831 | 10576831 | PRJNA290839_P_NODE_1589_length_243_cov_0.900000_g1568_i0 | PRJNA290839 | 1589 | 243 | 0.9 | 2.187 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 154 | 5.84e-33 | NTclustered | gi|12958081|gb|AC090416.1|AC090416 | 6238 | g1568 | i0 | 86.62 | 13.5473251028807 | 142 | 16 | 58 | 3 | 103 | 242 | 8310 | 8170 | Caenorhabditis briggsae cosmid CB042D07, complete sequence | blastn | 3292 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 16950284 | 16950284 | PRJNA290839_P_NODE_1114_length_251_cov_0.870787_g1093_i0 | PRJNA290839 | 1114 | 251 | 0.870787 | 2.18567537 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 420 | 5.41e-113 | NTclustered | gi|268561065|ref|XM_002646310.1| | 6238 | g1093 | i0 | 96.813 | 21 | 251 | 8 | 100 | 0 | 1 | 251 | 19135 | 19385 | Caenorhabditis briggsae Protein CBR-UNC-89 (Cbr-unc-89), partial mRNA | blastn | 5271 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 16950288 | 16950288 | PRJNA290839_P_NODE_1254_length_249_cov_0.863636_g1233_i0 | PRJNA290839 | 1254 | 249 | 0.863636 | 2.15045364 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 316 | 7.239999999999998e-82 | NTclustered | gi|2158430986|ref|XM_045244195.1| | 6238 | g1233 | i0 | 95.025 | 0.807228915662651 | 201 | 10 | 81 | 0 | 1 | 201 | 87 | 287 | Caenorhabditis briggsae Protein CBG09910 (CBG09910), partial mRNA | blastn | 201 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 16950290 | 16950290 | PRJNA290839_P_NODE_1354_length_247_cov_0.890805_g1333_i0 | PRJNA290839 | 1354 | 247 | 0.890805 | 2.20028835 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 76.8 | 1.32e-9 | NTclustered | gi|13129527|gb|AC090524.1|AC090524 | 6238 | g1333 | i0 | 91.228 | 1.08906882591093 | 57 | 4 | 23 | 1 | 89 | 144 | 85127 | 85071 | Caenorhabditis briggsae cosmid CB019H23, complete sequence | blastn | 269 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 19498814 | 19498814 | PRJNA290839_P_NODE_1176_length_250_cov_0.875706_g1155_i0 | PRJNA290839 | 1176 | 250 | 0.875706 | 2.189265 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 148 | 2.8099999999999993e-31 | NTclustered | gi|2158426460|ref|XM_045236905.1| | 6238 | g1155 | i0 | 95.652 | 0.368 | 92 | 4 | 37 | 0 | 86 | 177 | 709 | 800 | Caenorhabditis briggsae Protein CBR-UNC-14 (Cbr-unc-14), partial mRNA | blastn | 92 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 22049331 | 22049331 | PRJNA290839_P_NODE_1538_length_243_cov_0.917647_g1517_i0 | PRJNA290839 | 1538 | 243 | 0.917647 | 2.22988221 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 303 | 5.48e-78 | NTclustered | gi|11545986|gb|AC087075.1|AC087075 | 6238 | g1517 | i0 | 95.288 | 1.50205761316872 | 191 | 9 | 79 | 0 | 52 | 242 | 1588 | 1398 | Caenorhabditis briggsae cosmid CB023K10, complete sequence | blastn | 365 | 303 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 23324951 | 23324951 | PRJNA290839_P_NODE_1239_length_249_cov_0.875000_g1218_i0 | PRJNA290839 | 1239 | 249 | 0.875 | 2.17875 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 250 | 7.4499999999999995e-62 | NTclustered | gi|95831921|gb|DQ498827.1| | 6238 | g1218 | i0 | 86.441 | 1.51004016064257 | 236 | 22 | 94 | 7 | 1 | 235 | 59674 | 59448 | Caenorhabditis briggsae clone BAC RP94-13P22, complete sequence | blastn | 376 | 250 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 27010806 | 27010806 | PRJNA290839_P_NODE_1102_length_251_cov_0.876404_g1081_i0 | PRJNA290839 | 1102 | 251 | 0.876404 | 2.19977404 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 105 | 3.76e-25 | NR | EFP00214.1 | 31234 | g1081 | i0 | 92.6 | 0.645418326693227 | 54 | 4 | 64.5 | 0 | 89 | 250 | 1 | 54 | EFP00214.1 CRE-SRJ-7 protein [Caenorhabditis remanei] | diamond | 162 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 27516559 | 27516559 | PRJNA290839_P_NODE_1283_length_248_cov_0.885714_g1262_i0 | PRJNA290839 | 1283 | 248 | 0.885714 | 2.19657072 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 44.3 | 0.0115 | NR | XP_024499784.1 | 34506 | g1262 | i0 | 32.9 | 1.33064516129032 | 73 | 46 | 84.7 | 1 | 237 | 28 | 838 | 910 | XP_024499784.1 Insulin-like growth factor binding protein,N-terminal domain-containing protein [Strongyloides ratti] | diamond | 330 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 27611396 | 27611396 | PRJNA290839_P_NODE_604_length_330_cov_1.042802_g583_i0 | PRJNA290839 | 604 | 330 | 1.042802 | 3.4412466 | Pristionchus mayeri | 1317129 | Nematoda | Nematoda | 86.7 | 2.38e-17 | NR | GMR59452.1 | 1317129 | g583 | i0 | 38.5 | 0.990909090909091 | 109 | 67 | 99.1 | 0 | 2 | 328 | 34 | 142 | GMR59452.1 hypothetical protein PMAYCL1PPCAC_29647, partial [Pristionchus mayeri] | diamond | 327 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus mayeri | |
| 29789735 | 29789735 | PRJNA290839_P_NODE_1511_length_244_cov_0.912281_g1490_i0 | PRJNA290839 | 1511 | 244 | 0.912281 | 2.22596564 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 95.9 | 7.56e-21 | NR | PIC14317.1 | 1611254 | g1490 | i0 | 96.2 | 0.639344262295082 | 52 | 2 | 63.9 | 0 | 244 | 89 | 49 | 100 | PIC14317.1 hypothetical protein B9Z55_027263 [Caenorhabditis nigoni] | diamond | 156 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 30516504 | 30516504 | PRJNA290839_P_NODE_1013_length_253_cov_1.200000_g992_i0 | PRJNA290839 | 1013 | 253 | 1.2 | 3.036 | Caenorhabditis nigoni | 1611254 | Nematoda | Nematoda | 65.9 | 3.17e-10 | NR | PIC12202.1 | 1611254 | g992 | i0 | 88.9 | 0.853754940711462 | 36 | 4 | 42.7 | 0 | 145 | 252 | 1147 | 1182 | PIC12202.1 hypothetical protein B9Z55_028556 [Caenorhabditis nigoni] | diamond | 216 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis nigoni | |
| 30944998 | 30944998 | PRJNA290839_P_NODE_354_length_449_cov_1.015957_g333_i0 | PRJNA290839 | 354 | 449 | 1.015957 | 4.56164693 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 166 | 9.43e-45 | NR | VDN50986.1 | 318479 | g333 | i0 | 51 | 6.80178173719376 | 147 | 71 | 98.2 | 1 | 448 | 8 | 557 | 702 | VDN50986.1 unnamed protein product [Dracunculus medinensis] | diamond | 3054 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Dracunculidae | Dracunculus | Dracunculus medinensis | |
| 30976618 | 30976618 | PRJNA290839_P_NODE_1594_length_243_cov_0.894118_g1573_i0 | PRJNA290839 | 1594 | 243 | 0.894118 | 2.17270674 | Opisthokonta | 33154 | Nematoda | Nematoda | 84 | 1.12e-16 | NR | KAI6192179.1 | 293665 | g1573 | i0 | 51.3 | 5.11111111111111 | 78 | 35 | 92.6 | 1 | 17 | 241 | 136 | 213 | KAI6192179.1 Endo-1,3(4)-beta-glucanase [Aphelenchoides bicaudatus] | diamond | 1242 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 31956647 | 31956647 | PRJNA290839_P_NODE_1457_length_245_cov_0.906977_g1436_i0 | PRJNA290839 | 1457 | 245 | 0.906977 | 2.22209365 | Rhabditida | 6236 | Nematoda | Nematoda | 82.8 | 2.98e-16 | NR | MCP9259181.1 | 6287 | g1436 | i0 | 53.1 | 5.73061224489796 | 81 | 36 | 96.7 | 1 | 6 | 242 | 372 | 452 | MCP9259181.1 hypothetical protein [Dirofilaria immitis] | diamond | 1404 | 83.6 | 0.990430622009569 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis |
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);;