metadata: contig_metadata: 8 rows where bioproject = "PRJNA1067370" and tax

8 rows where bioproject = "PRJNA1067370" and tax_phylum = "Fornicata"

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_phylum	tax_order	tax_family	tax_genus	tax_species
26718607	26718607	PRJNA1067370_P_NODE_201_length_2696_cov_12.144491_g19_i2	PRJNA1067370	201	2696	12.144491	327.41547736	Hexamita inflata	28002	Fornicata	other_Eukaryota	67.4	4.03e-7	NR	CAK8761749.1	28002	g19	i2	24.9	1.24629080118694	358	212	36.7	20	2691	1702	2257	2585	CAK8761749.1 HINF_004113 [Hexamita inflata]	diamond	3360	67.4	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
27383456	27383456	PRJNA1067370_P_NODE_94763_length_247_cov_0.885057_g94214_i0	PRJNA1067370	94763	247	0.885057	2.18609079	Kipferlia bialata	797122	Fornicata	other_Eukaryota	73.9	4.1e-13	NR	GIQ81117.1	797122	g94214	i0	54.5	0.935222672064777	77	35	93.5	0	4	234	69	145	GIQ81117.1 hypothetical protein KIPB_002026 [Kipferlia bialata]	diamond	231	73.9	1	Eukaryota	Metamonada	Fornicata			Kipferlia	Kipferlia bialata
27572722	27572722	PRJNA1067370_P_NODE_41584_length_314_cov_12.232365_g41036_i0	PRJNA1067370	41584	314	12.232365	38.4096261	Giardia muris	5742	Fornicata	other_Eukaryota	48.9	3.99e-4	NR	TNJ27030.1	5742	g41036	i0	33.8	1.52866242038217	80	52	76.4	1	72	311	136	214	TNJ27030.1 Translation elongation factor 1-beta [Giardia muris]	diamond	480	48.9	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Giardia	Giardia muris
28038102	28038102	PRJNA1067370_P_NODE_105_length_3594_cov_74.078103_g57_i0	PRJNA1067370	105	3594	74.078103	2662.36702182	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	82	2.11e-11	NR	CAK8761749.1	28002	g57	i0	21.8	0.887312186978297	509	306	38.5	23	1547	165	663	1127	CAK8761749.1 HINF_004113 [Hexamita inflata]	diamond	3189	82	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
28962231	28962231	PRJNA1067370_P_NODE_4948_length_790_cov_1.196653_g4459_i0	PRJNA1067370	4948	790	1.196653	9.4535587	Hexamita inflata	28002	Fornicata	other_Eukaryota	204	2.94e-60	NR	CAK8823628.1	28002	g4459	i0	62.4	3.96835443037975	149	56	56.6	0	1	447	199	347	CAK8823628.1 HINF_021087 [Hexamita inflata]	diamond	3135	204	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29751058	29751058	PRJNA1067370_P_NODE_231_length_2542_cov_12.928311_g19_i3	PRJNA1067370	231	2542	12.928311	328.63766562	Hexamita inflata	28002	Fornicata	other_Eukaryota	64.3	3.18e-6	NR	CAK8806262.1	28002	g19	i3	23.4	1.55664830841857	321	177	32.8	17	8	841	1331	1631	CAK8806262.1 HINF_060711 [Hexamita inflata]	diamond	3957	64.3	1	Eukaryota	Metamonada	Fornicata	Diplomonadida	Hexamitidae	Hexamita	Hexamita inflata
29846089	29846089	PRJNA1067370_P_NODE_43151_length_310_cov_7.966245_g42603_i0	PRJNA1067370	43151	310	7.966245	24.6953595	Carpediemonas membranifera	201153	Fornicata	other_Eukaryota	53.9	9.38e-6	NR	KAG9389987.1	201153	g42603	i0	41.4	0.561290322580645	58	34	56.1	0	133	306	119	176	KAG9389987.1 Chromo (CHRromatin Organization MOdifier) domain [Carpediemonas membranifera]	diamond	174	53.9	1	Eukaryota	Metamonada	Fornicata			Carpediemonas	Carpediemonas membranifera
30478097	30478097	PRJNA1067370_P_NODE_68033_length_268_cov_0.876923_g67484_i0	PRJNA1067370	68033	268	0.876923	2.35015364	Aduncisulcus paluster	2918883	Fornicata	other_Eukaryota	97.8	2.2400000000000003e-21	NR	GKT17092.1	2918883	g67484	i0	56.6	6.34701492537313	76	33	85.1	0	1	228	675	750	GKT17092.1 Sodium/potassium-transporting ATPase subunit alpha-4 [Aduncisulcus paluster]	diamond	1701	97.8	1	Eukaryota	Metamonada	Fornicata			Aduncisulcus	Aduncisulcus paluster

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