contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA975724" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 946365 | 946365 | PRJNA975724_S_NODE_49061_length_299_cov_1.703540_g48880_i0 | PRJNA975724 | 49061 | 299 | 1.70354 | 5.0935846 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.028 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g48880 | i0 | 100 | 0.0936454849498328 | 28 | 0 | 9 | 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 | |
| 1266769 | 1266769 | PRJNA975724_S_NODE_33681_length_336_cov_6.475285_g33500_i0 | PRJNA975724 | 33681 | 336 | 6.475285 | 21.7569576 | Metazoa | 33208 | Nematoda | Nematoda | 176 | 1.8e-39 | NTclustered | gi|288904190|ref|NC_013848.1| | 237660 | g33500 | i0 | 78.114 | 82.2648809523809 | 297 | 51 | 86 | 12 | 9 | 298 | 13853 | 13564 | Mecistocirrus digitatus mitochondrion, complete genome | blastn | 27641 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Mecistocirrus | Mecistocirrus digitatus | |
| 3497743 | 3497743 | PRJNA975724_S_NODE_78423_length_251_cov_1.168539_g78242_i0 | PRJNA975724 | 78423 | 251 | 1.168539 | 2.93303289 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g78242 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 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 | |
| 4774199 | 4774199 | PRJNA975724_S_NODE_31064_length_344_cov_4.645756_g30883_i0 | PRJNA975724 | 31064 | 344 | 4.645756 | 15.98140064 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 58.4 | 6.99e-4 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g30883 | i0 | 92.5 | 0.116279069767442 | 40 | 3 | 12 | 0 | 1 | 40 | 23 | 62 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 40 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 6049005 | 6049005 | PRJNA975724_S_NODE_28705_length_352_cov_2.422939_g28524_i0 | PRJNA975724 | 28705 | 352 | 2.422939 | 8.52874528 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.033 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g28524 | i0 | 100 | 0.0795454545454545 | 28 | 0 | 8 | 0 | 325 | 352 | 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 | |
| 12425205 | 12425205 | PRJNA975724_S_NODE_36390_length_329_cov_1.609375_g36209_i0 | PRJNA975724 | 36390 | 329 | 1.609375 | 5.29484375 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 56.5 | 0.002 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g36209 | i0 | 97.059 | 0.103343465045593 | 34 | 0 | 10 | 1 | 296 | 329 | 51 | 19 | Pratylenchus vulnus mRNA for endoglucanase-8 (Pv-eng-8 gene), clone Pv-eng-8-10 | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Pratylenchidae | Pratylenchus | Pratylenchus vulnus | |
| 13701172 | 13701172 | PRJNA975724_S_NODE_9211_length_458_cov_3.335065_g9030_i0 | PRJNA975724 | 9211 | 458 | 3.335065 | 15.2745977 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.044 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g9030 | i0 | 100 | 0.0611353711790393 | 28 | 0 | 6 | 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 | |
| 14973419 | 14973419 | PRJNA975724_S_NODE_16912_length_402_cov_1.571429_g16731_i0 | PRJNA975724 | 16912 | 402 | 1.571429 | 6.31714458 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.011 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g16731 | i0 | 100 | 0.0721393034825871 | 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 | |
| 14974890 | 14974890 | PRJNA975724_S_NODE_73252_length_258_cov_1.248649_g73071_i0 | PRJNA975724 | 73252 | 258 | 1.248649 | 3.22151442 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.023 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g73071 | i0 | 100 | 0.108527131782946 | 28 | 0 | 11 | 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 | |
| 14975270 | 14975270 | PRJNA975724_S_NODE_87532_length_244_cov_0.900585_g87351_i0 | PRJNA975724 | 87532 | 244 | 0.900585 | 2.1974274 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.022 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g87351 | i0 | 100 | 0.114754098360656 | 28 | 0 | 11 | 0 | 217 | 244 | 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 | |
| 18797260 | 18797260 | PRJNA975724_S_NODE_13195_length_425_cov_1.312500_g13014_i0 | PRJNA975724 | 13195 | 425 | 1.3125 | 5.578125 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 54.7 | 0.011 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g13014 | i0 | 100 | 0.0682352941176471 | 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 | |
| 20073404 | 20073404 | PRJNA975724_S_NODE_64456_length_271_cov_1.904040_g64275_i0 | PRJNA975724 | 64456 | 271 | 1.90404 | 5.1599484 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.025 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g64275 | i0 | 100 | 0.103321033210332 | 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 | |
| 21348568 | 21348568 | PRJNA975724_S_NODE_54417_length_289_cov_1.069444_g54236_i0 | PRJNA975724 | 54417 | 289 | 1.069444 | 3.09069316 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.027 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g54236 | i0 | 100 | 0.0968858131487889 | 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 | |
| 25173664 | 25173664 | PRJNA975724_S_NODE_94660_length_197_cov_4.411290_g94479_i0 | PRJNA975724 | 94660 | 197 | 4.41129 | 8.6902413 | Pratylenchus vulnus | 45931 | Nematoda | Nematoda | 52.8 | 0.017 | NTclustered | gi|1557394408|emb|LR031564.1| | 45931 | g94479 | i0 | 100 | 0.142131979695431 | 28 | 0 | 14 | 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 |
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);;