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

4 rows where bioproject = "PRJNA870096", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_superkingdom = "Bacteria"

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_family	tax_genus	tax_species
11053474	11053474	PRJNA870096_S_NODE_14149_length_487_cov_4.759009_g12513_i0	PRJNA870096	14149	487	4.759009	23.17637383	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	133	4.48e-35	NR	MDY6311276.1	2847862	g12513	i0	50.7	1.84804928131417	150	71	92.4	1	23	472	103	249	MDY6311276.1 50S ribosomal protein L2 [Cyanobacteriota bacterium]	diamond	900	133	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26968289	26968289	PRJNA870096_S_NODE_25682_length_355_cov_3.717949_g24018_i0	PRJNA870096	25682	355	3.717949	13.19871895	Planktothrix	54304	Bacteria	Bacteria	88.6	2.3e-19	NR	OIP71423.1	1805291	g24018	i0	43.9	4.37746478873239	107	59	90.4	1	355	35	51	156	OIP71423.1 MAG: hypothetical protein AUK43_06245 [Oscillatoriales cyanobacterium CG2_30_40_61]	diamond	1554	88.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium CG2_30_40_61
27474120	27474120	PRJNA870096_S_NODE_53503_length_240_cov_2.167513_g51839_i0	PRJNA870096	53503	240	2.167513	5.2020312	root	1	Root_unresolved	Root_unresolved	69.3	1.55e-11	NR	WP_044208351.1	64178	g51839	i0	46.7	5.6375	75	39	92.5	1	1	222	421	495	WP_044208351.1 cytochrome P450 [Coleofasciculus chthonoplastes]	diamond	1353	69.7	0.994261119081779	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus chthonoplastes
28729012	28729012	PRJNA870096_S_NODE_16987_length_443_cov_1.560000_g15340_i0	PRJNA870096	16987	443	1.56	6.9108	Cyanobacteria bacterium P01_C01_bin.120	3023258	Bacteria	Bacteria	130	1.96e-33	NR	MEM6835899.1	3023258	g15340	i0	58.2	8.72911963882619	91	38	61.6	0	118	390	66	156	MEM6835899.1 fatty acid desaturase [Cyanobacteria bacterium P01_C01_bin.120]	diamond	3867	130	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_C01_bin.120

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