contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA788929" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2045030 | 2045030 | PRJNA788929_P_NODE_14782_length_439_cov_62.363388_g14123_i0 | PRJNA788929 | 14782 | 439 | 62.363388 | 273.77527332 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.012 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g14123 | i0 | 100 | 0.0660592255125285 | 29 | 0 | 7 | 0 | 1 | 29 | 23 | 51 | 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 | |
| 3320611 | 3320611 | PRJNA788929_P_NODE_30483_length_285_cov_23.245283_g29822_i0 | PRJNA788929 | 30483 | 285 | 23.245283 | 66.24905655 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.026 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g29822 | i0 | 100 | 0.0982456140350877 | 28 | 0 | 10 | 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 | |
| 3765816 | 3765816 | PRJNA788929_P_NODE_10223_length_558_cov_33.868041_g9570_i0 | PRJNA788929 | 10223 | 558 | 33.868041 | 188.98366878 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.004 | NTclustered | gi|1376138789|ref|XM_024649631.1| | 34506 | g9570 | i0 | 94.595 | 0.489247311827957 | 37 | 0 | 6 | 2 | 154 | 188 | 1706 | 1670 | Strongyloides ratti Voltage-dependent calcium channel type A subunit alpha-1 (SRAE_1000254200), partial mRNA | blastn | 273 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 4597391 | 4597391 | PRJNA788929_P_NODE_16384_length_412_cov_57.598820_g15725_i0 | PRJNA788929 | 16384 | 412 | 57.59882 | 237.3071384 | Aphelenchoides sp. 2 HMM2018 | 2109771 | Nematoda | Nematoda | 69.4 | 3.93e-7 | NTclustered | gi|1359463253|gb|KY750851.1| | 2109771 | g15725 | i0 | 87.097 | 0.684466019417476 | 62 | 7 | 15 | 1 | 1 | 61 | 257 | 196 | Aphelenchoides sp. 2 HMM2018 isolate HMM716 28S ribosomal RNA gene, partial sequence | blastn | 282 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Aphelenchoides | Aphelenchoides sp. 2 HMM2018 | |
| 6318217 | 6318217 | PRJNA788929_P_NODE_21925_length_347_cov_8.839416_g21264_i0 | PRJNA788929 | 21925 | 347 | 8.839416 | 30.67277352 | Panagrolaimus | 55784 | Nematoda | Nematoda | 512 | 1.25e-140 | NTclustered | gi|166014126|gb|EU253569.1| | 55785 | g21264 | i0 | 95.077 | 96.1556195965418 | 325 | 16 | 94 | 0 | 23 | 347 | 2496 | 2820 | Panagrolaimus sp. PS1159 28S large subunit ribosomal RNA gene, partial sequence | blastn | 33366 | 512 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrolaimus | Panagrolaimus sp. PS1159 | |
| 7147682 | 7147682 | PRJNA788929_P_NODE_18806_length_379_cov_45.758170_g18146_i0 | PRJNA788929 | 18806 | 379 | 45.75817 | 173.4234643 | Oscheius dolichura | 473156 | Nematoda | Nematoda | 582 | 1.04e-161 | NTclustered | gi|158821907|gb|EU195971.1| | 473156 | g18146 | i0 | 97.376 | 91.2321899736148 | 343 | 8 | 91 | 1 | 25 | 367 | 1886 | 2227 | Oscheius dolichura strain JU460 28S ribosomal RNA gene, partial sequence | blastn | 34577 | 582 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichura | |
| 8422215 | 8422215 | PRJNA788929_P_NODE_12607_length_487_cov_7.236715_g11950_i0 | PRJNA788929 | 12607 | 487 | 7.236715 | 35.24280205 | Mecistocirrus digitatus | 237660 | Nematoda | Nematoda | 178 | 7.51e-40 | NTclustered | gi|288904190|ref|NC_013848.1| | 237660 | g11950 | i0 | 77.204 | 56.9794661190965 | 329 | 59 | 66 | 14 | 83 | 402 | 13885 | 13564 | Mecistocirrus digitatus mitochondrion, complete genome | blastn | 27749 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Mecistocirrus | Mecistocirrus digitatus | |
| 8422805 | 8422805 | PRJNA788929_P_NODE_50007_length_198_cov_6.992000_g49346_i0 | PRJNA788929 | 50007 | 198 | 6.992 | 13.84416 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g49346 | i0 | 100 | 0.141414141414141 | 28 | 0 | 14 | 0 | 171 | 198 | 52 | 25 | 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 | |
| 12249000 | 12249000 | PRJNA788929_P_NODE_36630_length_255_cov_15.428571_g35969_i0 | PRJNA788929 | 36630 | 255 | 15.428571 | 39.34285605 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g35969 | i0 | 100 | 0.109803921568627 | 28 | 0 | 11 | 0 | 228 | 255 | 52 | 25 | 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 | |
| 12249186 | 12249186 | PRJNA788929_P_NODE_49370_length_202_cov_8.604651_g48709_i0 | PRJNA788929 | 49370 | 202 | 8.604651 | 17.38139502 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.018 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g48709 | i0 | 100 | 0.138613861386139 | 28 | 0 | 14 | 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 | |
| 13968316 | 13968316 | PRJNA788929_P_NODE_46791_length_219_cov_4.095890_g46130_i0 | PRJNA788929 | 46791 | 219 | 4.09589 | 8.9699991 | Metazoa | 33208 | Nematoda | Nematoda | 340 | 3.69e-89 | NTclustered | gi|1174020828|gb|KY887583.1| | 6293 | g46130 | i0 | 100 | 84.027397260274 | 184 | 0 | 84 | 0 | 22 | 205 | 1530 | 1713 | Wuchereria bancrofti isolate AP10 small subunit ribosomal RNA gene, partial sequence | blastn | 18402 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Wuchereria | Wuchereria bancrofti | |
| 14798232 | 14798232 | PRJNA788929_P_NODE_46392_length_221_cov_8.439189_g45731_i0 | PRJNA788929 | 46392 | 221 | 8.439189 | 18.65060769 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.02 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g45731 | i0 | 100 | 0.126696832579186 | 28 | 0 | 13 | 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 | |
| 24995947 | 24995947 | PRJNA788929_P_NODE_34980_length_263_cov_1.857895_g34319_i0 | PRJNA788929 | 34980 | 263 | 1.857895 | 4.88626385 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.024 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g34319 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 236 | 263 | 50 | 23 | 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 |
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);;