contig_metadata
17 rows where bioproject = "PRJNA745553" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 724215 | 724215 | PRJNA745553_S_NODE_24101_length_252_cov_1.290503_g23906_i0 | PRJNA745553 | 24101 | 252 | 1.290503 | 3.25206756 | Bursaphelenchus ussuriensis | 3375378 | Nematoda | Nematoda | 117 | 7.99e-22 | NTclustered | gi|2838470513|gb|PQ500562.1| | 3375378 | g23906 | i0 | 81.169 | 14.3888888888889 | 154 | 22 | 59 | 6 | 96 | 244 | 4121 | 4272 | Bursaphelenchus ussuriensis isolate CD4139 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3626 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus ussuriensis | |
| 2000319 | 2000319 | PRJNA745553_S_NODE_26162_length_243_cov_3.047059_g25967_i0 | PRJNA745553 | 26162 | 243 | 3.047059 | 7.40435337 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 4.34e-36 | NR | XP_024506366.1 | 34506 | g25967 | i0 | 69.4 | 20.7530864197531 | 85 | 21 | 98.8 | 1 | 242 | 3 | 244 | 328 | XP_024506366.1 60S ribosomal protein L3 [Strongyloides ratti] | diamond | 5043 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 2473965 | 2473965 | PRJNA745553_S_NODE_1002_length_771_cov_5.206304_g883_i0 | PRJNA745553 | 1002 | 771 | 5.206304 | 40.14060384 | Rhabditida | 6236 | Nematoda | Nematoda | 128 | 1.25e-24 | NTclustered | gi|2547219|gb|AF023856.1|AF023856 | 6304 | g883 | i0 | 85.833 | 8.57587548638132 | 120 | 17 | 16 | 0 | 515 | 634 | 367 | 486 | Meloidogyne arenaria | blastn | 6612 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Meloidogynidae | Meloidogyne | Meloidogyne arenaria | |
| 3275483 | 3275483 | PRJNA745553_S_NODE_19343_length_281_cov_3.115385_g19148_i0 | PRJNA745553 | 19343 | 281 | 3.115385 | 8.75423185 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g19148 | i0 | 100 | 0.099644128113879 | 28 | 0 | 10 | 0 | 1 | 28 | 23 | 50 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 9652572 | 9652572 | PRJNA745553_S_NODE_17168_length_298_cov_2.488889_g16973_i0 | PRJNA745553 | 17168 | 298 | 2.488889 | 7.41688922 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g16973 | i0 | 100 | 0.0973154362416107 | 29 | 0 | 10 | 0 | 270 | 298 | 53 | 25 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 12203521 | 12203521 | PRJNA745553_S_NODE_13770_length_331_cov_6.945736_g13575_i0 | PRJNA745553 | 13770 | 331 | 6.945736 | 22.99038616 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.031 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g13575 | i0 | 100 | 0.0845921450151057 | 28 | 0 | 8 | 0 | 1 | 28 | 23 | 50 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 14752975 | 14752975 | PRJNA745553_S_NODE_1472_length_706_cov_10.413902_g1332_i0 | PRJNA745553 | 1472 | 706 | 10.413902 | 73.52214812 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 332 | 5.08e-113 | NR | VDP19351.1 | 241478 | g1332 | i0 | 75.7 | 13.2025495750708 | 206 | 50 | 87.5 | 0 | 677 | 60 | 1 | 206 | VDP19351.1 unnamed protein product [Soboliphyme baturini] | diamond | 9321 | 333 | 0.996996996996997 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Enoplea | Dioctophymatida | Soboliphymatidae | Soboliphyme | Soboliphyme baturini | |
| 14753365 | 14753365 | PRJNA745553_S_NODE_8692_length_408_cov_4.540299_g8497_i0 | PRJNA745553 | 8692 | 408 | 4.540299 | 18.52441992 | Rhomborhabditis regina | 2528157 | Nematoda | Nematoda | 606 | 6.67e-169 | NTclustered | gi|157787505|gb|EF990726.1| | 2528157 | g8497 | i0 | 94.643 | 96.8259803921569 | 392 | 20 | 96 | 1 | 18 | 408 | 1787 | 1396 | Rhabditoides regina strain DF5012 28S large subunit ribosomal RNA gene, partial sequence | blastn | 39505 | 606 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Rhomborhabditis | Rhomborhabditis regina | |
| 16026678 | 16026678 | PRJNA745553_S_NODE_13853_length_330_cov_4.852140_g13658_i0 | PRJNA745553 | 13853 | 330 | 4.85214 | 16.012062 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.031 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g13658 | i0 | 100 | 0.0848484848484849 | 28 | 0 | 8 | 0 | 1 | 28 | 25 | 52 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 17302179 | 17302179 | PRJNA745553_S_NODE_15174_length_316_cov_3.724280_g14979_i0 | PRJNA745553 | 15174 | 316 | 3.72428 | 11.7687248 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|687022649|emb|LM525563.1| | 174720 | g14979 | i0 | 96.875 | 0.10126582278481 | 32 | 1 | 10 | 0 | 188 | 219 | 610505 | 610474 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_scaffold0000008 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 17776425 | 17776425 | PRJNA745553_S_NODE_27734_length_234_cov_6.074534_g27539_i0 | PRJNA745553 | 27734 | 234 | 6.074534 | 14.21440956 | Rhabditida | 6236 | Nematoda | Nematoda | 171 | 5.55e-38 | NTclustered | gi|2437461996|gb|ON496988.1| | 31243 | g27539 | i0 | 94.545 | 47.0042735042735 | 110 | 6 | 47 | 0 | 104 | 213 | 5006 | 4897 | Globodera rostochiensis isolate Ro1-5 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 10999 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera rostochiensis | |
| 17776458 | 17776458 | PRJNA745553_S_NODE_6014_length_472_cov_3.583960_g5820_i0 | PRJNA745553 | 6014 | 472 | 3.58396 | 16.9162912 | Rhabditida | 6236 | Nematoda | Nematoda | 135 | 4.4300000000000005e-27 | NTclustered | gi|2437461996|gb|ON496988.1| | 31243 | g5820 | i0 | 88.496 | 12.25 | 113 | 12 | 24 | 1 | 175 | 286 | 5003 | 4891 | Globodera rostochiensis isolate Ro1-5 18S small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S large subunit ribosomal RNA gene, complete sequence | blastn | 5782 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Globodera | Globodera rostochiensis | |
| 19851169 | 19851169 | PRJNA745553_S_NODE_18656_length_286_cov_1.849765_g18461_i0 | PRJNA745553 | 18656 | 286 | 1.849765 | 5.2903279 | Parapristionchus giblindavisi | 1187980 | Nematoda | Nematoda | 143 | 1.52e-29 | NTclustered | gi|387600374|gb|JQ677919.1| | 1187980 | g18461 | i0 | 87.805 | 20.6748251748252 | 123 | 13 | 43 | 2 | 3 | 124 | 191 | 70 | Diplogastridae gen. sp. EJR-2012 small ribosomal protein 14 mRNA, partial cds | blastn | 5913 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Parapristionchus | Parapristionchus giblindavisi | |
| 24950672 | 24950672 | PRJNA745553_S_NODE_18920_length_284_cov_2.710900_g18725_i0 | PRJNA745553 | 18920 | 284 | 2.7109 | 7.698956 | Diploscapter pachys | 2018661 | Nematoda | Nematoda | 68.9 | 9.59e-13 | NR | PAV56235.1 | 2018661 | g18725 | i0 | 67.4 | 1.94366197183099 | 46 | 15 | 48.6 | 0 | 261 | 124 | 55 | 100 | PAV56235.1 hypothetical protein WR25_15683 [Diploscapter pachys] | diamond | 552 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter pachys | |
| 26873183 | 26873183 | PRJNA745553_S_NODE_881_length_798_cov_6.798621_g769_i0 | PRJNA745553 | 881 | 798 | 6.798621 | 54.25299558 | root | 1 | Root_unresolved | Root_unresolved | 186 | 2.84e-53 | NR | KHN76811.1 | 6265 | g769 | i0 | 52.5 | 6.14285714285714 | 181 | 83 | 68 | 2 | 3 | 545 | 169 | 346 | KHN76811.1 Malate dehydrogenase, cytoplasmic [Toxocara canis] | diamond | 4902 | 187 | 0.994652406417112 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Toxocaridae | Toxocara | Toxocara canis | |
| 27621577 | 27621577 | PRJNA745553_S_NODE_29184_length_223_cov_4.060000_g28989_i0 | PRJNA745553 | 29184 | 223 | 4.06 | 9.0538 | Aphelenchoides bicaudatus | 293665 | Nematoda | Nematoda | 42.4 | 0.0406 | NR | KAI6190497.1 | 293665 | g28989 | i0 | 73.1 | 0.349775784753363 | 26 | 7 | 35 | 0 | 67 | 144 | 49 | 74 | KAI6190497.1 U4/U6.U5 tri-snRNP-associated protein 1 [Aphelenchoides bicaudatus] | diamond | 78 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides bicaudatus | |
| 29484053 | 29484053 | PRJNA745553_S_NODE_5270_length_495_cov_4.867299_g5076_i0 | PRJNA745553 | 5270 | 495 | 4.867299 | 24.09313005 | Caenorhabditis angaria | 860376 | Nematoda | Nematoda | 56.6 | 1.06e-6 | NR | CAI5449474.1 | 860376 | g5076 | i0 | 49.1 | 1.87272727272727 | 53 | 24 | 30.3 | 2 | 488 | 339 | 50 | 102 | CAI5449474.1 unnamed protein product [Caenorhabditis angaria] | diamond | 927 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis angaria |
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);;