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

5 rows where bioproject = "PRJNA169559", 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
3605278	3605278	PRJNA169559_P_NODE_46203_length_198_cov_2.355030_g44126_i0	PRJNA169559	46203	198	2.35503	4.6629594	Bacteria	2	Bacteria	Bacteria	150	5.919999999999999e-32	NTclustered	gi\|2546137831\|emb\|OY282365.1\|	498747	g44126	i0	91.667	184.964646464646	108	9	55	0	4	111	2061164	2061057	MAG: uncultured Dehalococcoidia bacterium isolate fd47c038-abb2-4c05-9cdb-6b11942eec52 genome assembly, chromosome: 1	blastn	36623	150	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
19490927	19490927	PRJNA169559_P_NODE_2376_length_1071_cov_2.543186_g1499_i0	PRJNA169559	2376	1071	2.543186	27.23752206	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	254	3.54e-79	NR	HIM38018.1	2026734	g1499	i0	45.6	2.42296918767507	296	140	82.9	3	181	1068	27	301	HIM38018.1 polyamine aminopropyltransferase [Dehalococcoidia bacterium]	diamond	2595	254	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
26978976	26978976	PRJNA169559_P_NODE_3222_length_925_cov_2.385045_g2177_i0	PRJNA169559	3222	925	2.385045	22.06166625	Ktedonosporobacter rubrisoli	2509675	Bacteria	Bacteria	70.9	2.87e-11	NR	WP_129886023.1	2509675	g2177	i0	57.8	0.612972972972973	64	27	20.8	0	519	328	5	68	WP_129886023.1 lectin [Ktedonosporobacter rubrisoli]	diamond	567	70.9	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonosporobacteraceae	Ktedonosporobacter	Ktedonosporobacter rubrisoli
27755376	27755376	PRJNA169559_P_NODE_3044_length_949_cov_9.804348_g2027_i0	PRJNA169559	3044	949	9.804348	93.04326252	Bacteria	2	Bacteria	Bacteria	327	1.02e-108	NR	MDA1175223.1	2026724	g2027	i0	57.7	22.0242360379347	279	114	88.2	1	8	844	6	280	MDA1175223.1 aldolase/citrate lyase family protein [Chloroflexota bacterium]	diamond	20901	329	0.993920972644377	Bacteria	Bacillati	Chloroflexota					Chloroflexota bacterium
30390310	30390310	PRJNA169559_P_NODE_13773_length_452_cov_2.933806_g11863_i0	PRJNA169559	13773	452	2.933806	13.26080312	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	174	2.76e-51	NR	HZS76708.1	2740538	g11863	i0	52.9	2.99336283185841	157	64	97.6	2	442	2	11	167	HZS76708.1 sulfotransferase [Ktedonobacteraceae bacterium]	diamond	1353	174	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae 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);;