contig_metadata
8 rows where bioproject = "PRJNA473799", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4272585 | 4272585 | PRJNA473799_P_NODE_27964_length_263_cov_0.826316_g27690_i0 | PRJNA473799 | 27964 | 263 | 0.826316 | 2.17321108 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 411 | 3.439999999999999e-110 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g27690 | i0 | 94.737 | 124.038022813688 | 266 | 11 | 100 | 3 | 1 | 263 | 1310 | 1575 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 32622 | 412 | 0.997572815533981 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5549288 | 5549288 | PRJNA473799_P_NODE_34105_length_251_cov_2.797753_g33831_i0 | PRJNA473799 | 34105 | 251 | 2.797753 | 7.02236003 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 448 | 2.48e-121 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g33831 | i0 | 98.805 | 2.33067729083665 | 251 | 3 | 100 | 0 | 1 | 251 | 373 | 123 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 585 | 448 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6823332 | 6823332 | PRJNA473799_P_NODE_33506_length_253_cov_0.683333_g33232_i0 | PRJNA473799 | 33506 | 253 | 0.683333 | 1.72883249 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 401 | 1.9799999999999994e-107 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g33232 | i0 | 95.276 | 121.217391304348 | 254 | 10 | 100 | 2 | 1 | 253 | 1821 | 1569 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 30668 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10649731 | 10649731 | PRJNA473799_P_NODE_6729_length_434_cov_2.279778_g6458_i0 | PRJNA473799 | 6729 | 434 | 2.279778 | 9.89423652 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 797 | 0 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g6458 | i0 | 99.77 | 104.758064516129 | 435 | 0 | 100 | 1 | 1 | 434 | 1546 | 1112 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 45465 | 802 | 0.993765586034913 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26823161 | 26823161 | PRJNA473799_P_NODE_13621_length_295_cov_14.945946_g13347_i0 | PRJNA473799 | 13621 | 295 | 14.945946 | 44.0905407 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 69.7 | 1.03e-12 | NR | AAW27122.1 | 6182 | g13347 | i0 | 96.9 | 0.325423728813559 | 32 | 1 | 32.5 | 0 | 293 | 198 | 18 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 96 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27202425 | 27202425 | PRJNA473799_P_NODE_942_length_1417_cov_4.072173_g800_i0 | PRJNA473799 | 942 | 1417 | 4.072173 | 57.70269141 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 90.1 | 6.16e-18 | NR | AAX30115.1 | 6182 | g800 | i0 | 53.3 | 0.194777699364855 | 92 | 43 | 19.5 | 0 | 520 | 795 | 2 | 93 | AAX30115.1 unknown [Schistosoma japonicum] | diamond | 276 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30455691 | 30455691 | PRJNA473799_P_NODE_11073_length_316_cov_2.238683_g10799_i0 | PRJNA473799 | 11073 | 316 | 2.238683 | 7.07423828 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 199 | 3.510000000000001e-59 | NR | AAX28387.3 | 6182 | g10799 | i0 | 98.1 | 2.99050632911392 | 105 | 2 | 99.7 | 0 | 1 | 315 | 228 | 332 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 945 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31024129 | 31024129 | PRJNA473799_P_NODE_5455_length_523_cov_2.168889_g5188_i0 | PRJNA473799 | 5455 | 523 | 2.168889 | 11.34328947 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 281 | 1.25e-89 | NR | AAX28387.3 | 6182 | g5188 | i0 | 98.3 | 2.9942638623327 | 174 | 3 | 99.8 | 0 | 522 | 1 | 5 | 178 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 1566 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;