metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA704949" and tax_phylum = "Candidatus Doudnaibacteriota"

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
17276339	17276339	PRJNA704949_P_NODE_511114_length_381_cov_1.647590_g495845_i0	PRJNA704949	511114	381	1.64759	6.2773179	Candidatus Doudnabacteria bacterium RIFCSPHIGHO2_	2052150	Bacteria	Bacteria	187	6.79e-56	NR	OGE74626.1	1817820	g495845	i0	66.4	3.85826771653543	125	42	98.4	0	2	376	129	253	OGE74626.1 MAG: tryptophan--tRNA ligase [Candidatus Doudnabacteria bacterium RIFCSPHIGHO2_01_52_17]	diamond	1470	187	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium RIFCSPHIGHO2_01_52_17
27683525	27683525	PRJNA704949_P_NODE_1251204_length_226_cov_1.468927_g1235867_i0	PRJNA704949	1251204	226	1.468927	3.31977502	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	99.4	2.6899999999999994e-24	NR	MEJ0021401.1	2052150	g1235867	i0	61.4	0.929203539823009	70	27	92.9	0	17	226	3	72	MEJ0021401.1 hypothetical protein [Candidatus Doudnabacteria bacterium]	diamond	210	99.4	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium
29714587	29714587	PRJNA704949_P_NODE_1440210_length_206_cov_1.808917_g1424872_i0	PRJNA704949	1440210	206	1.808917	3.72636902	Bacteria	2	Bacteria	Bacteria	81.3	2.28e-17	NR	MBI5530515.1	2052150	g1424872	i0	52.2	3.91747572815534	67	32	97.6	0	5	205	79	145	MBI5530515.1 DUF664 domain-containing protein [Candidatus Doudnabacteria bacterium]	diamond	807	81.3	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium
29767316	29767316	PRJNA704949_P_NODE_513651_length_380_cov_1.670695_g498379_i0	PRJNA704949	513651	380	1.670695	6.348641	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	45.8	0.00982	NR	MBX4205298.1	2052150	g498379	i0	31.8	1.65	107	67	80.5	3	1	306	82	187	MBX4205298.1 hypothetical protein [Candidatus Doudnabacteria bacterium]	diamond	627	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria bacterium
31789870	31789870	PRJNA704949_P_NODE_387677_length_436_cov_2.196382_g372593_i0	PRJNA704949	387677	436	2.196382	9.57622552	Candidatus Doudnabacteria bacterium	2052150	Bacteria	Bacteria	140	1.88e-37	NR	MBI3231992.1	2052150	g372593	i0	47.9	1.98853211009174	146	73	98.4	1	434	6	106	251	MBI3231992.1 tetratricopeptide repeat protein [Candidatus Doudnabacteria bacterium]	diamond	867	140	1	Bacteria	Bacteria candidate phyla	Candidatus Doudnaibacteriota	Candidatus Doudnabacteria 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);;