contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1073183" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23139383 | 23139383 | PRJNA1073183_P_NODE_15139_length_335_cov_1.175573_g15044_i0 | PRJNA1073183 | 15139 | 335 | 1.175573 | 3.93816955 | Rhabditida | 6236 | Nematoda | Nematoda | 171 | 2.15e-47 | NR | VDO71113.1 | 6339 | g15044 | i0 | 82.2 | 34.7194029850746 | 107 | 19 | 95.8 | 0 | 15 | 335 | 312 | 418 | VDO71113.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 11631 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 26940745 | 26940745 | PRJNA1073183_P_NODE_32342_length_244_cov_0.900585_g32247_i0 | PRJNA1073183 | 32342 | 244 | 0.900585 | 2.1974274 | Aphelenchoides fujianensis | 1052528 | Nematoda | Nematoda | 43.9 | 0.0145 | NR | KAI6234642.1 | 1052528 | g32247 | i0 | 35.8 | 0.995901639344262 | 81 | 50 | 99.6 | 1 | 1 | 243 | 295 | 373 | KAI6234642.1 Tftc-1 [Aphelenchoides fujianensis] | diamond | 243 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 27785684 | 27785684 | PRJNA1073183_P_NODE_22544_length_276_cov_1.137931_g22449_i0 | PRJNA1073183 | 22544 | 276 | 1.137931 | 3.14068956 | Steinernema | 34507 | Nematoda | Nematoda | 89 | 3.24e-18 | NR | TKR73105.1 | 34508 | g22449 | i0 | 48.4 | 5 | 91 | 43 | 98.9 | 2 | 276 | 4 | 204 | 290 | TKR73105.1 hypothetical protein L596_020456 [Steinernema carpocapsae] | diamond | 1380 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 28109548 | 28109548 | PRJNA1073183_P_NODE_4305_length_609_cov_2.035448_g4213_i0 | PRJNA1073183 | 4305 | 609 | 2.035448 | 12.39587832 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 217 | 9.86e-68 | NR | KAI6182696.1 | 293665 | g4213 | i0 | 61.2 | 0.901477832512315 | 183 | 69 | 90.1 | 1 | 557 | 9 | 15 | 195 | KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus] | diamond | 549 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 28678141 | 28678141 | PRJNA1073183_P_NODE_17507_length_313_cov_0.962500_g17412_i0 | PRJNA1073183 | 17507 | 313 | 0.9625 | 3.012625 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 117 | 4.66e-30 | NR | KAI6182696.1 | 293665 | g17412 | i0 | 62 | 4.39936102236422 | 92 | 35 | 88.2 | 0 | 276 | 1 | 15 | 106 | KAI6182696.1 Ribosomal protein L1 domain containing protein [Aphelenchoides bicaudatus] | diamond | 1377 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 28898854 | 28898854 | PRJNA1073183_P_NODE_34568_length_241_cov_0.916667_g34473_i0 | PRJNA1073183 | 34568 | 241 | 0.916667 | 2.20916747 | Meloidogyne enterolobii | 390850 | Nematoda | Nematoda | 87.8 | 1.71e-19 | NR | CAD2140840.1 | 390850 | g34473 | i0 | 55.4 | 2.81327800829876 | 74 | 32 | 90.9 | 1 | 219 | 1 | 1 | 74 | CAD2140840.1 unnamed protein product [Meloidogyne enterolobii] | diamond | 678 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne enterolobii | |
| 28953938 | 28953938 | PRJNA1073183_P_NODE_31488_length_245_cov_0.895349_g31393_i0 | PRJNA1073183 | 31488 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 68.2 | 3.89e-11 | NR | CAJ0559936.1 | 96644 | g31393 | i0 | 40.7 | 10.9591836734694 | 81 | 46 | 96.7 | 1 | 239 | 3 | 192 | 272 | CAJ0559936.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 2685 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 29143425 | 29143425 | PRJNA1073183_P_NODE_9649_length_412_cov_4.020649_g9555_i0 | PRJNA1073183 | 9649 | 412 | 4.020649 | 16.56507388 | Opisthokonta | 33154 | Nematoda | Nematoda | 90.9 | 5.93e-19 | NR | VDD94551.1 | 51028 | g9555 | i0 | 40 | 14.4684466019417 | 120 | 70 | 87.4 | 2 | 377 | 18 | 7 | 124 | VDD94551.1 unnamed protein product [Enterobius vermicularis] | diamond | 5961 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Oxyuridae | Enterobius | Enterobius vermicularis | |
| 29719693 | 29719693 | PRJNA1073183_P_NODE_8770_length_431_cov_1.720670_g8676_i0 | PRJNA1073183 | 8770 | 431 | 1.72067 | 7.4160877 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 82.4 | 1.09e-15 | NR | AVZ46778.1 | 189291 | g8676 | i0 | 54.3 | 0.563805104408353 | 81 | 37 | 56.4 | 0 | 182 | 424 | 117 | 197 | AVZ46778.1 hypothetical protein [Meloidogyne graminicola] | diamond | 243 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 30509719 | 30509719 | PRJNA1073183_P_NODE_23833_length_267_cov_1.587629_g23738_i0 | PRJNA1073183 | 23833 | 267 | 1.587629 | 4.23896943 | Loa loa | 7209 | Nematoda | Nematoda | 63.5 | 2.27e-9 | NR | XP_003147055.2 | 7209 | g23738 | i0 | 39.1 | 2.32584269662921 | 69 | 42 | 77.5 | 0 | 255 | 49 | 235 | 303 | XP_003147055.2 hypothetical protein LOAG_11489 [Loa loa] | diamond | 621 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 31679140 | 31679140 | PRJNA1073183_P_NODE_10457_length_396_cov_3.040248_g10363_i0 | PRJNA1073183 | 10457 | 396 | 3.040248 | 12.03938208 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 92.8 | 2.7400000000000004e-21 | NR | GMT18625.1 | 1538716 | g10363 | i0 | 42 | 0.992424242424242 | 131 | 70 | 98.5 | 3 | 390 | 1 | 1 | 126 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 393 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus |
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);;