metadata: contig_metadata: 5 rows where bioproject = "PRJNA509429" and tax

5 rows where bioproject = "PRJNA509429" 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
8138351	8138351	PRJNA509429_P_NODE_42647_length_173_cov_1.079710_g41819_i0	PRJNA509429	42647	173	1.07971	1.8678983	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	296	6.08e-76	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g41819	i0	97.674	12.6531791907514	172	4	99	0	2	173	494550	494379	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	2189	296	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17062594	17062594	PRJNA509429_P_NODE_49554_length_155_cov_1.125000_g48726_i0	PRJNA509429	49554	155	1.125	1.74375	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	158	2.63e-34	NTclustered	gi\|2258866441\|gb\|CP060228.1\|	2052152	g48726	i0	89.516	9.27096774193548	124	13	80	0	1	124	248654	248531	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-23 chromosome	blastn	1437	158	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18336940	18336940	PRJNA509429_P_NODE_43535_length_170_cov_1.777778_g42707_i0	PRJNA509429	43535	170	1.777778	3.0222226	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	161	2.26e-35	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g42707	i0	85.621	3.18823529411765	153	22	90	0	18	170	125739	125891	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	542	161	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
19611284	19611284	PRJNA509429_P_NODE_39936_length_181_cov_1.828767_g39108_i0	PRJNA509429	39936	181	1.828767	3.31006827	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	189	1.1199999999999996e-43	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g39108	i0	90.345	40.3812154696133	145	12	80	2	36	179	136525	136668	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	7309	189	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
22162066	22162066	PRJNA509429_P_NODE_48258_length_158_cov_1.113821_g47430_i0	PRJNA509429	48258	158	1.113821	1.75983718	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	193	7.38e-45	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g47430	i0	88.75	4.59493670886076	160	14	100	4	1	158	126046	125889	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	726	193	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);;