contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 155002 | 155002 | PRJNA1010662_S_NODE_2741_length_200_cov_4.554140_g2696_i0 | PRJNA1010662 | 2741 | 200 | 4.55414 | 9.10828 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 359 | 9.14e-95 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g2696 | i0 | 99 | 40.48 | 200 | 2 | 100 | 0 | 1 | 200 | 1819 | 2018 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8096 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 3552054 | 3552054 | PRJNA1010662_S_NODE_303_length_482_cov_3.394077_g260_i0 | PRJNA1010662 | 303 | 482 | 3.394077 | 16.35945114 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 874 | 0 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g260 | i0 | 99.378 | 65.8879668049793 | 482 | 3 | 100 | 0 | 1 | 482 | 323 | 804 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 31758 | 874 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 5257874 | 5257874 | PRJNA1010662_S_NODE_1765_length_237_cov_2.206186_g1720_i0 | PRJNA1010662 | 1765 | 237 | 2.206186 | 5.22866082 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 394 | 3.069999999999999e-105 | NTclustered | gi|926460157|gb|KR132223.1| | 282301 | g1720 | i0 | 97.403 | 0.974683544303797 | 231 | 6 | 97 | 0 | 7 | 237 | 532 | 302 | Macrostomum lignano clone c100550_g1_i1 mRNA sequence | blastn | 231 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 5257888 | 5257888 | PRJNA1010662_S_NODE_3805_length_175_cov_4.356061_g3760_i0 | PRJNA1010662 | 3805 | 175 | 4.356061 | 7.62310675 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 292 | 7.98e-75 | NTclustered | gi|209968753|gb|FJ384954.1| | 52061 | g3760 | i0 | 97.11 | 94.5657142857143 | 173 | 5 | 99 | 0 | 1 | 173 | 695 | 523 | Stenostomum leucops isolate K05_264 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence | blastn | 16549 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 6104665 | 6104665 | PRJNA1010662_S_NODE_4225_length_168_cov_1.576000_g4180_i0 | PRJNA1010662 | 4225 | 168 | 1.576 | 2.64768 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 294 | 2.12e-75 | NTclustered | gi|1095468141|gb|KY008502.1| | 1914034 | g4180 | i0 | 98.214 | 99.9107142857143 | 168 | 3 | 100 | 0 | 1 | 168 | 51 | 218 | Macrostomum qiaochengensis isolate FCY-6 28S ribosomal RNA gene, partial sequence | blastn | 16785 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum qiaochengensis | |
| 9082471 | 9082471 | PRJNA1010662_S_NODE_1888_length_231_cov_1.750000_g1843_i0 | PRJNA1010662 | 1888 | 231 | 1.75 | 4.0425 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 405 | 1.38e-108 | NTclustered | gi|28273263|gb|AY157151.1| | 52061 | g1843 | i0 | 98.268 | 64.3203463203463 | 231 | 4 | 100 | 0 | 1 | 231 | 2494 | 2264 | Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence | blastn | 14858 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 11204769 | 11204769 | PRJNA1010662_S_NODE_2869_length_197_cov_4.915584_g2824_i0 | PRJNA1010662 | 2869 | 197 | 4.915584 | 9.68370048 | Stenostomum | 39238 | Platyhelminthes | Platyhelminthes | 348 | 1.94e-91 | NTclustered | gi|209968707|gb|FJ384870.1| | 52061 | g2824 | i0 | 98.974 | 68.5989847715736 | 195 | 1 | 98 | 1 | 4 | 197 | 262 | 68 | Stenostomum leucops isolate K05_55 28S ribosomal RNA gene, partial sequence | blastn | 13514 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 13754838 | 13754838 | PRJNA1010662_P_NODE_2031_length_356_cov_2.482085_g1972_i0 | PRJNA1010662 | 2031 | 356 | 2.482085 | 8.8362226 | Plagiostomidae | 79797 | Platyhelminthes | Platyhelminthes | 56.5 | 0.003 | NTclustered | gi|28273270|gb|AY157158.1| | 86115 | g1972 | i0 | 97.059 | 7.99438202247191 | 34 | 0 | 9 | 1 | 1 | 33 | 3240 | 3273 | Plicastoma cuticulata 28S large subunit ribosomal RNA gene, partial sequence | blastn | 2846 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Prolecithophora | Plagiostomidae | Plicastoma | Plicastoma cuticulata | |
| 15457585 | 15457585 | PRJNA1010662_S_NODE_3433_length_183_cov_2.685714_g3388_i0 | PRJNA1010662 | 3433 | 183 | 2.685714 | 4.91485662 | Macrostomum sp. 36 JNB-2019 | 2614341 | Platyhelminthes | Platyhelminthes | 279 | 6.57e-71 | NTclustered | gi|1837893144|gb|MT428645.1| | 2614341 | g3388 | i0 | 100 | 83.0382513661202 | 151 | 0 | 83 | 0 | 33 | 183 | 758 | 608 | Macrostomum sp. 36 JNB-2019 voucher MTP_LS_3344 large subunit ribosomal RNA gene, partial sequence | blastn | 15196 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum sp. 36 JNB-2019 | |
| 16304005 | 16304005 | PRJNA1010662_S_NODE_4693_length_161_cov_1.127119_g4648_i0 | PRJNA1010662 | 4693 | 161 | 1.127119 | 1.81466159 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 291 | 2.6e-74 | NTclustered | gi|1837893536|gb|MT429037.1| | 683713 | g4648 | i0 | 99.375 | 99.3788819875776 | 160 | 1 | 99 | 0 | 1 | 160 | 812 | 971 | Macrostomum longituba voucher MTP_LS_3284 large subunit ribosomal RNA gene, partial sequence | blastn | 16000 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum longituba | |
| 17579381 | 17579381 | PRJNA1010662_S_NODE_814_length_323_cov_2.182143_g769_i0 | PRJNA1010662 | 814 | 323 | 2.182143 | 7.04832189 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 597 | 3.11e-166 | NTclustered | gi|210148296|gb|FJ384826.1| | 52061 | g769 | i0 | 100 | 97.2352941176471 | 323 | 0 | 100 | 0 | 1 | 323 | 357 | 35 | Stenostomum leucops isolate K05_26 18S ribosomal RNA gene, partial sequence | blastn | 31407 | 597 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 19280532 | 19280532 | PRJNA1010662_S_NODE_4816_length_159_cov_1.974138_g4771_i0 | PRJNA1010662 | 4816 | 159 | 1.974138 | 3.13887942 | Macrostomum qiaochengensis | 1914034 | Platyhelminthes | Platyhelminthes | 279 | 5.55e-71 | NTclustered | gi|1095468147|gb|KY008498.1| | 1914034 | g4771 | i0 | 99.351 | 97.4213836477987 | 154 | 1 | 97 | 0 | 5 | 158 | 476 | 629 | Macrostomum qiaochengensis isolate FCY-2 18S ribosomal RNA gene, partial sequence | blastn | 15490 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum qiaochengensis | |
| 20556030 | 20556030 | PRJNA1010662_P_NODE_15057_length_164_cov_2.686957_g14998_i0 | PRJNA1010662 | 15057 | 164 | 2.686957 | 4.40660948 | Stenostomum sthenum | 1611831 | Platyhelminthes | Platyhelminthes | 281 | 1.6000000000000001e-71 | NTclustered | gi|1215837197|ref|NC_035256.1| | 1611831 | g14998 | i0 | 97.561 | 2.21341463414634 | 164 | 4 | 100 | 0 | 1 | 164 | 8535 | 8698 | Stenostomum sthenum mitochondrion, complete genome | blastn | 363 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum sthenum | |||
| 21831749 | 21831749 | PRJNA1010662_S_NODE_1678_length_241_cov_3.217172_g1633_i0 | PRJNA1010662 | 1678 | 241 | 3.217172 | 7.75338452 | Macrostomum sp. 36 JNB-2019 | 2614341 | Platyhelminthes | Platyhelminthes | 444 | 3.06e-120 | NTclustered | gi|1837893144|gb|MT428645.1| | 2614341 | g1633 | i0 | 100 | 100.016597510373 | 240 | 0 | 99 | 0 | 2 | 241 | 548 | 309 | Macrostomum sp. 36 JNB-2019 voucher MTP_LS_3344 large subunit ribosomal RNA gene, partial sequence | blastn | 24104 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum sp. 36 JNB-2019 | |
| 23107224 | 23107224 | PRJNA1010662_P_NODE_5319_length_234_cov_1.583784_g5260_i0 | PRJNA1010662 | 5319 | 234 | 1.583784 | 3.70605456 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 158 | 4.32e-34 | NTclustered | gi|924602|gb|U19945.1|SMU19945 | 6183 | g5260 | i0 | 81.592 | 11.7393162393162 | 201 | 27 | 84 | 9 | 38 | 233 | 1176 | 981 | Schistosoma mansoni actin mRNA, complete cds | blastn | 2747 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 25227734 | 25227734 | PRJNA1010662_S_NODE_4780_length_160_cov_0.854701_g4735_i0 | PRJNA1010662 | 4780 | 160 | 0.854701 | 1.3675216 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 296 | 5.55e-76 | NTclustered | gi|926460157|gb|KR132223.1| | 282301 | g4735 | i0 | 100 | 96.28125 | 160 | 0 | 100 | 0 | 1 | 160 | 5021 | 5180 | Macrostomum lignano clone c100550_g1_i1 mRNA sequence | blastn | 15405 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;