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

5 rows where bioproject = "PRJNA385073", 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
3626916	3626916	PRJNA385073_P_NODE_33063_length_270_cov_3.319797_g32901_i0	PRJNA385073	33063	270	3.319797	8.9634519	Metazoa	33208	Platyhelminthes	Platyhelminthes	499	7.349999999999998e-137	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g32901	i0	100	100	270	0	100	0	1	270	128	397	Schistosoma japonicum unknown mRNA	blastn	27000	499	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
4233226	4233226	PRJNA385073_P_NODE_42624_length_250_cov_2.610169_g42462_i0	PRJNA385073	42624	250	2.610169	6.5254225	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	444	3.1999999999999986e-120	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g42462	i0	98.795	38.512	249	3	99	0	1	249	2219	2467	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	9628	444	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
10609464	10609464	PRJNA385073_P_NODE_23389_length_302_cov_1.344978_g23227_i0	PRJNA385073	23389	302	1.344978	4.06183356	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	199	2.65e-60	NR	RTG88961.1	6184	g23227	i0	94	504.586092715232	100	6	99.3	0	301	2	196	295	RTG88961.1 tubulin beta [Schistosoma bovis]	diamond	152385	201	0.990049751243781	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma bovis
13159624	13159624	PRJNA385073_P_NODE_33111_length_270_cov_2.345178_g32949_i0	PRJNA385073	33111	270	2.345178	6.3319806	Gyratrix hermaphroditus	84080	Platyhelminthes	Platyhelminthes	366	7.78e-97	NTclustered	gi\|588313922\|gb\|KC869880.1\|	84080	g32949	i0	91.176	93.637037037037	272	21	100	2	1	270	2093	1823	Gyratrix hermaphroditus 28S ribosomal RNA gene, partial sequence	blastn	25282	366	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Polycystididae	Gyratrix	Gyratrix hermaphroditus
32256934	32256934	PRJNA385073_P_NODE_52898_length_244_cov_1.654971_g52736_i0	PRJNA385073	52898	244	1.654971	4.03812924	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	99.4	1.66e-22	NR	PAA83354.1	282301	g52736	i0	92	0.614754098360656	50	4	61.5	0	152	3	240	289	PAA83354.1 hypothetical protein BOX15_Mlig030284g2 [Macrostomum lignano]	diamond	150	99.4	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);;