metadata: contig_metadata: 3 rows where bioproject = "PRJNA760976" and tax

3 rows where bioproject = "PRJNA760976" 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
21145000	21145000	PRJNA760976_P_NODE_56577_length_241_cov_0.886905_g56256_i0	PRJNA760976	56577	241	0.886905	2.13744105	Pectinaria gouldii	260746	Annelida	Annelida	121	2.81e-33	NR	ADW95791.1	260746	g56256	i0	91	1.66804979253112	67	6	83.4	0	3	203	81	147	ADW95791.1 40S ribosomal S16-like protein [Pectinaria gouldii]	diamond	402	121	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Pectinariidae	Pectinaria	Pectinaria gouldii
29516073	29516073	PRJNA760976_P_NODE_57770_length_229_cov_2.064103_g57449_i0	PRJNA760976	57770	229	2.064103	4.72679587	Helobdella robusta	6412	Annelida	Annelida	82.4	2.79e-17	NR	XP_009021316.1	6412	g57449	i0	60.9	6.39301310043668	69	27	90.4	0	208	2	71	139	XP_009021316.1 hypothetical protein HELRODRAFT_101069 [Helobdella robusta]	diamond	1464	82.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
30401149	30401149	PRJNA760976_P_NODE_31613_length_297_cov_0.977679_g31292_i0	PRJNA760976	31613	297	0.977679	2.90370663	Paralvinella palmiformis	53620	Annelida	Annelida	94.4	6.740000000000001e-22	NR	KAK2168654.1	53620	g31292	i0	55.4	1.86868686868687	92	39	92.9	1	17	292	34	123	KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis]	diamond	555	94.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis

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