contig_metadata
13 rows where bioproject = "PRJNA596870", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 568350 | 568350 | PRJNA596870_P_NODE_24201_length_275_cov_1.856436_g24068_i0 | PRJNA596870 | 24201 | 275 | 1.856436 | 5.105199 | Fictor sp. 2 VS-2014 | 1538695 | Nematoda | Nematoda | 196 | 1.1e-45 | NTclustered | gi|675119079|gb|KJ877419.1| | 1538695 | g24068 | i0 | 85.638 | 66.7745454545455 | 188 | 25 | 68 | 2 | 1 | 187 | 235 | 49 | Fictor sp. 2 VS-2014 strain RS9002 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 18363 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Fictor | Fictor sp. 2 VS-2014 | |
| 2415962 | 2415962 | PRJNA596870_P_NODE_6842_length_470_cov_1.163728_g6709_i0 | PRJNA596870 | 6842 | 470 | 1.163728 | 5.4695216 | root | 1 | Root_unresolved | Root_unresolved | 135 | 1.22e-35 | NR | VDK51241.1 | 6269 | g6709 | i0 | 71.6 | 1.54468085106383 | 88 | 25 | 56.2 | 0 | 266 | 3 | 18 | 105 | VDK51241.1 unnamed protein product [Anisakis simplex] | diamond | 726 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anisakidae | Anisakis | Anisakis simplex | |
| 3119088 | 3119088 | PRJNA596870_P_NODE_10703_length_388_cov_1.209524_g10570_i0 | PRJNA596870 | 10703 | 388 | 1.209524 | 4.69295312 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 368 | 3.2400000000000003e-97 | NTclustered | gi|1376142265|ref|XM_024651434.1| | 34506 | g10570 | i0 | 83.938 | 99.319587628866 | 386 | 60 | 99 | 2 | 1 | 385 | 727 | 1111 | Strongyloides ratti Elongation factor 1-alpha (SRAE_2000058600), partial mRNA | blastn | 38536 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 10772676 | 10772676 | PRJNA596870_P_NODE_25429_length_269_cov_1.571429_g25296_i0 | PRJNA596870 | 25429 | 269 | 1.571429 | 4.22714401 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 154 | 6.57e-33 | NTclustered | gi|1734332372|ref|NM_070393.5| | 6239 | g25296 | i0 | 81.622 | 16.8327137546468 | 185 | 34 | 69 | 0 | 53 | 237 | 208 | 24 | Caenorhabditis elegans Small ribosomal subunit protein uS13 (rps-18), mRNA | blastn | 4528 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 17146015 | 17146015 | PRJNA596870_P_NODE_24714_length_273_cov_1.155000_g24581_i0 | PRJNA596870 | 24714 | 273 | 1.155 | 3.15315 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 237 | 6.45e-58 | NTclustered | gi|1376152089|ref|XM_024644563.1| | 34506 | g24581 | i0 | 83.077 | 88.029304029304 | 260 | 44 | 95 | 0 | 2 | 261 | 764 | 505 | Strongyloides ratti Calcium/calmodulin-dependent protein kinase type II subunit delta (SRAE_X000024300), partial mRNA | blastn | 24032 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 17718419 | 17718419 | PRJNA596870_P_NODE_5894_length_502_cov_1.361305_g5761_i0 | PRJNA596870 | 5894 | 502 | 1.361305 | 6.8337511 | Metazoa | 33208 | Nematoda | Nematoda | 479 | 1.9e-130 | NTclustered | gi|1376146183|ref|XM_024653652.1| | 34506 | g5761 | i0 | 84.064 | 84.2749003984064 | 502 | 74 | 99 | 6 | 4 | 502 | 1229 | 731 | Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA | blastn | 42306 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22817636 | 22817636 | PRJNA596870_P_NODE_11138_length_381_cov_1.435065_g11005_i0 | PRJNA596870 | 11138 | 381 | 1.435065 | 5.46759765 | Metazoa | 33208 | Nematoda | Nematoda | 190 | 1.6199999999999998e-54 | NR | XP_003379656.1 | 6334 | g11005 | i0 | 69.8 | 53.5905511811024 | 126 | 38 | 99.2 | 0 | 380 | 3 | 379 | 504 | XP_003379656.1 heat shockprotein C [Trichinella spiralis] | diamond | 20418 | 191 | 0.994764397905759 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichinellidae | Trichinella | Trichinella spiralis | |
| 28988194 | 28988194 | PRJNA596870_P_NODE_29828_length_251_cov_0.865169_g29695_i0 | PRJNA596870 | 29828 | 251 | 0.865169 | 2.17157419 | Rhabditida | 6236 | Nematoda | Nematoda | 112 | 6.28e-28 | NR | VDO95798.1 | 6339 | g29695 | i0 | 89.7 | 14.5458167330677 | 58 | 6 | 69.3 | 0 | 176 | 3 | 94 | 151 | VDO95798.1 unnamed protein product [Heligmosomoides polygyrus] | diamond | 3651 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heligmosomidae | Heligmosomoides | Heligmosomoides polygyrus | |
| 29303655 | 29303655 | PRJNA596870_P_NODE_21009_length_292_cov_1.054795_g20876_i0 | PRJNA596870 | 21009 | 292 | 1.054795 | 3.0800014 | Metazoa | 33208 | Nematoda | Nematoda | 124 | 1.6200000000000002e-33 | NR | KAE9420224.1 | 6313 | g20876 | i0 | 77.9 | 175.356164383562 | 68 | 15 | 69.9 | 0 | 287 | 84 | 104 | 171 | KAE9420224.1 hypothetical protein Angca_009488 [Angiostrongylus cantonensis] | diamond | 51204 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Angiostrongylus | Angiostrongylus cantonensis | |
| 30016746 | 30016746 | PRJNA596870_P_NODE_31571_length_249_cov_0.875000_g31438_i0 | PRJNA596870 | 31571 | 249 | 0.875 | 2.17875 | Aphelenchoides fujianensis | 1052528 | Nematoda | Nematoda | 48.5 | 3.31e-4 | NR | KAI6233644.1 | 1052528 | g31438 | i0 | 59.5 | 0.879518072289157 | 37 | 15 | 44.6 | 0 | 96 | 206 | 3 | 39 | KAI6233644.1 CBR-UNC-50 protein [Aphelenchoides fujianensis] | diamond | 219 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides fujianensis | |
| 30522135 | 30522135 | PRJNA596870_P_NODE_31753_length_249_cov_0.875000_g31620_i0 | PRJNA596870 | 31753 | 249 | 0.875 | 2.17875 | Trichuris suis | 68888 | Nematoda | Nematoda | 85.9 | 2.2e-19 | NR | KFD50175.1 | 68888 | g31620 | i0 | 56.3 | 9.98795180722892 | 80 | 35 | 96.4 | 0 | 240 | 1 | 16 | 95 | KFD50175.1 hypothetical protein M513_08920 [Trichuris suis] | diamond | 2487 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 30598576 | 30598576 | PRJNA596870_P_NODE_32813_length_248_cov_0.880000_g32680_i0 | PRJNA596870 | 32813 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Nematoda | Nematoda | 90.9 | 4.26e-19 | NR | KHN82290.1 | 6265 | g32680 | i0 | 50.6 | 3.87096774193548 | 81 | 39 | 98 | 1 | 1 | 243 | 141 | 220 | KHN82290.1 Pyruvate kinase PKLR [Toxocara canis] | diamond | 960 | 91.3 | 0.995618838992333 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 31027868 | 31027868 | PRJNA596870_P_NODE_4215_length_582_cov_1.056974_g4084_i0 | PRJNA596870 | 4215 | 582 | 1.056974 | 6.15158868 | Heterodera schachtii | 97005 | Nematoda | Nematoda | 112 | 8.01e-27 | NR | KAL3103729.1 | 97005 | g4084 | i0 | 78.9 | 1.4639175257732 | 71 | 14 | 36.1 | 1 | 578 | 369 | 121 | 191 | KAL3103729.1 hypothetical protein niasHS_001331 [Heterodera schachtii] | diamond | 852 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera schachtii |
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);;