metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Tardigrada"

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
3042379	3042379	PRJNA520845_P_NODE_257323_length_243_cov_0.905882_g255824_i0	PRJNA520845	257323	243	0.905882	2.20129326	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	137	1.85e-39	NR	OWA53126.1	2072580	g255824	i0	71.6	1	81	23	100	0	243	1	32	112	OWA53126.1 60S ribosomal protein L21 [Hypsibius exemplaris]	diamond	243	137	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
27377359	27377359	PRJNA520845_P_NODE_159443_length_295_cov_1.229730_g157944_i0	PRJNA520845	159443	295	1.22973	3.6277035	Metazoa	33208	Tardigrada	other_Eukaryota	85.9	5.72e-19	NR	OWA49937.1	2072580	g157944	i0	49.5	2.45084745762712	99	38	88.5	6	263	3	3	101	OWA49937.1 hypothetical protein BV898_14471 [Hypsibius exemplaris]	diamond	723	86.7	0.990772779700115	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
28813843	28813843	PRJNA520845_P_NODE_129868_length_328_cov_0.905882_g128369_i0	PRJNA520845	129868	328	0.905882	2.97129296	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	64.3	2.09e-9	NR	XP_055342421.1	2943436	g128369	i0	32.4	1.85670731707317	108	69	97	3	322	5	132	237	XP_055342421.1 transmembrane protein 151 homolog [Paramacrobiotus metropolitanus]	diamond	609	64.3	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus
28877216	28877216	PRJNA520845_P_NODE_146408_length_309_cov_0.978814_g144909_i0	PRJNA520845	146408	309	0.978814	3.02453526	Hypsibius exemplaris	2072580	Tardigrada	other_Eukaryota	47	0.00229	NR	OQV22614.1	2072580	g144909	i0	32.2	0.844660194174757	87	55	83.5	2	260	3	172	255	OQV22614.1 hypothetical protein BV898_03439 [Hypsibius exemplaris]	diamond	261	47	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Hypsibiidae	Hypsibius	Hypsibius exemplaris
29256014	29256014	PRJNA520845_P_NODE_261849_length_242_cov_0.911243_g260350_i0	PRJNA520845	261849	242	0.911243	2.20520806	Paramacrobiotus metropolitanus	2943436	Tardigrada	other_Eukaryota	51.6	2.7e-5	NR	XP_055341759.1	2943436	g260350	i0	41.7	0.59504132231405	48	28	59.5	0	232	89	77	124	XP_055341759.1 ammonium transporter Rh type A-like [Paramacrobiotus metropolitanus]	diamond	144	51.6	1	Eukaryota	Opisthokonta	Metazoa	Tardigrada	Eutardigrada	Parachela	Macrobiotidae	Paramacrobiotus	Paramacrobiotus metropolitanus

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