metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_clade = "Cyanobacteriota/Melainabacteria group"

5 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_clade = "Cyanobacteriota/Melainabacteria group"

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
9572342	9572342	PRJNA674050_P_NODE_27468_length_249_cov_0.880682_g27265_i0	PRJNA674050	27468	249	0.880682	2.19289818	Cyanophyceae	3028117	Bacteria	Bacteria	99	1.24e-22	NR	WP_010994866.1	1162	g27265	i0	69	5.21686746987952	71	22	85.5	0	247	35	227	297	WP_010994866.1 MULTISPECIES: hypothetical protein [Nostocaceae]	diamond	1299	100	0.99	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
13397991	13397991	PRJNA674050_P_NODE_29511_length_248_cov_0.874286_g29308_i0	PRJNA674050	29511	248	0.874286	2.16822928	Pelatocladus sp. BLCC-F211	3342752	Bacteria	Bacteria	100	2.23e-22	NR	WP_374871703.1	3342752	g29308	i0	63.2	1.83870967741935	76	28	91.9	0	248	21	212	287	WP_374871703.1 DEAD/DEAH box helicase [Pelatocladus sp. BLCC-F211]	diamond	456	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Pelatocladus	Pelatocladus sp. BLCC-F211
21568379	21568379	PRJNA674050_P_NODE_11777_length_289_cov_1.944444_g11574_i0	PRJNA674050	11777	289	1.944444	5.61944316	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	192	1.43e-58	NR	MCC7529114.1	2052166	g11574	i0	100	2.98961937716263	96	0	99.7	0	288	1	136	231	MCC7529114.1 sigma-70 family RNA polymerase sigma factor [Candidatus Melainabacteria bacterium]	diamond	864	192	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
28092440	28092440	PRJNA674050_P_NODE_4565_length_358_cov_3.712281_g4362_i0	PRJNA674050	4565	358	3.712281	13.28996598	Aphanizomenon flos-aquae WA1	1176	Bacteria	Bacteria	69.7	4.85e-12	NR	OBQ32396.1	1710896	g4362	i0	38.1	1.12290502793296	134	55	95.5	4	343	2	16	141	OBQ32396.1 MAG: hypothetical protein AN484_27995, partial [Aphanizomenon flos-aquae WA102]	diamond	402	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
29039912	29039912	PRJNA674050_P_NODE_37448_length_243_cov_0.917647_g37245_i0	PRJNA674050	37448	243	0.917647	2.22988221	Aliterella atlantica	1827278	Bacteria	Bacteria	120	3.28e-32	NR	WP_045054534.1	1827278	g37245	i0	88.1	0.827160493827161	67	5	82.7	1	3	203	123	186	WP_045054534.1 (2Fe-2S) ferredoxin domain-containing protein [Aliterella atlantica]	diamond	201	120	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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