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

7 rows where analysis = "diamond", bioproject = "PRJEB14175" 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
32960110	32960110	PRJEB14175_P_NODE_152250_length_274_cov_2.746479_g149983_i0	PRJEB14175	152250	274	2.746479	7.52535246	Eurythoe complanata	167815	Annelida	Annelida	62.4	2.43e-9	NR	ABW23216.1	167815	g149983	i0	65.8	0.416058394160584	38	13	41.6	0	253	140	171	208	ABW23216.1 ribosomal protein rpl10 [Eurythoe complanata]	diamond	114	62.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Eunicida	Amphinomidae	Eurythoe	Eurythoe complanata
33012094	33012094	PRJEB14175_P_NODE_246308_length_204_cov_1.342657_g244040_i0	PRJEB14175	246308	204	1.342657	2.73902028	Lamellibrachia satsuma	104711	Annelida	Annelida	42.4	0.031	NR	KAI0214697.1	104711	g244040	i0	42.5	1.07352941176471	73	27	85.3	3	201	28	90	162	KAI0214697.1 hypothetical protein LSAT2_000182, partial [Lamellibrachia satsuma]	diamond	219	42.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Lamellibrachia	Lamellibrachia satsuma
33029975	33029975	PRJEB14175_P_NODE_94044_length_371_cov_6.280645_g91778_i0	PRJEB14175	94044	371	6.280645	23.30119295	Helobdella robusta	6412	Annelida	Annelida	87.4	2.97e-19	NR	XP_009014359.1	6412	g91778	i0	73.2	0.574123989218329	71	19	57.4	0	370	158	61	131	XP_009014359.1 hypothetical protein HELRODRAFT_127118, partial [Helobdella robusta]	diamond	213	87.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
33059210	33059210	PRJEB14175_P_NODE_249173_length_203_cov_4.492958_g246905_i0	PRJEB14175	249173	203	4.492958	9.12070474	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	48.5	7.22e-5	NR	XP_009020742.1	6412	g246905	i0	84.6	3.96059113300493	26	4	38.4	0	23	100	122	147	XP_009020742.1 hypothetical protein HELRODRAFT_82387 [Helobdella robusta]	diamond	804	48.9	0.991820040899796	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
33080866	33080866	PRJEB14175_P_NODE_71270_length_436_cov_7.120000_g69011_i0	PRJEB14175	71270	436	7.12	31.0432	Capitella teleta	283909	Annelida	Annelida	77.8	1.35e-13	NR	ELU15384.1	283909	g69011	i0	38.1	0.777522935779816	113	67	76.4	2	33	365	272	383	ELU15384.1 hypothetical protein CAPTEDRAFT_174334 [Capitella teleta]	diamond	339	77.8	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta
33110158	33110158	PRJEB14175_P_NODE_134614_length_297_cov_3.059322_g132347_i0	PRJEB14175	134614	297	3.059322	9.08618634	root	1	Root_unresolved	Root_unresolved	93.2	1.32e-19	NR	KAK2147622.1	53620	g132347	i0	48.3	30.7474747474747	87	45	87.9	0	20	280	235	321	KAK2147622.1 hypothetical protein LSH36_544g05042 [Paralvinella palmiformis]	diamond	9132	94	0.991489361702128	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Terebellida	Alvinellidae	Paralvinella	Paralvinella palmiformis
33144732	33144732	PRJEB14175_P_NODE_88527_length_385_cov_3.246914_g86262_i0	PRJEB14175	88527	385	3.246914	12.5006189	Metazoa	33208	Annelida	Annelida	116	2.02e-28	NR	KAK2158351.1	53620	g86262	i0	56.3	4.04415584415584	103	45	80.3	0	365	57	59	161	KAK2158351.1 hypothetical protein LSH36_172g02010 [Paralvinella palmiformis]	diamond	1557	116	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);;