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

6 rows where bioproject = "PRJNA438111", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Rokuibacteriota"

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
5538040	5538040	PRJNA438111_P_NODE_52285_length_179_cov_2.840000_g51660_i0	PRJNA438111	52285	179	2.84	5.0836	Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_22	1802110	Bacteria	Bacteria	120	1.02e-30	NR	OGL17219.1	1802110	g51660	i0	93.2	1.97765363128492	59	4	98.9	0	179	3	172	230	OGL17219.1 MAG: transposase [Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_22]	diamond	354	120	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokubacteria bacterium RIFCSPLOWO2_12_FULL_71_22
26600825	26600825	PRJNA438111_P_NODE_74701_length_161_cov_5.075758_g74076_i0	PRJNA438111	74701	161	5.075758	8.17197038	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	65.1	6.82e-12	NR	MBM4442514.1	2053607	g74076	i0	64.4	0.838509316770186	45	16	83.9	0	136	2	3	47	MBM4442514.1 hypothetical protein [Candidatus Rokuibacteriota bacterium]	diamond	135	65.1	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
27676466	27676466	PRJNA438111_P_NODE_78024_length_159_cov_3.707692_g77399_i0	PRJNA438111	78024	159	3.707692	5.89523028	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	73.2	2.25e-13	NR	MET0850231.1	2053607	g77399	i0	66.7	2.88679245283019	51	17	96.2	0	159	7	776	826	MET0850231.1 ATP-binding protein [Candidatus Rokuibacteriota bacterium]	diamond	459	73.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29601896	29601896	PRJNA438111_P_NODE_70270_length_164_cov_3.155556_g69645_i0	PRJNA438111	70270	164	3.155556	5.17511184	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	60.1	9.68e-9	NR	PWU22462.1	2053607	g69645	i0	65.4	1.86585365853659	52	18	95.1	0	6	161	88	139	PWU22462.1 MAG: PD-(D/E)XK nuclease family protein [Candidatus Rokuibacteriota bacterium]	diamond	306	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
29949605	29949605	PRJNA438111_P_NODE_35851_length_202_cov_6.179191_g35226_i0	PRJNA438111	35851	202	6.179191	12.48196582	Candidatus Rokuibacteriota bacterium	2053607	Bacteria	Bacteria	68.2	1.84e-11	NR	MFI5375921.1	2053607	g35226	i0	70.2	1.69306930693069	57	16	84.7	1	32	202	10	65	MFI5375921.1 ABC transporter substrate-binding protein [Candidatus Rokuibacteriota bacterium]	diamond	342	68.2	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokuibacteriota bacterium
32035824	32035824	PRJNA438111_P_NODE_80498_length_157_cov_4.273438_g79873_i0	PRJNA438111	80498	157	4.273438	6.70929766	Candidatus Rokubacteria bacterium GWA2_73_35	1802096	Bacteria	Bacteria	99.8	2.4699999999999994e-23	NR	OGK78391.1	1802096	g79873	i0	90.2	0.974522292993631	51	5	97.5	0	1	153	161	211	OGK78391.1 MAG: hypothetical protein A2050_04485 [Candidatus Rokubacteria bacterium GWA2_73_35]	diamond	153	99.8	1	Bacteria	Bacteria candidate phyla	Candidatus Rokuibacteriota	Candidatus Rokubacteria bacterium GWA2_73_35

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