contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA1093008" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1473522 | 1473522 | PRJNA1093008_S_NODE_87742_length_246_cov_8.219653_g87415_i0 | PRJNA1093008 | 87742 | 246 | 8.219653 | 20.22034638 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 392 | 1.15e-104 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g87415 | i0 | 96.653 | 115.719512195122 | 239 | 2 | 99 | 2 | 5 | 243 | 2533 | 2301 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 28467 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5301478 | 5301478 | PRJNA1093008_S_NODE_49485_length_295_cov_1.387387_g49158_i0 | PRJNA1093008 | 49485 | 295 | 1.387387 | 4.09279165 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 100 | 9.64e-17 | NTclustered | gi|1124902734|gb|AY812498.2| | 6182 | g49158 | i0 | 100 | 18.3050847457627 | 54 | 0 | 18 | 0 | 219 | 272 | 1107 | 1160 | Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds | blastn | 5400 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6576244 | 6576244 | PRJNA1093008_S_NODE_101326_length_213_cov_432.428571_g100999_i0 | PRJNA1093008 | 101326 | 213 | 432.428571 | 921.07285623 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 213 | 8.13e-51 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g100999 | i0 | 100 | 78.4976525821596 | 115 | 0 | 100 | 0 | 1 | 115 | 1380 | 1266 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 16720 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 6576246 | 6576246 | PRJNA1093008_S_NODE_101666_length_206_cov_440.383459_g101339_i0 | PRJNA1093008 | 101666 | 206 | 440.383459 | 907.18992554 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 359 | 9.47e-95 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g101339 | i0 | 98.058 | 124.912621359223 | 206 | 4 | 100 | 0 | 1 | 206 | 1715 | 1920 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 25732 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10401903 | 10401903 | PRJNA1093008_S_NODE_47509_length_298_cov_2.804444_g47182_i0 | PRJNA1093008 | 47509 | 298 | 2.804444 | 8.35724312 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 67.6 | 9.89e-7 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g47182 | i0 | 97.5 | 9.59060402684564 | 40 | 0 | 13 | 1 | 1 | 39 | 435 | 396 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 2858 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10402283 | 10402283 | PRJNA1093008_S_NODE_96689_length_239_cov_163.289157_g96362_i0 | PRJNA1093008 | 96689 | 239 | 163.289157 | 390.26108523 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 363 | 8.74e-96 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g96362 | i0 | 98.086 | 110.581589958159 | 209 | 3 | 90 | 1 | 32 | 239 | 1712 | 1920 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26429 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15501039 | 15501039 | PRJNA1093008_S_NODE_101373_length_212_cov_463.028777_g101046_i0 | PRJNA1093008 | 101373 | 212 | 463.028777 | 981.62100724 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 387 | 4.5e-103 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g101046 | i0 | 99.531 | 123.646226415094 | 213 | 0 | 100 | 1 | 1 | 212 | 1494 | 1282 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26213 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15501045 | 15501045 | PRJNA1093008_S_NODE_11033_length_432_cov_93.479109_g10707_i0 | PRJNA1093008 | 11033 | 432 | 93.479109 | 403.82975088 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 678 | 0 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g10707 | i0 | 96.181 | 113.263888888889 | 419 | 8 | 95 | 2 | 22 | 432 | 1191 | 1609 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 48930 | 678 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19324710 | 19324710 | PRJNA1093008_S_NODE_96376_length_240_cov_138.125749_g96049_i0 | PRJNA1093008 | 96376 | 240 | 138.125749 | 331.5017976 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 370 | 5.249999999999999e-98 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g96049 | i0 | 98.565 | 110.241666666667 | 209 | 3 | 90 | 0 | 32 | 240 | 1712 | 1920 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26458 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20599393 | 20599393 | PRJNA1093008_S_NODE_101717_length_205_cov_387.734848_g101390_i0 | PRJNA1093008 | 101717 | 205 | 387.734848 | 794.8564384 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 361 | 2.62e-95 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g101390 | i0 | 98.537 | 125.380487804878 | 205 | 1 | 100 | 1 | 1 | 205 | 2028 | 1826 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 25703 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20599759 | 20599759 | PRJNA1093008_S_NODE_60557_length_277_cov_2.264706_g60230_i0 | PRJNA1093008 | 60557 | 277 | 2.264706 | 6.27323562 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|2318763589|ref|XM_012939013.2| | 6185 | g60230 | i0 | 92.308 | 0.140794223826715 | 39 | 1 | 13 | 2 | 108 | 144 | 480 | 518 | Schistosoma haematobium uncharacterized protein (MS3_00006885), mRNA | blastn | 39 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 21875212 | 21875212 | PRJNA1093008_S_NODE_101558_length_208_cov_484.555556_g101231_i0 | PRJNA1093008 | 101558 | 208 | 484.555556 | 1007.87555648 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 361 | 2.67e-95 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g101231 | i0 | 97.653 | 125.403846153846 | 213 | 0 | 100 | 1 | 1 | 208 | 1282 | 1494 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26084 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23151066 | 23151066 | PRJNA1093008_S_NODE_70099_length_264_cov_2.853403_g69772_i0 | PRJNA1093008 | 70099 | 264 | 2.853403 | 7.53298392 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 359 | 1.27e-94 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g69772 | i0 | 94.468 | 101.643939393939 | 235 | 10 | 89 | 3 | 9 | 240 | 974 | 740 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 26834 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23151179 | 23151179 | PRJNA1093008_S_NODE_83619_length_249_cov_6.619318_g83292_i0 | PRJNA1093008 | 83619 | 249 | 6.619318 | 16.48210182 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 427 | 3.2e-115 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g83292 | i0 | 97.6 | 2.50602409638554 | 250 | 4 | 99 | 1 | 1 | 248 | 148 | 397 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 624 | 427 | 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);;