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

7 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax_clade = "PVC group"

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_species
27548078	27548078	PRJNA290839_P_NODE_1224_length_249_cov_0.886364_g1203_i0	PRJNA290839	1224	249	0.886364	2.20704636	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	157	6.259999999999999e-45	NR	RYD65414.1	2026800	g1203	i0	85.4	0.987951807228916	82	12	98.8	0	3	248	243	324	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	246	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobiaceae bacterium
29410889	29410889	PRJNA290839_P_NODE_1069_length_252_cov_0.865922_g1048_i0	PRJNA290839	1069	252	0.865922	2.18212344	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	113	8.44e-28	NR	MDB6031664.1	2026801	g1048	i0	65.1	0.988095238095238	83	28	98.8	1	250	2	84	165	MDB6031664.1 nemA [Verrucomicrobiales bacterium]	diamond	249	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales		Verrucomicrobiales bacterium
31496498	31496498	PRJNA290839_P_NODE_576_length_338_cov_1.166038_g555_i0	PRJNA290839	576	338	1.166038	3.94120844	Planctomycetota bacterium	2026780	Bacteria	Bacteria	59.7	1.23e-7	NR	HLX60008.1	2026780	g555	i0	35.8	1.88165680473373	106	55	94.1	3	19	336	200	292	HLX60008.1 phosphoesterase [Planctomycetota bacterium]	diamond	636	59.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
31685937	31685937	PRJNA290839_P_NODE_897_length_270_cov_1.421320_g876_i0	PRJNA290839	897	270	1.42132	3.837564	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	55.5	1.72e-6	NR	MCK4659756.1	2026778	g876	i0	36.6	0.911111111111111	82	44	84.4	3	38	265	373	452	MCK4659756.1 thrombospondin type 3 repeat-containing protein [Phycisphaerae bacterium]	diamond	246	55.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae			Phycisphaerae bacterium
31717697	31717697	PRJNA290839_P_NODE_917_length_266_cov_1.606218_g896_i0	PRJNA290839	917	266	1.606218	4.27253988	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	46.2	0.00304	NR	MEZ6091142.1	2699754	g896	i0	44.2	0.484962406015038	43	24	48.5	0	264	136	315	357	MEZ6091142.1 hypothetical protein [Pirellulaceae bacterium]	diamond	129	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellulaceae bacterium
32034099	32034099	PRJNA290839_P_NODE_1458_length_245_cov_0.906977_g1437_i0	PRJNA290839	1458	245	0.906977	2.22209365	Planctomycetota bacterium	2026780	Bacteria	Bacteria	63.5	1.77e-9	NR	MCY2924072.1	2026780	g1437	i0	55.2	0.710204081632653	58	26	71	0	65	238	565	622	MCY2924072.1 hypothetical protein [Planctomycetota bacterium]	diamond	174	63.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota				Planctomycetota bacterium
32729397	32729397	PRJNA290839_P_NODE_1500_length_244_cov_0.912281_g1479_i0	PRJNA290839	1500	244	0.912281	2.22596564	Chlamydiia bacterium	2052156	Bacteria	Bacteria	76.3	5.86e-14	NR	MCB1118785.1	2052156	g1479	i0	46.3	1.00819672131148	82	41	99.6	2	1	243	362	441	MCB1118785.1 right-handed parallel beta-helix repeat-containing protein [Chlamydiia bacterium]	diamond	246	76.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia			Chlamydiia bacterium

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