metadata: contig_metadata: 6 rows where bioproject = "PRJNA193544", tax_clade = "Bacteria candidate phyla" and tax

6 rows where bioproject = "PRJNA193544", tax_clade = "Bacteria candidate phyla" 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
365908	365908	PRJNA193544_S_NODE_741_length_281_cov_302.996032_g726_i0	PRJNA193544	741	281	302.996032	851.41884992	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	316	8.319999999999998e-82	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g726	i0	94.203	54.153024911032	207	12	74	0	52	258	137538	137744	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	15217	316	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
13119655	13119655	PRJNA193544_S_NODE_1511_length_213_cov_4.527174_g1496_i0	PRJNA193544	1511	213	4.527174	9.64288062	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	159	1.0699999999999999e-34	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g1496	i0	81.633	36.81220657277	196	33	92	3	14	208	136835	137028	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	7841	159	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
16943176	16943176	PRJNA193544_S_NODE_3494_length_150_cov_4.132231_g3479_i0	PRJNA193544	3494	150	4.132231	6.1983465	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	172	8.99e-39	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g3479	i0	88.652	0.94	141	16	94	0	2	142	135624	135484	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	141	172	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
19491899	19491899	PRJNA193544_S_NODE_396_length_336_cov_12092.820847_g381_i0	PRJNA193544	396	336	12092.820847	40631.87804592	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	272	2.24e-68	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g381	i0	83.062	107.910714285714	307	45	90	7	1	303	126188	125885	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	36258	272	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23318023	23318023	PRJNA193544_S_NODE_539_length_310_cov_18.661922_g524_i0	PRJNA193544	539	310	18.661922	57.8519582	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	381	3.249999999999999e-101	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g524	i0	92.776	337.306451612903	263	19	85	0	1	263	124756	124494	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	104565	381	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
24592117	24592117	PRJNA193544_S_NODE_1380_length_220_cov_6.460733_g1365_i0	PRJNA193544	1380	220	6.460733	14.2136126	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	219	1.82e-52	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1365	i0	84.753	126.354545454545	223	28	100	6	1	220	123803	124022	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	27798	219	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);;