metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA906294" and tax_phylum = "Platyhelminthes"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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
8542969	8542969	PRJNA906294_P_NODE_97187_length_424_cov_7.210826_g93072_i0	PRJNA906294	97187	424	7.210826	30.57390224	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	704	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g93072	i0	96.698	1	424	13	100	1	1	424	27	449	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	424	704	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
11091060	11091060	PRJNA906294_P_NODE_190949_length_264_cov_1.591623_g186833_i0	PRJNA906294	190949	264	1.591623	4.20188472	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	339	1.65e-88	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g186833	i0	90.038	0.988636363636364	261	26	99	0	4	264	278	18	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	261	339	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12728178	12728178	PRJNA906294_P_NODE_234730_length_208_cov_4.274074_g230614_i0	PRJNA906294	234730	208	4.274074	8.89007392	Metazoa	33208	Platyhelminthes	Platyhelminthes	261	2.78e-65	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g230614	i0	99.306	69.2307692307692	144	1	69	0	65	208	119	262	Schistosoma japonicum unknown mRNA	blastn	14400	261	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
16550673	16550673	PRJNA906294_P_NODE_122713_length_358_cov_1.066667_g118597_i0	PRJNA906294	122713	358	1.066667	3.81866786	Metazoa	33208	Platyhelminthes	Platyhelminthes	660	0	NTclustered	gi\|60600609\|gb\|AY810873.1\|	6182	g118597	i0	100	51.1368715083799	357	0	99	0	2	358	451	95	Schistosoma japonicum clone SJCHGC07419 unknown mRNA	blastn	18307	660	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
18738081	18738081	PRJNA906294_P_NODE_155555_length_304_cov_1.268398_g151439_i0	PRJNA906294	155555	304	1.268398	3.85592992	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	309	1.5200000000000002e-79	NTclustered	gi\|58197522\|dbj\|AB200392.1\|	6161	g151439	i0	87.833	74.8256578947368	263	32	87	0	41	303	40	302	Dugesia japonica CaM mRNA for calmodulin, complete cds	blastn	22747	309	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica

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);;