contig_metadata
16 rows where bioproject = "PRJNA312899", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1065152 | 1065152 | PRJNA312899_P_NODE_92021_length_165_cov_0.879310_g91579_i0 | PRJNA312899 | 92021 | 165 | 0.87931 | 1.4508615 | root | 1 | Root_unresolved | Root_unresolved | 300 | 4.46e-77 | NTclustered | gi|18147017|dbj|AB047764.1| | 6306 | g91579 | i0 | 99.394 | 30.0787878787879 | 165 | 1 | 100 | 0 | 1 | 165 | 1297 | 1133 | Meloidogyne incognita DNA, polymorphic marker for virulence, isolate:MIGD-VI | blastn | 4963 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne incognita | |
| 9307144 | 9307144 | PRJNA312899_P_NODE_18868_length_434_cov_53.031169_g18427_i0 | PRJNA312899 | 18868 | 434 | 53.031169 | 230.15527346 | Oigolaimella attenuata | 669116 | Nematoda | Nematoda | 309 | 2.25e-79 | NTclustered | gi|256709322|gb|GQ422336.1| | 669116 | g18427 | i0 | 83.483 | 45.3732718894009 | 333 | 53 | 76 | 2 | 87 | 418 | 373 | 42 | Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 19692 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella attenuata | |
| 22055733 | 22055733 | PRJNA312899_P_NODE_24198_length_381_cov_6.430723_g23756_i0 | PRJNA312899 | 24198 | 381 | 6.430723 | 24.50105463 | Ancylostoma caninum | 29170 | Nematoda | Nematoda | 178 | 7.99e-50 | NR | RCN44245.1 | 29170 | g23756 | i0 | 72.2 | 12.8267716535433 | 126 | 33 | 99.2 | 1 | 3 | 380 | 522 | 645 | RCN44245.1 putative antigen peptide transporter-like 2 [Ancylostoma caninum] | diamond | 4887 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma caninum | |
| 22056051 | 22056051 | PRJNA312899_P_NODE_42678_length_271_cov_10.099099_g42236_i0 | PRJNA312899 | 42678 | 271 | 10.099099 | 27.36855829 | Longidorus macrosoma | 188093 | Nematoda | Nematoda | 401 | 2.1399999999999994e-107 | NTclustered | gi|49339465|gb|AY580055.1| | 188093 | g42236 | i0 | 93.165 | 5.53505535055351 | 278 | 12 | 100 | 4 | 1 | 271 | 1911 | 2188 | Longidorus macrosoma 28S ribosomal RNA gene, 28S-18S intergenic spacer, 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence | blastn | 1500 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dorylaimida | Longidoridae | Longidorus | Longidorus macrosoma | |
| 23332287 | 23332287 | PRJNA312899_P_NODE_82299_length_174_cov_2.432000_g81857_i0 | PRJNA312899 | 82299 | 174 | 2.432 | 4.23168 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 75 | 3.12e-9 | NTclustered | gi|687867785|emb|LK929889.1| | 6239 | g81857 | i0 | 97.674 | 2.18965517241379 | 43 | 1 | 25 | 0 | 1 | 43 | 1252 | 1210 | Caenorhabditis elegans genome assembly C_elegans_Bristol_N2_v1_5_4 ,scaffold CELN2_contig0001390 | blastn | 381 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 27643157 | 27643157 | PRJNA312899_P_NODE_67664_length_199_cov_1.360000_g67222_i0 | PRJNA312899 | 67664 | 199 | 1.36 | 2.7064 | Necator americanus | 51031 | Nematoda | Nematoda | 65.1 | 1.89e-10 | NR | XP_013306179.2 | 51031 | g67222 | i0 | 56.9 | 4.5678391959799 | 58 | 21 | 81.4 | 1 | 37 | 198 | 110 | 167 | XP_013306179.2 hypothetical protein RB195_003307 [Necator americanus] | diamond | 909 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 28134253 | 28134253 | PRJNA312899_P_NODE_23265_length_389_cov_6.047059_g22823_i0 | PRJNA312899 | 23265 | 389 | 6.047059 | 23.52305951 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 6.660000000000001e-26 | NR | KAI1716374.1 | 166010 | g22823 | i0 | 50.9 | 3.40102827763496 | 110 | 52 | 84.8 | 1 | 387 | 58 | 299 | 406 | KAI1716374.1 PCI domain-containing protein [Ditylenchus destructor] | diamond | 1323 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Anguinidae | Ditylenchus | Ditylenchus destructor | |
| 28306028 | 28306028 | PRJNA312899_P_NODE_64906_length_206_cov_0.974522_g64464_i0 | PRJNA312899 | 64906 | 206 | 0.974522 | 2.00751532 | Cooperia oncophora | 27828 | Nematoda | Nematoda | 135 | 6e-36 | NR | KAK6048272.1 | 27828 | g64464 | i0 | 89.7 | 1.98058252427184 | 68 | 7 | 99 | 0 | 206 | 3 | 242 | 309 | KAK6048272.1 hypothetical protein COOONC_14223 [Cooperia oncophora] | diamond | 408 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 28558777 | 28558777 | PRJNA312899_P_NODE_38627_length_288_cov_21.255230_g38185_i0 | PRJNA312899 | 38627 | 288 | 21.25523 | 61.2150624 | Mesorhabditis spiculigera | 96644 | Nematoda | Nematoda | 43.1 | 0.0488 | NR | CAJ0581155.1 | 96644 | g38185 | i0 | 44.7 | 0.489583333333333 | 47 | 26 | 49 | 0 | 61 | 201 | 1014 | 1060 | CAJ0581155.1 unnamed protein product, partial [Mesorhabditis spiculigera] | diamond | 141 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Mesorhabditis | Mesorhabditis spiculigera | |
| 28685117 | 28685117 | PRJNA312899_P_NODE_91007_length_165_cov_0.879310_g90565_i0 | PRJNA312899 | 91007 | 165 | 0.87931 | 1.4508615 | Cooperia oncophora | 27828 | Nematoda | Nematoda | 109 | 1.61e-26 | NR | KAK6048272.1 | 27828 | g90565 | i0 | 96.3 | 0.981818181818182 | 54 | 2 | 98.2 | 0 | 3 | 164 | 87 | 140 | KAK6048272.1 hypothetical protein COOONC_14223 [Cooperia oncophora] | diamond | 162 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Cooperia | Cooperia oncophora | |
| 28937587 | 28937587 | PRJNA312899_P_NODE_102788_length_161_cov_0.910714_g102346_i0 | PRJNA312899 | 102788 | 161 | 0.910714 | 1.46624954 | Caenorhabditis brenneri | 135651 | Nematoda | Nematoda | 74.3 | 1.19e-14 | NR | CAL2033366.1 | 135651 | g102346 | i0 | 72.4 | 2.16149068322981 | 58 | 10 | 98.8 | 2 | 161 | 3 | 103 | 159 | CAL2033366.1 unnamed protein product [Caenorhabditis brenneri] | diamond | 348 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis brenneri | |
| 29316381 | 29316381 | PRJNA312899_P_NODE_409_length_1890_cov_7.426942_g362_i0 | PRJNA312899 | 409 | 1890 | 7.426942 | 140.3692038 | Ancylostoma ceylanicum | 53326 | Nematoda | Nematoda | 57.8 | 7.99e-5 | NR | EYC46279.1 | 53326 | g362 | i0 | 32.8 | 0.787301587301587 | 122 | 75 | 19 | 4 | 577 | 936 | 14 | 130 | EYC46279.1 hypothetical protein Y032_0402g803 [Ancylostoma ceylanicum] | diamond | 1488 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Ancylostoma | Ancylostoma ceylanicum | |
| 29505715 | 29505715 | PRJNA312899_P_NODE_13710_length_510_cov_3.360087_g13279_i0 | PRJNA312899 | 13710 | 510 | 3.360087 | 17.1364437 | Bursaphelenchus xylophilus | 6326 | Nematoda | Nematoda | 128 | 1.99e-34 | NR | CAD5224984.1 | 6326 | g13279 | i0 | 50.4 | 0.829411764705882 | 141 | 65 | 81.2 | 3 | 63 | 476 | 4 | 142 | CAD5224984.1 unnamed protein product [Bursaphelenchus xylophilus] | diamond | 423 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus xylophilus | |
| 30453681 | 30453681 | PRJNA312899_P_NODE_51173_length_242_cov_7.373057_g50731_i0 | PRJNA312899 | 51173 | 242 | 7.373057 | 17.84279794 | Caenorhabditis bovis | 2654633 | Nematoda | Nematoda | 47.8 | 6.05e-4 | NR | CAB3402077.1 | 2654633 | g50731 | i0 | 35.4 | 4.04132231404959 | 82 | 47 | 94.2 | 2 | 236 | 9 | 294 | 375 | CAB3402077.1 unnamed protein product [Caenorhabditis bovis] | diamond | 978 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis bovis | |
| 30786945 | 30786945 | PRJNA312899_P_NODE_4354_length_857_cov_5.482673_g4073_i0 | PRJNA312899 | 4354 | 857 | 5.482673 | 46.98650761 | Rhabditida | 6236 | Nematoda | Nematoda | 88.6 | 1.14e-15 | NR | XP_024508479.1 | 34506 | g4073 | i0 | 41.5 | 1.65577596266044 | 106 | 46 | 37.1 | 3 | 296 | 613 | 166 | 255 | XP_024508479.1 Alpha-(1,6)-fucosyltransferase [Strongyloides ratti] | diamond | 1419 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 32792213 | 32792213 | PRJNA312899_P_NODE_6800_length_713_cov_5.155120_g6447_i0 | PRJNA312899 | 6800 | 713 | 5.15512 | 36.7560056 | Auanema sp. JU1783 | 2878363 | Nematoda | Nematoda | 135 | 4.28e-35 | NR | CAI4222680.1 | 2878363 | g6447 | i0 | 55.3 | 2.58345021037868 | 123 | 51 | 51.3 | 2 | 2 | 367 | 134 | 253 | CAI4222680.1 unnamed protein product [Auanema sp. JU1783] | diamond | 1842 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Auanema | Auanema sp. JU1783 |
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);;