contig_metadata
20 rows where bioproject = "PRJNA797475", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2057178 | 2057178 | PRJNA797475_P_NODE_15382_length_281_cov_2.197115_g15283_i0 | PRJNA797475 | 15382 | 281 | 2.197115 | 6.17389315 | Caenorhabditis briggsae | 6238 | Nematoda | Nematoda | 102 | 8.01e-26 | NR | XP_002639762.1 | 6238 | g15283 | i0 | 69.4 | 0.768683274021352 | 72 | 22 | 76.9 | 0 | 217 | 2 | 16 | 87 | XP_002639762.1 Protein CBR-RPL-30 [Caenorhabditis briggsae] | diamond | 216 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 3332470 | 3332470 | PRJNA797475_P_NODE_23303_length_249_cov_0.875000_g23204_i0 | PRJNA797475 | 23303 | 249 | 0.875 | 2.17875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 460 | 3.16e-125 | NTclustered | gi|687865928|emb|LK927994.1| | 6239 | g23204 | i0 | 100 | 3 | 249 | 0 | 100 | 0 | 1 | 249 | 59271 | 59023 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000393 | blastn | 747 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 8434544 | 8434544 | PRJNA797475_P_NODE_23327_length_249_cov_0.875000_g23228_i0 | PRJNA797475 | 23327 | 249 | 0.875 | 2.17875 | Sudhausia aristotokia | 1357959 | Nematoda | Nematoda | 122 | 1.69e-23 | NTclustered | gi|675118807|gb|KJ877278.1| | 1357959 | g23228 | i0 | 79.255 | 52.0120481927711 | 188 | 30 | 73 | 9 | 38 | 220 | 1421 | 1604 | Sudhausia aristotokia strain RS9011 28S ribosomal RNA gene, partial sequence | blastn | 12951 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Sudhausia | Sudhausia aristotokia | |
| 10985299 | 10985299 | PRJNA797475_P_NODE_14569_length_286_cov_1.248826_g14470_i0 | PRJNA797475 | 14569 | 286 | 1.248826 | 3.57164236 | Steinernema carpocapsae | 34508 | Nematoda | Nematoda | 99.4 | 2.28e-22 | NR | TKR96790.1 | 34508 | g14470 | i0 | 59.1 | 0.692307692307692 | 66 | 27 | 69.2 | 0 | 3 | 200 | 119 | 184 | TKR96790.1 hypothetical protein L596_010761 [Steinernema carpocapsae] | diamond | 198 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Steinernematidae | Steinernema | Steinernema carpocapsae | |
| 14809930 | 14809930 | PRJNA797475_P_NODE_21672_length_251_cov_0.865169_g21573_i0 | PRJNA797475 | 21672 | 251 | 0.865169 | 2.17157419 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.1499999999999996e-124 | NTclustered | gi|351060592|emb|FO080992.1| | 6239 | g21573 | i0 | 99.602 | 3 | 251 | 1 | 100 | 0 | 1 | 251 | 10369 | 10619 | Caenorhabditis elegans YAC Y119C1B, complete sequence | blastn | 753 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16083952 | 16083952 | PRJNA797475_P_NODE_22733_length_250_cov_0.870056_g22634_i0 | PRJNA797475 | 22733 | 250 | 0.870056 | 2.17514 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 462 | 8.83e-126 | NTclustered | gi|687865721|emb|LK927708.1| | 6239 | g22634 | i0 | 100 | 47.104 | 250 | 0 | 100 | 0 | 1 | 250 | 369 | 120 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000155 | blastn | 11776 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 16083976 | 16083976 | PRJNA797475_P_NODE_24533_length_248_cov_0.880000_g24434_i0 | PRJNA797475 | 24533 | 248 | 0.88 | 2.1824 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|1972262700|ref|NM_065509.9| | 6239 | g24434 | i0 | 100 | 6.62096774193548 | 248 | 0 | 100 | 0 | 1 | 248 | 514 | 761 | Caenorhabditis elegans Small ribosomal subunit protein eS1 (rps-3A), mRNA | blastn | 1642 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19908176 | 19908176 | PRJNA797475_P_NODE_19276_length_261_cov_2.632979_g19177_i0 | PRJNA797475 | 19276 | 261 | 2.632979 | 6.87207519 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 475 | 1.1899999999999999e-129 | NTclustered | gi|1972230171|ref|NM_001392490.1| | 6239 | g19177 | i0 | 99.615 | 3.04980842911877 | 260 | 1 | 99 | 0 | 1 | 260 | 261 | 2 | Caenorhabditis elegans Small integral membrane protein 15 (C48B6.10), mRNA | blastn | 796 | 475 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 19908239 | 19908239 | PRJNA797475_P_NODE_23916_length_248_cov_1.320000_g23817_i0 | PRJNA797475 | 23916 | 248 | 1.32 | 3.2736 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 459 | 1.13e-124 | NTclustered | gi|1734338622|ref|NM_076012.6| | 6239 | g23817 | i0 | 100 | 96.5564516129032 | 248 | 0 | 100 | 0 | 1 | 248 | 371 | 124 | Caenorhabditis elegans Large ribosomal subunit protein uL5B (rpl-11.2), mRNA | blastn | 23946 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22458546 | 22458546 | PRJNA797475_P_NODE_23258_length_249_cov_0.875000_g23159_i0 | PRJNA797475 | 23258 | 249 | 0.875 | 2.17875 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 460 | 3.16e-125 | NTclustered | gi|1734326521|ref|NM_066550.4| | 6239 | g23159 | i0 | 100 | 2.97991967871486 | 249 | 0 | 100 | 0 | 1 | 249 | 697 | 449 | Caenorhabditis elegans Malectin domain-containing protein (F44E2.10), partial mRNA | blastn | 742 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22894594 | 22894594 | PRJNA797475_P_NODE_6078_length_409_cov_11.377976_g5980_i0 | PRJNA797475 | 6078 | 409 | 11.377976 | 46.53592184 | root | 1 | Root_unresolved | Root_unresolved | 185 | 2.28e-57 | NR | CDW60131.1 | 36087 | g5980 | i0 | 62.5 | 2.99266503667482 | 136 | 51 | 99.8 | 0 | 2 | 409 | 1 | 136 | CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura] | diamond | 1224 | 186 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 23734237 | 23734237 | PRJNA797475_P_NODE_25439_length_247_cov_0.885057_g25340_i0 | PRJNA797475 | 25439 | 247 | 0.885057 | 2.18609079 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 457 | 4.05e-124 | NTclustered | gi|687865583|emb|LK927625.1| | 6239 | g25340 | i0 | 100 | 4 | 247 | 0 | 100 | 0 | 1 | 247 | 87779 | 88025 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_scaffold0000086 | blastn | 988 | 457 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 25007781 | 25007781 | PRJNA797475_P_NODE_20880_length_253_cov_1.422222_g20781_i0 | PRJNA797475 | 20880 | 253 | 1.422222 | 3.59822166 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 462 | 8.95e-126 | NTclustered | gi|1972236089|ref|NM_001383766.2| | 6239 | g20781 | i0 | 99.605 | 8.09090909090909 | 253 | 1 | 100 | 0 | 1 | 253 | 288 | 36 | Caenorhabditis elegans Small ribosomal subunit protein eS26 (rps-26), mRNA | blastn | 2047 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27148290 | 27148290 | PRJNA797475_P_NODE_7442_length_374_cov_4.202658_g7343_i0 | PRJNA797475 | 7442 | 374 | 4.202658 | 15.71794092 | Dirofilaria immitis | 6287 | Nematoda | Nematoda | 60.5 | 9.55e-8 | NR | MCP9258340.1 | 6287 | g7343 | i0 | 42.4 | 2.55080213903743 | 66 | 38 | 52.9 | 0 | 286 | 89 | 352 | 417 | MCP9258340.1 Acyl-CoA-binding domain-containing protein 6 [Dirofilaria immitis] | diamond | 954 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Dirofilaria | Dirofilaria immitis | |
| 28506685 | 28506685 | PRJNA797475_P_NODE_7187_length_380_cov_1.504886_g7088_i0 | PRJNA797475 | 7187 | 380 | 1.504886 | 5.7185668 | Trichuris trichiura | 36087 | Nematoda | Nematoda | 174 | 3.99e-53 | NR | CDW60131.1 | 36087 | g7088 | i0 | 61.9 | 6.86842105263158 | 126 | 48 | 99.5 | 0 | 3 | 380 | 6 | 131 | CDW60131.1 60S ribosomal protein L27a [Trichuris trichiura] | diamond | 2610 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris trichiura | |
| 29012161 | 29012161 | PRJNA797475_P_NODE_18328_length_266_cov_1.994819_g18229_i0 | PRJNA797475 | 18328 | 266 | 1.994819 | 5.30621854 | Anisakis simplex | 6269 | Nematoda | Nematoda | 58.2 | 1.42e-8 | NR | VDK28727.1 | 6269 | g18229 | i0 | 44.6 | 2.21052631578947 | 65 | 33 | 69.9 | 1 | 79 | 264 | 31 | 95 | VDK28727.1 unnamed protein product [Anisakis simplex] | diamond | 588 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 29052642 | 29052642 | PRJNA797475_P_NODE_29728_length_241_cov_2.285714_g29629_i0 | PRJNA797475 | 29728 | 241 | 2.285714 | 5.50857074 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 8.29e-25 | NR | VBB30137.1 | 6277 | g29629 | i0 | 69 | 53.1908713692946 | 71 | 22 | 88.4 | 0 | 27 | 239 | 574 | 644 | VBB30137.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 12819 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 30631549 | 30631549 | PRJNA797475_P_NODE_7773_length_368_cov_1.044068_g7674_i0 | PRJNA797475 | 7773 | 368 | 1.044068 | 3.84217024 | Metazoa | 33208 | Nematoda | Nematoda | 46.6 | 0.00486 | NR | CAL2034575.1 | 135651 | g7674 | i0 | 47.8 | 1.5570652173913 | 46 | 21 | 35.9 | 2 | 357 | 226 | 124 | 168 | CAL2034575.1 unnamed protein product [Caenorhabditis brenneri] | diamond | 573 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 32362073 | 32362073 | PRJNA797475_P_NODE_24419_length_248_cov_0.880000_g24320_i0 | PRJNA797475 | 24419 | 248 | 0.88 | 2.1824 | Acanthocheilonema viteae | 6277 | Nematoda | Nematoda | 52.4 | 7.83e-6 | NR | VBB28430.1 | 6277 | g24320 | i0 | 54.7 | 2.56451612903226 | 53 | 24 | 64.1 | 0 | 2 | 160 | 140 | 192 | VBB28430.1 unnamed protein product [Acanthocheilonema viteae] | diamond | 636 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Acanthocheilonema | Acanthocheilonema viteae | |
| 32614703 | 32614703 | PRJNA797475_P_NODE_17520_length_270_cov_2.345178_g17421_i0 | PRJNA797475 | 17520 | 270 | 2.345178 | 6.3319806 | Pristionchus pacificus | 54126 | Nematoda | Nematoda | 48.9 | 4.17e-5 | NR | KAF8374309.1 | 54126 | g17421 | i0 | 38.3 | 0.666666666666667 | 60 | 33 | 66.7 | 1 | 181 | 2 | 34 | 89 | KAF8374309.1 dlc-2 [Pristionchus pacificus] | diamond | 180 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus pacificus |
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);;