contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7277143 | 7277143 | PRJNA924320_S_NODE_10266_length_306_cov_3.494163_g10124_i0 | PRJNA924320 | 10266 | 306 | 3.494163 | 10.69213878 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 52.8 | 0.029 | NTclustered | gi|1376143153|ref|XM_024651938.1| | 34506 | g10124 | i0 | 90 | 0.130718954248366 | 40 | 4 | 13 | 0 | 56 | 95 | 2338 | 2299 | Strongyloides ratti Collagen alpha-2(IV) chain (SRAE_2000103500), partial mRNA | blastn | 40 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 8904982 | 8904982 | PRJNA924320_S_NODE_20787_length_228_cov_1.709497_g20645_i0 | PRJNA924320 | 20787 | 228 | 1.709497 | 3.89765316 | Pristionchus | 54125 | Nematoda | Nematoda | 128 | 3.28e-25 | NTclustered | gi|150984730|gb|EF634951.1| | 70414 | g20645 | i0 | 82.667 | 65.6008771929825 | 150 | 20 | 64 | 6 | 44 | 190 | 195 | 49 | Pristionchus lheritieri small subunit ribosomal protein 25 (rps-25) mRNA, partial cds | blastn | 14957 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus lheritieri | |
| 11102888 | 11102888 | PRJNA924320_S_NODE_50109_length_165_cov_0.879310_g49967_i0 | PRJNA924320 | 50109 | 165 | 0.87931 | 1.4508615 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 176 | 7.85e-40 | NTclustered | gi|1376154049|ref|XM_024646386.1| | 34506 | g49967 | i0 | 87.097 | 27.6181818181818 | 155 | 20 | 94 | 0 | 11 | 165 | 987 | 1141 | Strongyloides ratti V-type proton ATPase subunit B, kidney (SRAE_X000121000), partial mRNA | blastn | 4557 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 12378558 | 12378558 | PRJNA924320_S_NODE_9450_length_318_cov_1.936803_g9308_i0 | PRJNA924320 | 9450 | 318 | 1.936803 | 6.15903354 | Pristionchus americanus | 376549 | Nematoda | Nematoda | 222 | 2.15e-53 | NTclustered | gi|150982255|gb|EF634716.1| | 376549 | g9308 | i0 | 82.129 | 65.4150943396226 | 263 | 43 | 82 | 4 | 32 | 292 | 290 | 30 | Pristionchus americanus large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 20802 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus americanus | |
| 18750847 | 18750847 | PRJNA924320_S_NODE_38295_length_180_cov_2.442748_g38153_i0 | PRJNA924320 | 38295 | 180 | 2.442748 | 4.3969464 | Necator americanus | 51031 | Nematoda | Nematoda | 58.4 | 3.28e-4 | NTclustered | gi|2707571125|ref|XM_013453164.2| | 51031 | g38153 | i0 | 100 | 0.577777777777778 | 31 | 0 | 17 | 0 | 40 | 70 | 2673 | 2703 | Necator americanus uncharacterized protein (RB195_009825), partial mRNA | blastn | 104 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ancylostomatidae | Necator | Necator americanus | |
| 21301243 | 21301243 | PRJNA924320_S_NODE_37617_length_182_cov_1.150376_g37475_i0 | PRJNA924320 | 37617 | 182 | 1.150376 | 2.09368432 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 143 | 8.93e-30 | NTclustered | gi|1376146183|ref|XM_024653652.1| | 34506 | g37475 | i0 | 81.081 | 2.04395604395604 | 185 | 29 | 100 | 6 | 1 | 182 | 930 | 749 | Strongyloides ratti ATP synthase subunit beta (SRAE_2000256800), partial mRNA | blastn | 372 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 22576516 | 22576516 | PRJNA924320_S_NODE_58338_length_158_cov_3.238532_g58196_i0 | PRJNA924320 | 58338 | 158 | 3.238532 | 5.11688056 | Heterorhabditis bacteriophora | 37862 | Nematoda | Nematoda | 213 | 5.66e-51 | NTclustered | gi|1963716464|emb|LR890122.1| | 37862 | g58196 | i0 | 91.083 | 81.5759493670886 | 157 | 14 | 99 | 0 | 1 | 157 | 196 | 40 | Heterorhabditis bacteriophora partial mRNA for Hb-hsp90-5 isoform (Hb-hsp90-5 isoform gene), clone 23 | blastn | 12889 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Heterorhabditidae | Heterorhabditis | Heterorhabditis bacteriophora |
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);;