metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJEB20058" and tax

5 rows where analysis = "diamond", bioproject = "PRJEB20058" 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
25786563	25786563	PRJEB20058_P_NODE_139203_length_330_cov_2.141264_g136382_i0	PRJEB20058	139203	330	2.141264	7.0661712	Helobdella robusta	6412	Annelida	Annelida	204	1.32e-63	NR	XP_009029388.1	6412	g136382	i0	90.7	0.972727272727273	107	10	97.3	0	328	8	169	275	XP_009029388.1 hypothetical protein HELRODRAFT_186126 [Helobdella robusta]	diamond	321	204	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32996169	32996169	PRJEB20058_P_NODE_158851_length_301_cov_6.295833_g156028_i0	PRJEB20058	158851	301	6.295833	18.95045733	Eisenia fetida	6396	Annelida	Annelida	65.9	5.54e-10	NR	YP_010437803.1	6396	g156028	i0	81	0.418604651162791	42	8	41.9	0	127	2	527	568	YP_010437803.1 NADH dehydrogenase subunit 5 [Eisenia fetida]	diamond	126	65.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Crassiclitellata	Lumbricidae	Eisenia	Eisenia fetida
33076571	33076571	PRJEB20058_P_NODE_239085_length_217_cov_6.871795_g236260_i0	PRJEB20058	239085	217	6.871795	14.91179515	Metazoa	33208	Annelida	Annelida	79.7	3.16e-17	NR	ABW23182.1	6344	g236260	i0	95	3.63594470046083	40	2	55.3	0	62	181	77	116	ABW23182.1 ribosomal protein rpl27a, partial [Arenicola marina]	diamond	789	79.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
33081388	33081388	PRJEB20058_P_NODE_146294_length_319_cov_3.158915_g143473_i0	PRJEB20058	146294	319	3.158915	10.07693885	Arenicola marina	6344	Annelida	Annelida	81.6	1.98e-15	NR	UCK81632.1	6344	g143473	i0	45.7	0.761755485893417	81	42	76.2	1	73	315	479	557	UCK81632.1 prosaposin [Arenicola marina]	diamond	243	81.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
33098294	33098294	PRJEB20058_P_NODE_115982_length_372_cov_7.720257_g113167_i0	PRJEB20058	115982	372	7.720257	28.71935604	Paralvinella palmiformis	53620	Annelida	Annelida	163	5.3e-47	NR	KAK2161514.1	53620	g113167	i0	75.7	6.62096774193548	103	25	83.1	0	25	333	196	298	KAK2161514.1 hypothetical protein LSH36_115g05058 [Paralvinella palmiformis]	diamond	2463	163	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);;