metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA738523" 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
21599930	21599930	PRJNA738523_P_NODE_7517_length_279_cov_1.121359_g7446_i0	PRJNA738523	7517	279	1.121359	3.12859161	Clitellata	42113	Annelida	Annelida	146	1.07e-40	NR	WVD50229.1	6386	g7446	i0	75.3	7	93	23	100	0	1	279	121	213	WVD50229.1 glyceraldehyde-3-phosphate dehydrogenase [Tubifex tubifex]	diamond	1953	146	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Tubificida	Naididae	Tubifex	Tubifex tubifex
26704075	26704075	PRJNA738523_P_NODE_5801_length_301_cov_1.688596_g5730_i0	PRJNA738523	5801	301	1.688596	5.08267396	Arenicola marina	6344	Annelida	Annelida	73.2	2.08e-13	NR	ABW23137.1	6344	g5730	i0	64.2	2.08305647840532	53	19	52.8	0	2	160	147	199	ABW23137.1 ribosomal protein rps3a, partial [Arenicola marina]	diamond	627	73.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Arenicolidae	Arenicola	Arenicola marina
26936001	26936001	PRJNA738523_P_NODE_5842_length_300_cov_1.850220_g5771_i0	PRJNA738523	5842	300	1.85022	5.55066	root	1	Root_unresolved	Root_unresolved	102	8.98e-25	NR	XP_009020778.1	6412	g5771	i0	70.5	15.79	61	18	61	0	117	299	1	61	XP_009020778.1 hypothetical protein HELRODRAFT_185729 [Helobdella robusta]	diamond	4737	103	0.990291262135922	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28483889	28483889	PRJNA738523_P_NODE_16306_length_241_cov_0.916667_g16235_i0	PRJNA738523	16306	241	0.916667	2.20916747	Metazoa	33208	Annelida	Annelida	43.5	0.0184	NR	CAH1776380.1	6347	g16235	i0	48.3	2.36514522821577	29	15	36.1	0	227	141	385	413	CAH1776380.1 unnamed protein product [Owenia fusiformis]	diamond	570	43.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
31284693	31284693	PRJNA738523_P_NODE_6755_length_286_cov_1.906103_g6684_i0	PRJNA738523	6755	286	1.906103	5.45145458	Ridgeia piscesae	27915	Annelida	Annelida	69.7	1.57e-11	NR	KAK2163497.1	27915	g6684	i0	38.8	1.82517482517483	85	52	89.2	0	281	27	233	317	KAK2163497.1 hypothetical protein NP493_1459g00022 [Ridgeia piscesae]	diamond	522	69.7	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae
31822323	31822323	PRJNA738523_P_NODE_11877_length_249_cov_0.875000_g11806_i0	PRJNA738523	11877	249	0.875	2.17875	Helobdella robusta	6412	Annelida	Annelida	89	9.67e-19	NR	XP_009031044.1	6412	g11806	i0	56.5	4.96385542168675	85	34	98.8	1	246	1	76	160	XP_009031044.1 hypothetical protein HELRODRAFT_186207 [Helobdella robusta]	diamond	1236	89	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32812258	32812258	PRJNA738523_P_NODE_15800_length_241_cov_2.244048_g15729_i0	PRJNA738523	15800	241	2.244048	5.40815568	Metazoa	33208	Annelida	Annelida	52.4	6.74e-6	NR	CAH1783075.1	6347	g15729	i0	57.5	6.13692946058091	40	17	49.8	0	2	121	144	183	CAH1783075.1 unnamed protein product, partial [Owenia fusiformis]	diamond	1479	52.4	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);;