metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB3181" 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
988886	988886	PRJEB3181_S_NODE_5741_length_255_cov_70.177273_g5448_i0	PRJEB3181	5741	255	70.177273	178.95204615	Theromyzon tessulatum	13286	Annelida	Annelida	89.4	7.32e-19	NR	AAN28680.1	13286	g5448	i0	88.9	0.529411764705882	45	5	52.9	0	13	147	307	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	135	89.4	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
29458023	29458023	PRJEB3181_P_NODE_21390_length_176_cov_6.289655_g21125_i0	PRJEB3181	21390	176	6.289655	11.0697928	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	76.6	1.54e-14	NR	CAH1794321.1	6347	g21125	i0	76.2	2.11363636363636	42	10	71.6	0	175	50	386	427	CAH1794321.1 unnamed protein product [Owenia fusiformis]	diamond	372	77	0.994805194805195	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30216186	30216186	PRJEB3181_P_NODE_9172_length_280_cov_8.437751_g8908_i0	PRJEB3181	9172	280	8.437751	23.6257028	Metazoa	33208	Annelida	Annelida	70.5	1.83e-12	NR	CAH1772408.1	6347	g8908	i0	55.1	15.2357142857143	69	31	73.9	0	2	208	113	181	CAH1772408.1 unnamed protein product, partial [Owenia fusiformis]	diamond	4266	70.5	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Oweniidae	Owenia	Owenia fusiformis
30538799	30538799	PRJEB3181_P_NODE_20493_length_181_cov_2.260000_g20229_i0	PRJEB3181	20493	181	2.26	4.0906	Theromyzon tessulatum	13286	Annelida	Annelida	80.1	6.55e-16	NR	AAN28680.1	13286	g20229	i0	89.7	0.646408839779006	39	4	64.6	0	3	119	313	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	117	80.1	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
31076063	31076063	PRJEB3181_P_NODE_12775_length_237_cov_2.131068_g12511_i0	PRJEB3181	12775	237	2.131068	5.05063116	Helobdella robusta	6412	Annelida	Annelida	61.2	8.37e-9	NR	XP_009020629.1	6412	g12511	i0	49.3	0.873417721518987	69	32	87.3	1	237	31	228	293	XP_009020629.1 hypothetical protein HELRODRAFT_185715 [Helobdella robusta]	diamond	207	61.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
32341380	32341380	PRJEB3181_S_NODE_11459_length_190_cov_1.174194_g11166_i0	PRJEB3181	11459	190	1.174194	2.2309686	Ridgeia piscesae	27915	Annelida	Annelida	68.9	6.16e-12	NR	KAK2171970.1	27915	g11166	i0	71.4	3.9	42	12	66.3	0	1	126	144	185	KAK2171970.1 hypothetical protein NP493_1009g01009 [Ridgeia piscesae]	diamond	741	68.9	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta	Sabellida	Siboglinidae	Ridgeia	Ridgeia piscesae

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