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

6 rows where analysis = "diamond", bioproject = "PRJNA797655" 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
26610521	26610521	PRJNA797655_S_NODE_111661_length_235_cov_2.000000_g111056_i0	PRJNA797655	111661	235	2	4.7	Prochlorococcus sp. MIT 13	1220	Bacteria	Bacteria	43.1	0.0236	NR	WP_320666672.1	3096219	g111056	i0	38.8	0.625531914893617	49	30	62.6	0	19	165	12	60	WP_320666672.1 SDR family oxidoreductase [Prochlorococcus sp. MIT 1307]	diamond	147	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1307
27180080	27180080	PRJNA797655_S_NODE_219442_length_170_cov_1.889764_g218837_i0	PRJNA797655	219442	170	1.889764	3.2125988	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	40.4	0.0441	NR	HEY9637319.1	3081323	g218837	i0	41.7	0.847058823529412	48	27	84.7	1	26	169	76	122	HEY9637319.1 hypothetical protein [Coleofasciculaceae cyanobacterium]	diamond	144	40.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
28412031	28412031	PRJNA797655_S_NODE_268706_length_152_cov_1.761468_g268101_i0	PRJNA797655	268706	152	1.761468	2.67743136	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	103	3.79e-24	NR	MBQ2984034.1	2137880	g268101	i0	98	1.97368421052632	50	1	98.7	0	150	1	363	412	MBQ2984034.1 glycogen synthase [Candidatus Gastranaerophilales bacterium]	diamond	300	103	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
29990782	29990782	PRJNA797655_S_NODE_240151_length_162_cov_1.210084_g239546_i0	PRJNA797655	240151	162	1.210084	1.96033608	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04	2839657	Bacteria	Bacteria	51.2	1.3e-5	NR	MBW4637243.1	2839657	g239546	i0	96.2	0.481481481481481	26	1	48.1	0	78	1	658	683	MBW4637243.1 FG-GAP repeat protein [Gloeocapsa sp. UFS-A4-WI-NPMV-4B04]	diamond	78	51.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. UFS-A4-WI-NPMV-4B04
31317828	31317828	PRJNA797655_S_NODE_94535_length_251_cov_3.456731_g93930_i0	PRJNA797655	94535	251	3.456731	8.67639481	Pseudanabaena biceps	927669	Bacteria	Bacteria	43.5	0.0214	NR	NUN63272.1	927669	g93930	i0	52.3	0.525896414342629	44	19	50.2	1	173	48	16	59	NUN63272.1 hypothetical protein [Pseudanabaena biceps]	diamond	132	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena biceps
31571072	31571072	PRJNA797655_S_NODE_233816_length_164_cov_1.983471_g233211_i0	PRJNA797655	233816	164	1.983471	3.25289244	[Leptolyngbya] sp. PCC 7376	111781	Bacteria	Bacteria	41.6	0.0332	NR	WP_015134319.1	111781	g233211	i0	41	0.713414634146341	39	23	71.3	0	118	2	363	401	WP_015134319.1 CHASE2 domain-containing protein [[Leptolyngbya] sp. PCC 7376]	diamond	117	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Leptolyngbya] sp. PCC 7376

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