metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA407886" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA407886" 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
14445928	14445928	PRJNA407886_P_NODE_22912_length_512_cov_2.143508_g21222_i0	PRJNA407886	22912	512	2.143508	10.97476096	Theromyzon tessulatum	13286	Annelida	Annelida	189	1.0799999999999998e-55	NR	AAN28680.1	13286	g21222	i0	58.3	1.025390625	175	60	95.5	7	1	489	178	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	525	189	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
28292159	28292159	PRJNA407886_P_NODE_47186_length_315_cov_0.896694_g45492_i0	PRJNA407886	47186	315	0.896694	2.8245861	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	64.7	9.14e-10	NR	KAI0211856.1	104711	g45492	i0	32.7	18.8857142857143	104	57	99	3	1	312	33	123	KAI0211856.1 Transmembrane emp24 domain-containing protein eca [Lamellibrachia satsuma]	diamond	5949	65.1	0.993855606758833	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
28780674	28780674	PRJNA407886_P_NODE_57387_length_281_cov_2.216346_g55693_i0	PRJNA407886	57387	281	2.216346	6.22793226	Paralvinella palmiformis	53620	Annelida	Annelida	135	2.79e-37	NR	KAK2156730.1	53620	g55693	i0	73.4	1.00355871886121	94	23	98.2	1	4	279	121	214	KAK2156730.1 hypothetical protein LSH36_206g00022 [Paralvinella palmiformis]	diamond	282	135	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
30218447	30218447	PRJNA407886_P_NODE_15932_length_685_cov_1.501634_g14294_i0	PRJNA407886	15932	685	1.501634	10.2861929	Metazoa	33208	Annelida	Annelida	119	8.4e-27	NR	KAI0228243.1	104711	g14294	i0	33.2	3.0043795620438	229	142	99.9	7	1	684	259	477	KAI0228243.1 Actin-interacting protein 1 [Lamellibrachia satsuma]	diamond	2058	119	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
30818910	30818910	PRJNA407886_P_NODE_56574_length_284_cov_1.085308_g54880_i0	PRJNA407886	56574	284	1.085308	3.08227472	Metazoa	33208	Annelida	Annelida	111	8.300000000000001e-27	NR	CAH1786459.1	6347	g54880	i0	58.1	5.66197183098592	93	39	98.2	0	279	1	255	347	CAH1786459.1 unnamed protein product [Owenia fusiformis]	diamond	1608	112	0.991071428571429	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30882003	30882003	PRJNA407886_P_NODE_76994_length_245_cov_0.895349_g75300_i0	PRJNA407886	76994	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	50.4	7.28e-5	NR	KAK2146323.1	53620	g75300	i0	46.8	1.57959183673469	47	25	57.6	0	241	101	541	587	KAK2146323.1 hypothetical protein LSH36_616g04040 [Paralvinella palmiformis]	diamond	387	50.8	0.992125984251969	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
31307739	31307739	PRJNA407886_P_NODE_42435_length_334_cov_2.210728_g40741_i0	PRJNA407886	42435	334	2.210728	7.38383152	Ridgeia piscesae	27915	Annelida	Annelida	72	2.47e-12	NR	KAK2169273.1	27915	g40741	i0	45.7	2.83832335329341	81	42	71.9	2	312	73	175	254	KAK2169273.1 hypothetical protein NP493_1197g00015 [Ridgeia piscesae]	diamond	948	72	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31782114	31782114	PRJNA407886_P_NODE_76677_length_245_cov_0.895349_g74983_i0	PRJNA407886	76677	245	0.895349	2.19360505	Owenia fusiformis	6347	Annelida	Annelida	63.9	1.27e-9	NR	CAH1780470.1	6347	g74983	i0	46.4	4.0530612244898	84	41	98	1	240	1	72	155	CAH1780470.1 unnamed protein product, partial [Owenia fusiformis]	diamond	993	63.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
32510273	32510273	PRJNA407886_P_NODE_49379_length_306_cov_2.639485_g47685_i0	PRJNA407886	49379	306	2.639485	8.0768241	Owenia fusiformis	6347	Annelida	Annelida	109	2.97e-25	NR	CAH1802338.1	6347	g47685	i0	55	1.96078431372549	100	42	98	2	301	2	371	467	CAH1802338.1 unnamed protein product [Owenia fusiformis]	diamond	600	109	1	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);;