metadata: contig_metadata: 5 rows where bioproject = "PRJNA532380", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA532380", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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_genus	tax_species
17081246	17081246	PRJNA532380_P_NODE_25914_length_174_cov_1.696000_g25589_i0	PRJNA532380	25914	174	1.696	2.95104	Thermoflexus hugenholtzii	1495650	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2049907263\|gb\|CP076326.1\|	1495650	g25589	i0	100	0.160919540229885	28	0	16	0	22	49	1382457	1382430	MAG: Thermoflexus hugenholtzii isolate RBS10-4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Thermoflexia	Thermoflexales	Thermoflexaceae	Thermoflexus	Thermoflexus hugenholtzii
24069434	24069434	PRJNA532380_P_NODE_29139_length_167_cov_0.881356_g28814_i0	PRJNA532380	29139	167	0.881356	1.47186452	Caldilinea	233191	Bacteria	Bacteria	204	3.65e-48	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g28814	i0	88.69	4.34131736526946	168	18	100	1	1	167	1621	1454	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	725	204	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
27140460	27140460	PRJNA532380_P_NODE_32982_length_162_cov_1.221239_g32657_i0	PRJNA532380	32982	162	1.221239	1.97840718	Anaerolineales bacterium	2073117	Bacteria	Bacteria	42.7	0.0127	NR	MDP1547840.1	2073117	g32657	i0	44.7	0.703703703703704	38	21	70.4	0	37	150	87	124	MDP1547840.1 hypothetical protein [Anaerolineales bacterium]	diamond	114	42.7	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
29951234	29951234	PRJNA532380_P_NODE_11351_length_273_cov_1.294643_g11026_i0	PRJNA532380	11351	273	1.294643	3.53437539	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.1	0.0375	NR	MFA4835409.1	2026734	g11026	i0	41.3	0.505494505494505	46	22	50.5	1	38	175	287	327	MFA4835409.1 preprotein translocase subunit SecY [Dehalococcoidia bacterium]	diamond	138	43.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
30551381	30551381	PRJNA532380_P_NODE_33313_length_162_cov_0.920354_g32988_i0	PRJNA532380	33313	162	0.920354	1.49097348	Anaerolineae bacterium	2052143	Bacteria	Bacteria	90.5	2.64e-20	NR	MBX3084320.1	2052143	g32988	i0	83	0.981481481481482	53	9	98.1	0	160	2	9	61	MBX3084320.1 DUF2085 domain-containing protein [Anaerolineae bacterium]	diamond	159	90.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae				Anaerolineae 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);;