contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA744060" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10927218 | 10927218 | PRJNA744060_P_NODE_2949_length_899_cov_4.039952_g2692_i0 | PRJNA744060 | 2949 | 899 | 4.039952 | 36.31916848 | Pristionchus sp. 15 RS5229 | 452809 | Nematoda | Nematoda | 248 | 1.08e-60 | NTclustered | gi|150982261|gb|EF634719.1| | 452809 | g2692 | i0 | 82.971 | 6.71078976640712 | 276 | 43 | 30 | 4 | 76 | 349 | 30 | 303 | Pristionchus sp. 15 RS5229 large subunit ribosomal protein 30 (rpl-30) mRNA, partial cds | blastn | 6033 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus sp. 15 RS5229 | |
| 13477489 | 13477489 | PRJNA744060_P_NODE_5671_length_663_cov_20.220339_g5356_i0 | PRJNA744060 | 5671 | 663 | 20.220339 | 134.06084757 | Pristionchus uniformis | 358041 | Nematoda | Nematoda | 217 | 2.21e-51 | NTclustered | gi|256861444|gb|GQ422182.1| | 358041 | g5356 | i0 | 77.461 | 17.2564102564103 | 386 | 71 | 57 | 14 | 241 | 618 | 151 | 528 | Pristionchus uniformis large subunit ribosomal protein 9 (rpl-9) mRNA, partial cds | blastn | 11441 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus uniformis | |
| 17301842 | 17301842 | PRJNA744060_P_NODE_7974_length_564_cov_2.397149_g7649_i0 | PRJNA744060 | 7974 | 564 | 2.397149 | 13.51992036 | Brugia malayi | 6279 | Nematoda | Nematoda | 54.7 | 0.015 | NTclustered | gi|2082291043|ref|XM_043073249.1| | 6279 | g7649 | i0 | 94.286 | 0.124113475177305 | 35 | 2 | 6 | 0 | 24 | 58 | 2953 | 2987 | Brugia malayi Uncharacterized protein (Bma-unc-82), partial mRNA | blastn | 70 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Brugia | Brugia malayi | |
| 19050276 | 19050276 | PRJNA744060_P_NODE_8435_length_549_cov_9.978992_g8110_i0 | PRJNA744060 | 8435 | 549 | 9.978992 | 54.78466608 | Rhabditida | 6236 | Nematoda | Nematoda | 300 | 1.75e-76 | NTclustered | gi|150982035|gb|EF634606.1| | 358044 | g8110 | i0 | 82.336 | 62.5901639344262 | 351 | 56 | 63 | 3 | 74 | 421 | 61 | 408 | Koerneria sp. RS1982 large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 34362 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Koerneria | Koerneria sp. RS1982 | |
| 19850710 | 19850710 | PRJNA744060_P_NODE_6216_length_635_cov_2.887900_g5896_i0 | PRJNA744060 | 6216 | 635 | 2.8879 | 18.338165 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 496 | 2.42e-135 | NTclustered | gi|1376147725|ref|XM_024654528.1| | 34506 | g5896 | i0 | 81.433 | 60.1448818897638 | 614 | 106 | 96 | 8 | 21 | 630 | 1350 | 741 | Strongyloides ratti ATP synthase subunit alpha, mitochondrial (SRAE_2000334600), partial mRNA | blastn | 38192 | 496 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24150143 | 24150143 | PRJNA744060_P_NODE_40539_length_261_cov_2.351064_g40210_i0 | PRJNA744060 | 40539 | 261 | 2.351064 | 6.13627704 | Metazoa | 33208 | Nematoda | Nematoda | 196 | 1.04e-45 | NTclustered | gi|23306675|gb|AY137471.1| | 6233 | g40210 | i0 | 81.557 | 74.3831417624521 | 244 | 40 | 93 | 3 | 6 | 248 | 840 | 601 | Panagrellus redivivus heat shock protein 70-C mRNA, complete cds | blastn | 19414 | 196 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Panagrellus | Panagrellus redivivus |
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);;