contig_metadata
9 rows where bioproject = "PRJNA1192965" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10524205 | 10524205 | PRJNA1192965_P_NODE_3049_length_257_cov_2.510870_g3030_i0 | PRJNA1192965 | 3049 | 257 | 2.51087 | 6.4529359 | Pseudodiplogasteroides sp. SB257 | 669115 | Nematoda | Nematoda | 169 | 2.2199999999999996e-37 | NTclustered | gi|256709253|gb|GQ422279.1| | 669115 | g3030 | i0 | 85.366 | 25.3112840466926 | 164 | 23 | 63 | 1 | 92 | 254 | 45 | 208 | Pseudodiplogasteroides sp. SB257 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 6505 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Pseudodiplogasteroides | Pseudodiplogasteroides sp. SB257 | |
| 27091439 | 27091439 | PRJNA1192965_P_NODE_5122_length_241_cov_0.916667_g5103_i0 | PRJNA1192965 | 5122 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 84 | 9.61e-17 | NR | KJH51267.1 | 29172 | g5103 | i0 | 54.9 | 10.7178423236515 | 71 | 32 | 88.4 | 0 | 240 | 28 | 103 | 173 | KJH51267.1 hypothetical protein DICVIV_02546 [Dictyocaulus viviparus] | diamond | 2583 | 84.3 | 0.99644128113879 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Metastrongylidae | Dictyocaulus | Dictyocaulus viviparus | |
| 27628691 | 27628691 | PRJNA1192965_P_NODE_4264_length_246_cov_0.890173_g4245_i0 | PRJNA1192965 | 4264 | 246 | 0.890173 | 2.18982558 | Opisthokonta | 33154 | Nematoda | Nematoda | 103 | 2.0499999999999999e-23 | NR | KAI6229547.1 | 269767 | g4245 | i0 | 54.3 | 14.7682926829268 | 81 | 37 | 98.8 | 0 | 2 | 244 | 666 | 746 | KAI6229547.1 RNA helicase [Aphelenchoides besseyi] | diamond | 3633 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides besseyi | |
| 28556847 | 28556847 | PRJNA1192965_P_NODE_4287_length_246_cov_0.861272_g4268_i0 | PRJNA1192965 | 4287 | 246 | 0.861272 | 2.11872912 | Meloidogyne graminicola | 189291 | Nematoda | Nematoda | 134 | 2.6099999999999993e-34 | NR | KAF7634404.1 | 189291 | g4268 | i0 | 76.8 | 3.96341463414634 | 82 | 19 | 100 | 0 | 246 | 1 | 230 | 311 | KAF7634404.1 AA_TRNA_LIGASE_II domain-containing protein [Meloidogyne graminicola] | diamond | 975 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne graminicola | |
| 29314480 | 29314480 | PRJNA1192965_P_NODE_809_length_421_cov_3.321839_g790_i0 | PRJNA1192965 | 809 | 421 | 3.321839 | 13.98494219 | Pristionchus fissidentatus | 1538716 | Nematoda | Nematoda | 86.7 | 8.94e-19 | NR | GMT18625.1 | 1538716 | g790 | i0 | 41.3 | 0.862232779097387 | 121 | 66 | 85.5 | 2 | 404 | 45 | 10 | 126 | GMT18625.1 hypothetical protein PFISCL1PPCAC_9922 [Pristionchus fissidentatus] | diamond | 363 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus fissidentatus | |
| 30407692 | 30407692 | PRJNA1192965_P_NODE_3353_length_251_cov_0.865169_g3334_i0 | PRJNA1192965 | 3353 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Nematoda | Nematoda | 78.2 | 1.38e-14 | NR | KFD58966.1 | 68888 | g3334 | i0 | 42.7 | 33.3585657370518 | 82 | 47 | 98 | 0 | 5 | 250 | 382 | 463 | KFD58966.1 hypothetical protein M513_00129 [Trichuris suis] | diamond | 8373 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Trichinellida | Trichuridae | Trichuris | Trichuris suis | |
| 31177920 | 31177920 | PRJNA1192965_P_NODE_2215_length_289_cov_1.421296_g2196_i0 | PRJNA1192965 | 2215 | 289 | 1.421296 | 4.10754544 | Cylicocyclus nassatus | 53992 | Nematoda | Nematoda | 47 | 0.0019 | NR | CAJ0594742.1 | 53992 | g2196 | i0 | 34.1 | 1.59861591695502 | 82 | 49 | 85.1 | 2 | 248 | 3 | 75 | 151 | CAJ0594742.1 unnamed protein product [Cylicocyclus nassatus] | diamond | 462 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongylidae | Cylicocyclus | Cylicocyclus nassatus | |
| 31355448 | 31355448 | PRJNA1192965_P_NODE_736_length_439_cov_2.112022_g717_i0 | PRJNA1192965 | 736 | 439 | 2.112022 | 9.27177658 | Rhabditida | 6236 | Nematoda | Nematoda | 95.5 | 3.31e-20 | NR | KAK6028514.1 | 6317 | g717 | i0 | 46.1 | 2.60364464692483 | 115 | 52 | 78.6 | 2 | 93 | 437 | 41 | 145 | KAK6028514.1 papain family cysteine protease [Ostertagia ostertagi] | diamond | 1143 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 32285694 | 32285694 | PRJNA1192965_P_NODE_3959_length_247_cov_0.885057_g3940_i0 | PRJNA1192965 | 3959 | 247 | 0.885057 | 2.18609079 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 68.2 | 4.27e-11 | NR | CAD5223258.1 | 6326 | g3940 | i0 | 47.6 | 1.53036437246964 | 63 | 33 | 76.5 | 0 | 58 | 246 | 68 | 130 | CAD5223258.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 378 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus |
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);;