metadata: contig_metadata: 7 rows where bioproject = "PRJEB14175" and tax

7 rows where bioproject = "PRJEB14175" 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
25882075	25882075	PRJEB14175_P_NODE_273283_length_184_cov_27.731707_g271015_i0	PRJEB14175	273283	184	27.731707	51.02634088	Bacteria	2	Bacteria	Bacteria	80.1	5.91e-17	NR	KKP23969.1	1618771	g271015	i0	97.5	10.4347826086957	40	1	65.2	0	27	146	138	177	KKP23969.1 MAG: 50S ribosomal protein L6 [Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133]	diamond	1920	80.9	0.990111248454882	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium GW2011_GWF2_30_133
26318175	26318175	PRJEB14175_P_NODE_121879_length_316_cov_7.996078_g119613_i0	PRJEB14175	121879	316	7.996078	25.26760648	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	353	7.24e-93	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g119613	i0	88.927	102.645569620253	289	28	91	4	30	316	249820	249534	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	32436	353	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26325362	26325362	PRJEB14175_P_NODE_35343_length_627_cov_40.980565_g33185_i0	PRJEB14175	35343	627	40.980565	256.94814255	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	364	7.039999999999998e-96	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g33185	i0	89.789	119.751196172249	284	29	86	0	321	604	964565	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	75084	364	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26463215	26463215	PRJEB14175_P_NODE_61328_length_473_cov_13.575243_g59073_i0	PRJEB14175	61328	473	13.575243	64.21089939	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	460	6.45e-125	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g59073	i0	86.343	211.30021141649	432	47	90	8	45	471	126700	126276	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	99945	460	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
26560353	26560353	PRJEB14175_P_NODE_159480_length_265_cov_20.426471_g157213_i0	PRJEB14175	159480	265	20.426471	54.13014815	Bacteria	2	Bacteria	Bacteria	305	1.68e-78	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g157213	i0	90.336	66.1283018867925	238	16	88	6	11	244	963272	963506	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	17524	307	0.993485342019544	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
33075967	33075967	PRJEB14175_P_NODE_108213_length_341_cov_2.064286_g105947_i0	PRJEB14175	108213	341	2.064286	7.03921526	Bacillati	1783272	Bacteria	Bacteria	60.5	6.91e-8	NR	OGI64655.1	1801733	g105947	i0	51.8	1.4692082111437	56	27	49.3	0	316	149	521	576	OGI64655.1 MAG: molecular chaperone DnaK [Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_39_10]	diamond	501	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium RIFCSPHIGHO2_01_FULL_39_10
33093445	33093445	PRJEB14175_P_NODE_244966_length_204_cov_23.720280_g242698_i0	PRJEB14175	244966	204	23.72028	48.3893712	Bacteria	2	Bacteria	Bacteria	75.9	4.57e-14	NR	HCC06132.1	2052152	g242698	i0	64.9	3.35294117647059	57	20	83.8	0	32	202	37	93	HCC06132.1 DNA primase [Candidatus Nomurabacteria bacterium]	diamond	684	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;