contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJEB14803" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3536420 | 3536420 | PRJEB14803_P_NODE_5823_length_569_cov_17.629213_g5399_i0 | PRJEB14803 | 5823 | 569 | 17.629213 | 100.31022197 | Opisthokonta | 33154 | Nematoda | Nematoda | 392 | 2.91e-104 | NTclustered | gi|150984495|gb|EF634890.1| | 452809 | g5399 | i0 | 83.816 | 67.1652021089631 | 414 | 65 | 73 | 2 | 49 | 461 | 435 | 23 | Pristionchus sp. 15 RS5229 small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 38217 | 394 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 6399696 | 6399696 | PRJEB14803_P_NODE_6006_length_558_cov_14.923518_g5576_i0 | PRJEB14803 | 6006 | 558 | 14.923518 | 83.27323044 | Pristionchus hoplostomus | 1355913 | Nematoda | Nematoda | 159 | 3.1499999999999993e-34 | NTclustered | gi|524845304|gb|KC819362.1| | 1355913 | g5576 | i0 | 79.556 | 3.1326164874552 | 225 | 44 | 40 | 2 | 133 | 356 | 37 | 260 | Pristionchus hoplostomus strain JU1090 subunit ribosomal protein 35 (rpl-35) mRNA, partial cds | blastn | 1748 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus hoplostomus | |
| 7673706 | 7673706 | PRJEB14803_P_NODE_33687_length_184_cov_1.409396_g33221_i0 | PRJEB14803 | 33687 | 184 | 1.409396 | 2.59328864 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 54.7 | 0.004 | NTclustered | gi|1376135301|ref|XM_024647662.1| | 34506 | g33221 | i0 | 100 | 0.309782608695652 | 29 | 0 | 16 | 0 | 89 | 117 | 2079 | 2051 | Strongyloides ratti Proteinase inhibitor I2, Kunitz metazoa domain-containing protein (SRAE_1000078600), partial mRNA | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 8948538 | 8948538 | PRJEB14803_P_NODE_45448_length_154_cov_1.008403_g44982_i0 | PRJEB14803 | 45448 | 154 | 1.008403 | 1.55294062 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 52.8 | 0.013 | NTclustered | gi|351020631|emb|FO080287.1| | 6239 | g44982 | i0 | 100 | 1.27272727272727 | 28 | 0 | 18 | 0 | 32 | 59 | 14960 | 14933 | Caenorhabditis elegans Cosmid R09A1, complete sequence | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 12775042 | 12775042 | PRJEB14803_P_NODE_31091_length_193_cov_2.189873_g30625_i0 | PRJEB14803 | 31091 | 193 | 2.189873 | 4.22645489 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 150 | 5.74e-32 | NTclustered | gi|2445348377|ref|XM_003109331.2| | 31234 | g30625 | i0 | 82.558 | 3.26943005181347 | 172 | 28 | 89 | 2 | 23 | 193 | 734 | 564 | Caenorhabditis remanei uncharacterized protein (GCK72_000822), partial mRNA | blastn | 631 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 17873132 | 17873132 | PRJEB14803_P_NODE_41775_length_161_cov_1.587302_g41309_i0 | PRJEB14803 | 41775 | 161 | 1.587302 | 2.55555622 | Sachsia zurstrasseni | 1538730 | Nematoda | Nematoda | 119 | 1.3e-22 | NTclustered | gi|675119121|gb|KJ877440.1| | 1538730 | g41309 | i0 | 82.707 | 3.8695652173913 | 133 | 23 | 83 | 0 | 4 | 136 | 82 | 214 | Sachsia zurstrasseni small subunit ribosomal protein 27 (rps-27) mRNA, partial cds | blastn | 623 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Sachsia | Sachsia zurstrasseni | |
| 21387924 | 21387924 | PRJEB14803_P_NODE_28457_length_204_cov_3.934911_g27991_i0 | PRJEB14803 | 28457 | 204 | 3.934911 | 8.02721844 | Rhabditida | 6236 | Nematoda | Nematoda | 191 | 3.61e-44 | NTclustered | gi|380447938|gb|JQ074059.1| | 34510 | g27991 | i0 | 84.184 | 67.593137254902 | 196 | 31 | 96 | 0 | 9 | 204 | 101 | 296 | Heterodera avenae actin 2 mRNA, complete cds | blastn | 13789 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heteroderidae | Heterodera | Heterodera avenae | |
| 21698151 | 21698151 | PRJEB14803_P_NODE_27558_length_209_cov_1.367816_g27092_i0 | PRJEB14803 | 27558 | 209 | 1.367816 | 2.85873544 | Bursaphelenchus mucronatus | 6325 | Nematoda | Nematoda | 183 | 6.229999999999998e-42 | NTclustered | gi|255098668|gb|FJ555023.1| | 6325 | g27092 | i0 | 83.854 | 58.2727272727273 | 192 | 31 | 92 | 0 | 18 | 209 | 677 | 868 | Bursaphelenchus mucronatus heat shock protein 70 (hsp70) mRNA, complete cds | blastn | 12179 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus mucronatus | |
| 21698229 | 21698229 | PRJEB14803_P_NODE_43318_length_158_cov_1.300813_g42852_i0 | PRJEB14803 | 43318 | 158 | 1.300813 | 2.05528454 | Caenorhabditis elegans | 6239 | Nematoda | Nematoda | 115 | 1.6400000000000002e-21 | NTclustered | gi|3642544|emb|Z83108.1| | 6239 | g42852 | i0 | 83.607 | 26.4746835443038 | 122 | 20 | 77 | 0 | 1 | 122 | 9608 | 9729 | Caenorhabditis elegans Cosmid F44E5, complete sequence | blastn | 4183 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis elegans | |
| 22973416 | 22973416 | PRJEB14803_P_NODE_26539_length_214_cov_1.564246_g26073_i0 | PRJEB14803 | 26539 | 214 | 1.564246 | 3.34748644 | Diplogasteroides magnus | 560213 | Nematoda | Nematoda | 104 | 5.13e-18 | NTclustered | gi|256709249|gb|GQ422277.1| | 560213 | g26073 | i0 | 86.458 | 1.47663551401869 | 96 | 11 | 44 | 2 | 110 | 204 | 22 | 116 | Diplogasteroides magnus small subunit ribosomal protein 14 (rps-14) mRNA, partial cds | blastn | 316 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteroididae | Diplogasteroides | Diplogasteroides magnus |
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);;