metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA789095" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA789095" and tax_phylum = "Annelida"

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
27568348	27568348	PRJNA789095_P_NODE_24904_length_450_cov_1.119363_g23572_i0	PRJNA789095	24904	450	1.119363	5.0371335	Metazoa	33208	Annelida	Annelida	191	2.27e-53	NR	CAH1793612.1	6347	g23572	i0	71.2	96.3266666666667	132	35	88	1	448	53	176	304	CAH1793612.1 unnamed protein product [Owenia fusiformis]	diamond	43347	192	0.994791666666667	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
28127703	28127703	PRJNA789095_P_NODE_57665_length_268_cov_4.430769_g56331_i0	PRJNA789095	57665	268	4.430769	11.87446092	Capitella teleta	283909	Annelida	Annelida	52.4	1.38e-5	NR	ELU10826.1	283909	g56331	i0	39	0.66044776119403	59	36	66	0	179	3	86	144	ELU10826.1 hypothetical protein CAPTEDRAFT_200270 [Capitella teleta]	diamond	177	52.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
28885264	28885264	PRJNA789095_P_NODE_70148_length_246_cov_8.867052_g68814_i0	PRJNA789095	70148	246	8.867052	21.81294792	Helobdella robusta	6412	Annelida	Annelida	41.6	0.0363	NR	XP_009014082.1	6412	g68814	i0	45.8	0.585365853658537	48	26	58.5	0	246	103	13	60	XP_009014082.1 hypothetical protein HELRODRAFT_169997 [Helobdella robusta]	diamond	144	41.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
29769347	29769347	PRJNA789095_P_NODE_81151_length_209_cov_6.323529_g79817_i0	PRJNA789095	81151	209	6.323529	13.21617561	Lamellibrachia satsuma	104711	Annelida	Annelida	85.9	1.5e-17	NR	KAI0237845.1	104711	g79817	i0	65.2	0.990430622009569	69	24	99	0	209	3	31	99	KAI0237845.1 Serine hydroxymethyltransferase, cytosolic [Lamellibrachia satsuma]	diamond	207	85.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30157479	30157479	PRJNA789095_P_NODE_42452_length_310_cov_2.708861_g41118_i0	PRJNA789095	42452	310	2.708861	8.3974691	Metazoa	33208	Annelida	Annelida	101	2.33e-22	NR	XP_009018356.1	6412	g41118	i0	98	19.6548387096774	49	1	47.4	0	163	309	442	490	XP_009018356.1 hypothetical protein HELRODRAFT_191960 [Helobdella robusta]	diamond	6093	102	0.990196078431373	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30789613	30789613	PRJNA789095_P_NODE_65254_length_252_cov_1.368715_g63920_i0	PRJNA789095	65254	252	1.368715	3.4491618	Opisthokonta	33154	Annelida	Annelida	88.2	3.88e-18	NR	CAH1795454.1	6347	g63920	i0	56.6	3.95238095238095	83	35	98.8	1	2	250	428	509	CAH1795454.1 unnamed protein product [Owenia fusiformis]	diamond	996	89	0.991011235955056	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis

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