metadata: contig_metadata: 5 rows where bioproject = "PRJNA1008624", tax_clade = "Opisthokonta" and tax

5 rows where bioproject = "PRJNA1008624", tax_clade = "Opisthokonta" 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
6531982	6531982	PRJNA1008624_P_NODE_10126_length_262_cov_2.361502_g9938_i0	PRJNA1008624	10126	262	2.361502	6.18713524	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	407	4.43e-109	NTclustered	gi\|926460157\|gb\|KR132223.1\|	282301	g9938	i0	94.981	0.988549618320611	259	13	99	0	4	262	274	532	Macrostomum lignano clone c100550_g1_i1 mRNA sequence	blastn	259	407	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
15456825	15456825	PRJNA1008624_P_NODE_22453_length_183_cov_2.179104_g22265_i0	PRJNA1008624	22453	183	2.179104	3.98776032	Monotoplana cf. diorchis	104924	Platyhelminthes	Platyhelminthes	73.1	1.2e-8	NTclustered	gi\|10944981\|emb\|AJ270174.1\|	104924	g22265	i0	100	20.4535519125683	39	0	21	0	8	46	1633	1595	Monotoplana cf. diorchis partial 28S rRNA gene	blastn	3743	73.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Proseriata	Monotoplanidae	Monotoplana	Monotoplana cf. diorchis
28195457	28195457	PRJNA1008624_P_NODE_14046_length_224_cov_1.571429_g13858_i0	PRJNA1008624	14046	224	1.571429	3.52000096	Metazoa	33208	Platyhelminthes	Platyhelminthes	48.5	2.69e-4	NR	VDL63316.1	6216	g13858	i0	41.2	2.07589285714286	51	30	68.3	0	34	186	615	665	VDL63316.1 unnamed protein product [Hymenolepis diminuta]	diamond	465	48.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
30097582	30097582	PRJNA1008624_P_NODE_20232_length_191_cov_1.338028_g20044_i0	PRJNA1008624	20232	191	1.338028	2.55563348	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	42.4	0.0241	NR	XP_051074117.1	6185	g20044	i0	41.5	0.832460732984293	53	27	83.2	1	23	181	71	119	XP_051074117.1 Mitochondrial GTPase, variant 2 [Schistosoma haematobium]	diamond	159	42.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
30603089	30603089	PRJNA1008624_P_NODE_30133_length_167_cov_0.881356_g29945_i0	PRJNA1008624	30133	167	0.881356	1.47186452	Schistosoma intercalatum	6187	Platyhelminthes	Platyhelminthes	45.8	0.00106	NR	CAH8551147.1	6187	g29945	i0	41.5	2.64071856287425	53	24	82.6	1	13	150	127	179	CAH8551147.1 unnamed protein product [Schistosoma intercalatum]	diamond	441	45.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma intercalatum

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