contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA437204" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4259936 | 4259936 | PRJNA437204_P_NODE_5804_length_666_cov_4.080944_g5514_i0 | PRJNA437204 | 5804 | 666 | 4.080944 | 27.17908704 | Pristionchus bulgaricus | 1486442 | Nematoda | Nematoda | 368 | 5.799999999999998e-97 | NTclustered | gi|610559301|gb|KJ395505.1| | 1486442 | g5514 | i0 | 78.328 | 76.7012012012012 | 586 | 113 | 87 | 13 | 88 | 666 | 641 | 63 | Pristionchus bulgaricus isolate sp18 ribosomal protein (rpl-1) gene, partial cds | blastn | 51083 | 368 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus bulgaricus | |
| 9360135 | 9360135 | PRJNA437204_P_NODE_13468_length_478_cov_6.841975_g13169_i0 | PRJNA437204 | 13468 | 478 | 6.841975 | 32.704640499999996 | Koerneria sp. RS1982 | 358044 | Nematoda | Nematoda | 259 | 2.5500000000000003e-64 | NTclustered | gi|150982149|gb|EF634663.1| | 358044 | g13169 | i0 | 80 | 17.6987447698745 | 370 | 59 | 76 | 11 | 56 | 419 | 28 | 388 | Koerneria sp. RS1982 large subunit ribosomal protein 27a (rpl-27a) mRNA, partial cds | blastn | 8460 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Koerneria | Koerneria sp. RS1982 | |
| 11910965 | 11910965 | PRJNA437204_P_NODE_23410_length_388_cov_3.349206_g23111_i0 | PRJNA437204 | 23410 | 388 | 3.349206 | 12.99491928 | Strongyloides papillosus | 174720 | Nematoda | Nematoda | 202 | 3.48e-47 | NTclustered | gi|690018840|emb|LM526136.1| | 174720 | g23111 | i0 | 79.649 | 6.8659793814433 | 285 | 54 | 73 | 4 | 63 | 345 | 7759 | 8041 | Strongyloides papillosus genome assembly S_papillosus_LIN ,scaffold SPAL_contig0000493 | blastn | 2664 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides papillosus | |
| 13185783 | 13185783 | PRJNA437204_P_NODE_15771_length_450_cov_2.294430_g15472_i0 | PRJNA437204 | 15771 | 450 | 2.29443 | 10.324935 | Pristionchus bucculentus | 1317126 | Nematoda | Nematoda | 178 | 6.89e-40 | NTclustered | gi|479330844|gb|KC463843.1| | 1317126 | g15472 | i0 | 80.165 | 5.43777777777778 | 242 | 44 | 53 | 4 | 148 | 387 | 252 | 13 | Pristionchus bucculentus strain RS5596 large subunit ribosomal protein 30 (rpl30) gene, partial cds | blastn | 2447 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus bucculentus | |
| 17010313 | 17010313 | PRJNA437204_P_NODE_67214_length_269_cov_1.464286_g66915_i0 | PRJNA437204 | 67214 | 269 | 1.464286 | 3.93892934 | Pristionchus americanus | 376549 | Nematoda | Nematoda | 122 | 1.8499999999999998e-23 | NTclustered | gi|150981875|gb|EF634507.1| | 376549 | g66915 | i0 | 81.013 | 37.2379182156134 | 158 | 26 | 58 | 3 | 1 | 156 | 465 | 620 | Pristionchus americanus large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds | blastn | 10017 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus americanus | |
| 20215745 | 20215745 | PRJNA437204_P_NODE_19836_length_412_cov_5.716814_g19537_i0 | PRJNA437204 | 19836 | 412 | 5.716814 | 23.55327368 | Pristionchus | 54125 | Nematoda | Nematoda | 263 | 1.68e-65 | NTclustered | gi|150981855|gb|EF634497.1| | 358041 | g19537 | i0 | 80.278 | 68.5995145631068 | 360 | 61 | 86 | 10 | 6 | 360 | 392 | 38 | Pristionchus uniformis large subunit ribosomal protein 1 (rpl-1) mRNA, partial cds | blastn | 28263 | 265 | 0.992452830188679 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Neodiplogasteridae | Pristionchus | Pristionchus uniformis |
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);;