metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax_phylum = "Cyanobacteriota"

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
4178802	4178802	PRJNA1247234_P_NODE_4004_length_497_cov_0.919811_g3853_i0	PRJNA1247234	4004	497	0.919811	4.57146067	Nodularia spumigena	70799	Bacteria	Bacteria	325	1.2699999999999997e-106	NR	WP_323245539.1	70799	g3853	i0	92.7	1.99195171026157	165	12	99.6	0	496	2	63	227	WP_323245539.1 methionine--tRNA ligase, partial [Nodularia spumigena]	diamond	990	325	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
6154348	6154348	PRJNA1247234_P_NODE_12065_length_318_cov_0.938776_g11909_i0	PRJNA1247234	12065	318	0.938776	2.98530768	Nodularia spumigena	70799	Bacteria	Bacteria	189	5.6499999999999985e-56	NR	WP_323245180.1	70799	g11909	i0	86.7	1.9811320754717	105	14	99.1	0	317	3	143	247	WP_323245180.1 30S ribosomal protein S1 [Nodularia spumigena]	diamond	630	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
20752748	20752748	PRJNA1247234_P_NODE_11297_length_326_cov_1.233202_g11141_i0	PRJNA1247234	11297	326	1.233202	4.02023852	Nodularia spumigena	70799	Bacteria	Bacteria	178	8.0299999999999995e-53	NR	WP_323245238.1	70799	g11141	i0	81.1	0.975460122699387	106	20	97.5	0	2	319	235	340	WP_323245238.1 zinc transporter ZntB [Nodularia spumigena]	diamond	318	178	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
22028025	22028025	PRJNA1247234_P_NODE_13778_length_301_cov_0.899123_g13622_i0	PRJNA1247234	13778	301	0.899123	2.70636023	Nodularia spumigena	70799	Bacteria	Bacteria	134	3.68e-34	NR	WP_323245173.1	70799	g13622	i0	71.6	1.01661129568106	102	26	98.7	1	299	3	839	940	WP_323245173.1 FtsK/SpoIIIE family DNA translocase [Nodularia spumigena]	diamond	306	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
26915376	26915376	PRJNA1247234_P_NODE_23782_length_248_cov_0.891429_g23626_i0	PRJNA1247234	23782	248	0.891429	2.21074392	Nodularia spumigena	70799	Bacteria	Bacteria	153	1.46e-41	NR	WP_323245286.1	70799	g23626	i0	87.8	1.98387096774194	82	10	99.2	0	3	248	296	377	WP_323245286.1 cytochrome c biogenesis protein CcsA [Nodularia spumigena]	diamond	492	153	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
27136365	27136365	PRJNA1247234_P_NODE_24222_length_247_cov_0.896552_g24066_i0	PRJNA1247234	24222	247	0.896552	2.21448344	Nodularia spumigena	70799	Bacteria	Bacteria	77	2.35e-14	NR	WP_323245422.1	70799	g24066	i0	48.7	0.923076923076923	76	37	92.3	1	18	245	80	153	WP_323245422.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Nodularia spumigena]	diamond	228	77	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
27831644	27831644	PRJNA1247234_P_NODE_23164_length_249_cov_0.886364_g23008_i0	PRJNA1247234	23164	249	0.886364	2.20704636	Aliterella atlantica	1827278	Bacteria	Bacteria	151	1.23e-42	NR	WP_045055554.1	1827278	g23008	i0	100	0.963855421686747	80	0	96.4	0	241	2	1	80	WP_045055554.1 ABC transporter permease [Aliterella atlantica]	diamond	240	151	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
28747353	28747353	PRJNA1247234_P_NODE_14207_length_297_cov_1.044643_g14051_i0	PRJNA1247234	14207	297	1.044643	3.10258971	Hyella patelloides	1982969	Bacteria	Bacteria	89	1.49e-19	NR	WP_144870175.1	1982969	g14051	i0	59.6	0.575757575757576	57	23	57.6	0	175	5	1	57	WP_144870175.1 class I SAM-dependent DNA methyltransferase [Hyella patelloides]	diamond	171	89	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Hyella	Hyella patelloides
30028638	30028638	PRJNA1247234_P_NODE_23591_length_248_cov_0.891429_g23435_i0	PRJNA1247234	23591	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	134	2.78e-34	NR	MFM6173072.1	289435	g23435	i0	77.8	14.6491935483871	81	18	98	0	247	5	330	410	MFM6173072.1 DNA-directed RNA polymerase subunit beta' [Sphaerospermopsis kisseleviana]	diamond	3633	134	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis kisseleviana
30041954	30041954	PRJNA1247234_P_NODE_23611_length_248_cov_0.891429_g23455_i0	PRJNA1247234	23611	248	0.891429	2.21074392	Nodularia spumigena	70799	Bacteria	Bacteria	150	6.049999999999999e-45	NR	WP_323245290.1	70799	g23455	i0	89	0.991935483870968	82	9	99.2	0	248	3	29	110	WP_323245290.1 Minf_1886 family protein [Nodularia spumigena]	diamond	246	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
31514049	31514049	PRJNA1247234_P_NODE_23056_length_249_cov_0.886364_g22900_i0	PRJNA1247234	23056	249	0.886364	2.20704636	Bacteria	2	Bacteria	Bacteria	122	5.33e-30	NR	WP_323244861.1	70799	g22900	i0	68.7	3	83	26	100	0	1	249	208	290	WP_323244861.1 penicillin-binding transpeptidase domain-containing protein [Nodularia spumigena]	diamond	747	123	0.991869918699187	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena

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