contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1073183" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187049 | 187049 | PRJNA1073183_P_NODE_12401_length_367_cov_1.326531_g12306_i0 | PRJNA1073183 | 12401 | 367 | 1.326531 | 4.86836877 | Oigolaimella attenuata | 669116 | Nematoda | Nematoda | 300 | 1.13e-76 | NTclustered | gi|256709322|gb|GQ422336.1| | 669116 | g12306 | i0 | 83.54 | 50.2643051771117 | 322 | 51 | 87 | 2 | 46 | 366 | 42 | 362 | Oigolaimella attenuata large subunit ribosomal protein 23 (rpl-23) mRNA, partial cds | blastn | 18447 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Oigolaimella | Oigolaimella attenuata | |
| 4844168 | 4844168 | PRJNA1073183_P_NODE_33864_length_242_cov_0.911243_g33769_i0 | PRJNA1073183 | 33864 | 242 | 0.911243 | 2.20520806 | Opisthokonta | 33154 | Nematoda | Nematoda | 161 | 3.47e-35 | NTclustered | gi|687022714|emb|LM525628.1| | 174720 | g33769 | i0 | 79.574 | 42.6115702479339 | 235 | 40 | 95 | 6 | 1 | 231 | 117457 | 117687 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000037 | blastn | 10312 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 16764200 | 16764200 | PRJNA1073183_P_NODE_27994_length_249_cov_0.875000_g27899_i0 | PRJNA1073183 | 27994 | 249 | 0.875 | 2.17875 | Diplogastrellus gracilis | 669117 | Nematoda | Nematoda | 187 | 5.919999999999998e-43 | NTclustered | gi|256709130|gb|GQ422217.1| | 669117 | g27899 | i0 | 80.816 | 89.574297188755 | 245 | 41 | 97 | 5 | 7 | 248 | 723 | 482 | Diplogastrellus gracilis large subunit ribosomal protein 2 (rpl-2) mRNA, partial cds | blastn | 22304 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogastrellus | Diplogastrellus gracilis | |
| 20142430 | 20142430 | PRJNA1073183_P_NODE_13776_length_350_cov_0.833935_g13681_i0 | PRJNA1073183 | 13776 | 350 | 0.833935 | 2.9187725 | Caenorhabditis | 6237 | Nematoda | Nematoda | 115 | 4.16e-21 | NTclustered | gi|268558427|ref|XM_002637158.1| | 6238 | g13681 | i0 | 83.333 | 1.63714285714286 | 126 | 19 | 36 | 2 | 226 | 350 | 200 | 76 | Caenorhabditis briggsae Protein CBR-EMO-1 (Cbr-emo-1), partial mRNA | blastn | 573 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis briggsae | |
| 21864250 | 21864250 | PRJNA1073183_P_NODE_34798_length_232_cov_2.509434_g34703_i0 | PRJNA1073183 | 34798 | 232 | 2.509434 | 5.82188688 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 99 | 2.63e-16 | NTclustered | gi|687022720|emb|LM525634.1| | 174720 | g34703 | i0 | 87.5 | 4.81034482758621 | 88 | 7 | 37 | 4 | 142 | 227 | 44189 | 44104 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000042 | blastn | 1116 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 23139367 | 23139367 | PRJNA1073183_P_NODE_14039_length_346_cov_1.769231_g13944_i0 | PRJNA1073183 | 14039 | 346 | 1.769231 | 6.12153926 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 278 | 4.96e-70 | NTclustered | gi|1376156759|ref|XM_024645793.1| | 34506 | g13944 | i0 | 81.159 | 52.121387283237 | 345 | 65 | 99 | 0 | 1 | 345 | 354 | 10 | Strongyloides ratti Ras-like protein 3 (SRAE_X000250800), partial mRNA | blastn | 18034 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 24412900 | 24412900 | PRJNA1073183_P_NODE_10160_length_403_cov_1.181818_g10066_i0 | PRJNA1073183 | 10160 | 403 | 1.181818 | 4.76272654 | Loa loa | 7209 | Nematoda | Nematoda | 65.8 | 4.96e-6 | NTclustered | gi|1158595002|ref|XM_020446451.1| | 7209 | g10066 | i0 | 93.182 | 0.109181141439206 | 44 | 3 | 11 | 0 | 134 | 177 | 1600 | 1643 | Loa loa procollagen partial mRNA | blastn | 44 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Onchocercidae | Loa | Loa loa | |
| 24413434 | 24413434 | PRJNA1073183_P_NODE_9340_length_419_cov_1.621387_g9246_i0 | PRJNA1073183 | 9340 | 419 | 1.621387 | 6.79361153 | Diplogasteriana schneideri | 669146 | Nematoda | Nematoda | 52.8 | 0.04 | NTclustered | gi|256709142|gb|GQ422223.1| | 669146 | g9246 | i0 | 83.051 | 0.140811455847255 | 59 | 9 | 14 | 1 | 317 | 375 | 166 | 109 | Diplogasteriana schneideri large subunit ribosomal protein 29 (rpl-29) mRNA, complete cds | blastn | 59 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Diplogasteriana | Diplogasteriana schneideri |
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);;