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

8 rows where analysis = "diamond", bioproject = "PRJEB3181" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
12809661	12809661	PRJEB3181_S_NODE_3851_length_297_cov_510.877863_g3558_i0	PRJEB3181	3851	297	510.877863	1517.30725311	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	63.9	2.09e-9	NR	MDR3737318.1	2052142	g3558	i0	49.3	0.676767676767677	67	33	66.7	1	297	100	241	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	201	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacteriaceae bacterium
27001438	27001438	PRJEB3181_P_NODE_6042_length_335_cov_1.986842_g5785_i0	PRJEB3181	6042	335	1.986842	6.6559207	Blastocatellia bacterium	2052146	Bacteria	Bacteria	92.4	8.11e-20	NR	HBB95416.1	2052146	g5785	i0	45.7	3.32238805970149	92	48	82.4	1	4	279	216	305	HBB95416.1 pirin family protein [Blastocatellia bacterium]	diamond	1113	92.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia			Blastocatellia bacterium
27444454	27444454	PRJEB3181_P_NODE_6083_length_334_cov_4.264026_g5826_i0	PRJEB3181	6083	334	4.264026	14.24184684	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	115	1.72e-29	NR	HSS78324.1	2651171	g5826	i0	53.5	2.64071856287425	99	43	86.2	1	331	44	86	184	HSS78324.1 putative PEP-binding protein [Thermoanaerobaculia bacterium]	diamond	882	115	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia			Thermoanaerobaculia bacterium
28391330	28391330	PRJEB3181_P_NODE_4286_length_381_cov_3.171429_g4039_i0	PRJEB3181	4286	381	3.171429	12.08314449	Acidobacteriaceae bacterium	2052142	Bacteria	Bacteria	84.3	2.04e-16	NR	MDR3737318.1	2052142	g4039	i0	45.8	0.84251968503937	107	51	80.3	3	378	73	203	307	MDR3737318.1 hypothetical protein [Acidobacteriaceae bacterium]	diamond	321	84.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacteriaceae bacterium
29086146	29086146	PRJEB3181_P_NODE_23548_length_167_cov_1.500000_g23283_i0	PRJEB3181	23548	167	1.5	2.505	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	86.7	3.14e-20	NR	MBK9241680.1	1978231	g23283	i0	76.4	0.988023952095808	55	13	98.8	0	167	3	1	55	MBK9241680.1 uL14 family ribosomal protein [Acidobacteriota bacterium]	diamond	165	86.7	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
30949714	30949714	PRJEB3181_P_NODE_10574_length_261_cov_3.686957_g10310_i0	PRJEB3181	10574	261	3.686957	9.62295777	Terriglobales bacterium	2282142	Bacteria	Bacteria	51.6	2.09e-5	NR	HME33021.1	2282142	g10310	i0	37.3	5.49425287356322	67	42	77	0	251	51	124	190	HME33021.1 hypothetical protein [Terriglobales bacterium]	diamond	1434	51.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales		Terriglobales bacterium
31138809	31138809	PRJEB3181_P_NODE_14695_length_220_cov_2.132275_g14431_i0	PRJEB3181	14695	220	2.132275	4.691005	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	79.7	2.58e-15	NR	MCE2513957.1	1978231	g14431	i0	60.9	1.70454545454545	64	25	87.3	0	220	29	465	528	MCE2513957.1 chaperonin GroEL [Acidobacteriota bacterium]	diamond	375	79.7	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota bacterium
31448906	31448906	PRJEB3181_P_NODE_24716_length_162_cov_2.381679_g24451_i0	PRJEB3181	24716	162	2.381679	3.85831998	root	1	Root_unresolved	Root_unresolved	53.9	5.89e-7	NR	MBI1762299.1	1978231	g24451	i0	64.7	2.38888888888889	34	12	63	0	160	59	144	177	MBI1762299.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Acidobacteriota bacterium]	diamond	387	53.9	1	Bacteria	Pseudomonadati	Acidobacteriota				Acidobacteriota 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);;