metadata: contig_metadata: 8 rows where bioproject = "PRJNA1067370", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA1067370", tax_kingdom = "Bacillati" and tax_phylum = "Armatimonadota"

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
11659591	11659591	PRJNA1067370_P_NODE_59730_length_280_cov_1.487923_g59181_i0	PRJNA1067370	59730	280	1.487923	4.1661844	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	278	3.91e-70	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g59181	i0	88.559	173.707142857143	236	17	83	8	1	232	1305108	1305337	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	48638	278	1	Bacteria	Bacillati	Armatimonadota				uncultured Armatimonadetes bacterium
27098852	27098852	PRJNA1067370_P_NODE_89782_length_248_cov_0.880000_g89233_i0	PRJNA1067370	89782	248	0.88	2.1824	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	77.8	1.37e-15	NR	MCW3097160.1	2739509	g89233	i0	50.6	0.979838709677419	81	40	98	0	248	6	11	91	MCW3097160.1 hypothetical protein [Chthonomonadaceae bacterium]	diamond	243	77.8	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonadaceae bacterium
27193561	27193561	PRJNA1067370_P_NODE_86922_length_249_cov_0.875000_g86373_i0	PRJNA1067370	86922	249	0.875	2.17875	Armatimonadota bacterium	2033014	Bacteria	Bacteria	125	5.89e-32	NR	MBV9849197.1	2033014	g86373	i0	74	1.8433734939759	77	20	92.8	0	248	18	399	475	MBV9849197.1 F0F1 ATP synthase subunit beta [Armatimonadota bacterium]	diamond	459	125	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
27722694	27722694	PRJNA1067370_P_NODE_5064_length_781_cov_1.323446_g4574_i0	PRJNA1067370	5064	781	1.323446	10.33611326	Bacteria	2	Bacteria	Bacteria	64.7	3.29e-8	NR	HEY3416857.1	2033014	g4574	i0	33.9	2.15108834827145	127	74	47.6	3	376	5	85	204	HEY3416857.1 DUF5602 domain-containing protein [Armatimonadota bacterium]	diamond	1680	64.7	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
30667483	30667483	PRJNA1067370_P_NODE_21113_length_410_cov_1.584570_g20565_i0	PRJNA1067370	21113	410	1.58457	6.496737	Armatimonadota bacterium	2033014	Bacteria	Bacteria	85.5	2.62e-16	NR	MBI1332026.1	2033014	g20565	i0	36.2	10.609756097561	130	80	93.7	3	384	1	2	130	MBI1332026.1 hypothetical protein [Armatimonadota bacterium]	diamond	4350	86.3	0.990730011587486	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
30975255	30975255	PRJNA1067370_P_NODE_40754_length_317_cov_1.258197_g40206_i0	PRJNA1067370	40754	317	1.258197	3.98848449	Bacillati	1783272	Bacteria	Bacteria	90.5	1.5e-18	NR	MCS7224975.1	2033014	g40206	i0	55.7	3.60567823343849	79	35	74.8	0	239	3	535	613	MCS7224975.1 transketolase [Armatimonadota bacterium]	diamond	1143	90.5	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
31015112	31015112	PRJNA1067370_P_NODE_90695_length_248_cov_0.880000_g90146_i0	PRJNA1067370	90695	248	0.88	2.1824	Armatimonadota bacterium	2033014	Bacteria	Bacteria	73.6	2.02e-13	NR	MDQ3815047.1	2033014	g90146	i0	79.5	0.532258064516129	44	9	53.2	0	132	1	2	45	MDQ3815047.1 ATP-binding cassette domain-containing protein [Armatimonadota bacterium]	diamond	132	73.6	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
31362965	31362965	PRJNA1067370_P_NODE_58136_length_283_cov_0.904762_g57587_i0	PRJNA1067370	58136	283	0.904762	2.56047646	Armatimonadaceae bacterium	2933160	Bacteria	Bacteria	43.9	0.0237	NR	HVK04628.1	2933160	g57587	i0	51.2	0.45583038869258	43	21	45.6	0	163	35	415	457	HVK04628.1 DUF5693 family protein [Armatimonadaceae bacterium]	diamond	129	43.9	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadales	Armatimonadaceae	Armatimonadaceae 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);;