metadata: contig_metadata: 5 rows where bioproject = "PRJNA1010780", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

5 rows where bioproject = "PRJNA1010780", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Candidatus Melainabacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_genus	tax_species
19280660	19280660	PRJNA1010780_S_NODE_29816_length_266_cov_3.978355_g28527_i0	PRJNA1010780	29816	266	3.978355	10.5824243	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g28527	i0	100	0.105263157894737	28	0	11	0	67	94	4925448	4925421	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria				Candidatus Melainabacteria bacterium
28171631	28171631	PRJNA1010780_S_NODE_41146_length_202_cov_2.526946_g39857_i0	PRJNA1010780	41146	202	2.526946	5.10443092	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	50.1	5.63e-5	NR	MBX3151095.1	2364082	g39857	i0	45.9	1.8415841584158399	61	32	90.6	1	7	189	183	242	MBX3151095.1 tetratricopeptide repeat protein [Candidatus Obscuribacterales bacterium]	diamond	372	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
30003216	30003216	PRJNA1010780_S_NODE_63031_length_151_cov_1.008621_g61742_i0	PRJNA1010780	63031	151	1.008621	1.52301771	Vampirovibrio sp.	2717857	Bacteria	Bacteria	77.8	2.46e-15	NR	MBX2861904.1	2717857	g61742	i0	75.5	7.78807947019868	49	12	97.4	0	149	3	255	303	MBX2861904.1 cysteine synthase A [Vampirovibrio sp.]	diamond	1176	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales	Vampirovibrio	Vampirovibrio sp.
32184355	32184355	PRJNA1010780_S_NODE_24518_length_323_cov_3.652778_g23229_i0	PRJNA1010780	24518	323	3.652778	11.79847294	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	49.3	4.86e-4	NR	MBX9670300.1	2364082	g23229	i0	34.1	1.79256965944272	91	57	81.7	1	37	300	1033	1123	MBX9670300.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	579	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales		Candidatus Obscuribacterales bacterium
32878807	32878807	PRJNA1010780_S_NODE_46240_length_185_cov_1.840000_g44951_i0	PRJNA1010780	46240	185	1.84	3.404	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	94.7	4.77e-21	NR	MFM7390119.1	2692181	g44951	i0	68.9	5.93513513513513	61	19	98.9	0	183	1	205	265	MFM7390119.1 zinc metallochaperone GTPase ZigA [Vampirovibrionales bacterium]	diamond	1098	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales		Vampirovibrionales 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);;