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

6 rows where analysis = "diamond", bioproject = "PRJNA1040136" and tax_clade = "Embryophyta"

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
7822345	7822345	PRJNA1040136_S_NODE_1367_length_294_cov_1.045249_g1364_i0	PRJNA1040136	1367	294	1.045249	3.07303206	Magnoliopsida	3398	Plants	Plants	103	2.73e-25	NR	KAL4038760.1	3656	g1364	i0	83.3	10.7551020408163	66	10	66.3	1	293	99	129	194	KAL4038760.1 hypothetical protein IC575_002385 [Cucumis melo]	diamond	3162	104	0.990384615384615	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Cucurbitales	Cucurbitaceae	Cucumis	Cucumis melo
27382968	27382968	PRJNA1040136_S_NODE_203_length_515_cov_2.205882_g200_i0	PRJNA1040136	203	515	2.205882	11.3602923	Camellia sinensis	4442	Plants	Plants	48.5	0.0021	NR	CAL5381229.1	4442	g200	i0	58.5	0.792233009708738	41	17	23.9	0	366	488	38	78	CAL5381229.1 unnamed protein product [Camellia sinensis]	diamond	408	48.5	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Ericales	Theaceae	Camellia	Camellia sinensis
28330003	28330003	PRJNA1040136_S_NODE_2286_length_251_cov_1.297753_g2283_i0	PRJNA1040136	2286	251	1.297753	3.25736003	Hordeum vulgare subsp. vulgare	112509	Plants	Plants	89.4	5.36e-19	NR	BAK02778.1	112509	g2283	i0	64.4	0.705179282868526	59	21	70.5	0	251	75	270	328	BAK02778.1 predicted protein [Hordeum vulgare subsp. vulgare]	diamond	177	89.4	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Hordeum	Hordeum vulgare
28519679	28519679	PRJNA1040136_S_NODE_767_length_348_cov_1.920000_g764_i0	PRJNA1040136	767	348	1.92	6.6816	Sphagnum balticum	128184	Plants	Plants	90.1	6.87e-19	NR	CAM6000927.1	128184	g764	i0	61.3	0.53448275862069	62	24	53.4	0	329	144	244	305	CAM6000927.1 unnamed protein product [Sphagnum balticum]	diamond	186	90.1	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Sphagnopsida	Sphagnales	Sphagnaceae	Sphagnum	Sphagnum balticum
30193083	30193083	PRJNA1040136_S_NODE_932_length_325_cov_1.119048_g929_i0	PRJNA1040136	932	325	1.119048	3.636906	Lolium perenne	4522	Plants	Plants	73.6	8.45e-14	NR	XP_051191274.1	4522	g929	i0	54.7	3.61846153846154	64	29	59.1	0	325	134	89	152	XP_051191274.1 eukaryotic translation initiation factor 5A-1-like [Lolium perenne]	diamond	1176	73.6	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Magnoliopsida	Poales	Poaceae	Lolium	Lolium perenne
31046538	31046538	PRJNA1040136_S_NODE_2755_length_241_cov_0.916667_g2752_i0	PRJNA1040136	2755	241	0.916667	2.20916747	Physcomitrium patens	3218	Plants	Plants	102	6.3299999999999986e-24	NR	XP_024388585.1	3218	g2752	i0	64.5	11.3526970954357	76	26	93.4	1	239	15	183	258	XP_024388585.1 60S acidic ribosomal protein P0-like [Physcomitrium patens]	diamond	2736	102	1	Eukaryota	Embryophyta	Viridiplantae	Streptophyta	Bryopsida	Funariales	Funariaceae	Physcomitrium	Physcomitrium patens

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