metadata: contig_metadata: 5 rows where bioproject = "PRJNA807347", tax_kingdom = "Metazoa" and tax

5 rows where bioproject = "PRJNA807347", tax_kingdom = "Metazoa" 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
11010195	11010195	PRJNA807347_P_NODE_8309_length_286_cov_1.690141_g8206_i0	PRJNA807347	8309	286	1.690141	4.83380326	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	115	3.32e-21	NTclustered	gi\|60700756\|gb\|AY915859.1\|	6182	g8206	i0	87.5	0.363636363636364	104	8	35	1	1	99	105	2	Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds	blastn	104	115	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
17384608	17384608	PRJNA807347_P_NODE_2634_length_520_cov_1.782998_g2531_i0	PRJNA807347	2634	520	1.782998	9.2715896	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	464	5.519999999999999e-126	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g2531	i0	97.77	2.30384615384615	269	6	86	0	179	447	330	62	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	1198	464	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
26737216	26737216	PRJNA807347_P_NODE_17541_length_234_cov_2.565217_g17438_i0	PRJNA807347	17541	234	2.565217	6.00260778	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	47	6.34e-4	NR	AAX25032.2	6182	g17438	i0	76	0.320512820512821	25	6	32.1	0	116	42	86	110	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	75	47	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27591476	27591476	PRJNA807347_P_NODE_4204_length_404_cov_1.489426_g4101_i0	PRJNA807347	4204	404	1.489426	6.01728104	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	87	2.4e-18	NR	AAX25032.2	6182	g4101	i0	54.1	0.727722772277228	98	36	72.8	2	296	3	33	121	AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum]	diamond	294	87	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30559475	30559475	PRJNA807347_P_NODE_8773_length_281_cov_1.052885_g8670_i0	PRJNA807347	8773	281	1.052885	2.95860685	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	50.1	8.51e-6	NR	ABA40899.1	6182	g8670	i0	59	0.416370106761566	39	14	39.5	1	235	125	4	42	ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum]	diamond	117	50.1	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);;