metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA807685" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA807685" 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
27505612	27505612	PRJNA807685_P_NODE_42023_length_189_cov_1.572368_g40950_i0	PRJNA807685	42023	189	1.572368	2.97177552	Metazoa	33208	Annelida	Annelida	62	2.09e-9	NR	KAI0212821.1	104711	g40950	i0	80	1.61904761904762	35	7	55.6	0	85	189	2	36	KAI0212821.1 N-alpha-acetyltransferase 15, NatA auxiliary subunit [Lamellibrachia satsuma]	diamond	306	62.4	0.993589743589744	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
29273361	29273361	PRJNA807685_P_NODE_23629_length_277_cov_2.287500_g22556_i0	PRJNA807685	23629	277	2.2875	6.336375	Metazoa	33208	Annelida	Annelida	57.4	3.91e-7	NR	ELU00056.1	283909	g22556	i0	38.8	7.59205776173285	98	49	98.6	4	3	275	735	828	ELU00056.1 hypothetical protein CAPTEDRAFT_195211 [Capitella teleta]	diamond	2103	57.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
30126024	30126024	PRJNA807685_P_NODE_49652_length_173_cov_1.713235_g48579_i0	PRJNA807685	49652	173	1.713235	2.96389655	Metazoa	33208	Annelida	Annelida	99	1.33e-22	NR	KAK2145251.1	53620	g48579	i0	82.7	24.3468208092486	52	9	90.2	0	157	2	110	161	KAK2145251.1 hypothetical protein LSH36_692g01011 [Paralvinella palmiformis]	diamond	4212	99	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30473940	30473940	PRJNA807685_P_NODE_52333_length_169_cov_1.128788_g51260_i0	PRJNA807685	52333	169	1.128788	1.90765172	Metazoa	33208	Annelida	Annelida	49.7	4.57e-5	NR	XP_009024344.1	6412	g51260	i0	64.7	5.37869822485207	34	12	60.4	0	161	60	17	50	XP_009024344.1 hypothetical protein HELRODRAFT_114186 [Helobdella robusta]	diamond	909	50.1	0.992015968063872	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta

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