metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Nomuraibacteriota"

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_phylum	tax_species
27660559	27660559	PRJNA168635_P_NODE_17884_length_190_cov_1.326241_g17468_i0	PRJNA168635	17884	190	1.326241	2.5198579	Bacteria	2	Bacteria	Bacteria	88.6	1.12e-18	NR	OGI65558.1	1801739	g17468	i0	68.3	14.8578947368421	63	20	99.5	0	1	189	244	306	OGI65558.1 MAG: protein-export membrane protein SecD [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_24b]	diamond	2823	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_40_24b
27944616	27944616	PRJNA168635_P_NODE_27245_length_167_cov_0.881356_g26829_i0	PRJNA168635	27245	167	0.881356	1.47186452	Bacteria	2	Bacteria	Bacteria	110	7.9e-27	NR	KKP24603.1	1618771	g26829	i0	92.7	33.5928143712575	55	4	98.8	0	166	2	188	242	KKP24603.1 MAG: lysyl-tRNA synthetase [Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133]	diamond	5610	110	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133
28747677	28747677	PRJNA168635_P_NODE_34927_length_153_cov_2.980769_g34511_i0	PRJNA168635	34927	153	2.980769	4.56057657	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	42	0.0213	NR	MCC7160281.1	2052152	g34511	i0	70	0.588235294117647	30	9	58.8	0	96	7	357	386	MCC7160281.1 peptidoglycan-binding protein [Candidatus Nomurabacteria bacterium]	diamond	90	42	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
28955161	28955161	PRJNA168635_P_NODE_21628_length_177_cov_2.390625_g21212_i0	PRJNA168635	21628	177	2.390625	4.23140625	root	1	Root_unresolved	Root_unresolved	63.9	5.02e-10	NR	KKR20041.1	1618754	g21212	i0	49.1	1.93220338983051	57	29	96.6	0	2	172	409	465	KKR20041.1 MAG: hypothetical protein UT51_C0009G0015 [Candidatus Nomurabacteria bacterium GW2011_GWC2_39_41]	diamond	342	64.3	0.993779160186625	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWC2_39_41
29347650	29347650	PRJNA168635_P_NODE_24249_length_171_cov_1.565574_g23833_i0	PRJNA168635	24249	171	1.565574	2.67713154	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_	2052152	Bacteria	Bacteria	101	3.23e-23	NR	OGI71827.1	1801752	g23833	i0	92.7	0.964912280701754	55	4	96.5	0	167	3	432	486	OGI71827.1 MAG: cell division protein FtsH [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_38_15]	diamond	165	101	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_38_15
30660431	30660431	PRJNA168635_P_NODE_25053_length_169_cov_1.708333_g24637_i0	PRJNA168635	25053	169	1.708333	2.88708277	root	1	Root_unresolved	Root_unresolved	79	2.39e-15	NR	OGI76558.1	1801747	g24637	i0	69.5	3.12426035502959	59	12	95.9	2	163	2	182	239	OGI76558.1 MAG: hypothetical protein A3C57_02335 [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_33_12]	diamond	528	79.7	0.991217063989962	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_02_FULL_33_12

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