metadata: contig_metadata: 3 rows where bioproject = "PRJEB2925" and tax

3 rows where bioproject = "PRJEB2925" 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
26076	26076	PRJEB2925_P_NODE_2281_length_1060_cov_2.792195_g1700_i0	PRJEB2925	2281	1060	2.792195	29.597267	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	264	2.3799999999999995e-82	NR	AAN28680.1	13286	g1700	i0	52.7	3.16698113207547	279	115	75.6	10	191	991	78	351	AAN28680.1 cathepsin L [Theromyzon tessulatum]	diamond	3357	265	0.99622641509434	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Theromyzon	Theromyzon tessulatum
28170297	28170297	PRJEB2925_P_NODE_13646_length_281_cov_1.317073_g12368_i0	PRJEB2925	13646	281	1.317073	3.70097513	Helobdella robusta	6412	Annelida	Annelida	63.2	4.5e-10	NR	XP_009012840.1	6412	g12368	i0	72.7	1.40925266903915	33	9	35.2	0	1	99	28	60	XP_009012840.1 hypothetical protein HELRODRAFT_185375 [Helobdella robusta]	diamond	396	63.2	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Clitellata	Rhynchobdellida	Glossiphoniidae	Helobdella	Helobdella robusta
28864854	28864854	PRJEB2925_P_NODE_13528_length_283_cov_1.725806_g12250_i0	PRJEB2925	13528	283	1.725806	4.88403098	Capitella teleta	283909	Annelida	Annelida	46.6	0.00266	NR	ELU16128.1	283909	g12250	i0	28.1	1.01766784452297	96	61	93.3	2	4	267	239	334	ELU16128.1 hypothetical protein CAPTEDRAFT_182417 [Capitella teleta]	diamond	288	46.6	1	Eukaryota	Opisthokonta	Metazoa	Annelida	Polychaeta		Capitellidae	Capitella	Capitella teleta

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