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

19 rows where analysis = "diamond", bioproject = "PRJNA330616" 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
13143361	13143361	PRJNA330616_P_NODE_32051_length_161_cov_0.910714_g31642_i0	PRJNA330616	32051	161	0.910714	1.46624954	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	107	6.58e-28	NR	WP_106368035.1	2107693	g31642	i0	96.2	0.968944099378882	52	2	96.9	0	157	2	34	85	WP_106368035.1 Photosystem I reaction center subunit III [Chlorogloea sp. CCALA 695]	diamond	156	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
13822700	13822700	PRJNA330616_P_NODE_12991_length_230_cov_1.127072_g12582_i0	PRJNA330616	12991	230	1.127072	2.5922656	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	61.6	2.68e-9	NR	MAR06922.1	2024872	g12582	i0	90.3	15.4173913043478	31	3	40.4	0	1	93	184	214	MAR06922.1 peptidylprolyl isomerase [Cyanobium sp. NAT70]	diamond	3546	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NAT70
20195516	20195516	PRJNA330616_P_NODE_3576_length_457_cov_2.078431_g3169_i0	PRJNA330616	3576	457	2.078431	9.49842967	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	269	3.929999999999999e-90	NR	MBX9724270.1	2364082	g3169	i0	89	1.94967177242888	145	16	95.2	0	436	2	3	147	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	891	269	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
26680303	26680303	PRJNA330616_P_NODE_28741_length_164_cov_0.886957_g28332_i0	PRJNA330616	28741	164	0.886957	1.45460948	Cyanophyceae	3028117	Bacteria	Bacteria	99	2.01e-22	NR	WP_045054105.1	1827278	g28332	i0	94.4	1.97560975609756	54	3	98.8	0	2	163	154	207	WP_045054105.1 cation-translocating P-type ATPase [Aliterella atlantica]	diamond	324	99.4	0.995975855130785	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica
26726041	26726041	PRJNA330616_P_NODE_5081_length_375_cov_1.705521_g4672_i0	PRJNA330616	5081	375	1.705521	6.39570375	unclassified Microcystis	2643300	Bacteria	Bacteria	154	1.6599999999999998e-45	NR	WP_287637343.1	2643300	g4672	i0	72.5	1.752	109	30	87.2	0	371	45	21	129	WP_287637343.1 MULTISPECIES: DUF1842 domain-containing protein [unclassified Microcystis]	diamond	657	154	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis
26757971	26757971	PRJNA330616_P_NODE_32521_length_161_cov_0.910714_g32112_i0	PRJNA330616	32521	161	0.910714	1.46624954	Hyella patelloides	1982969	Bacteria	Bacteria	52	1.27e-6	NR	WP_144868447.1	1982969	g32112	i0	52	2.75776397515528	50	24	93.2	0	11	160	26	75	WP_144868447.1 hypothetical protein [Hyella patelloides]	diamond	444	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Hyella	Hyella patelloides
27958997	27958997	PRJNA330616_P_NODE_30405_length_163_cov_0.894737_g29996_i0	PRJNA330616	30405	163	0.894737	1.45842131	Synechocystis sp. PCC 75	1143	Bacteria	Bacteria	100	7.87e-23	NR	WP_009634182.1	927677	g29996	i0	92.3	0.957055214723926	52	4	95.7	0	162	7	645	696	WP_009634182.1 polyphosphate kinase 1 [Synechocystis sp. PCC 7509]	diamond	156	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7509
28450089	28450089	PRJNA330616_P_NODE_13546_length_226_cov_1.146893_g13137_i0	PRJNA330616	13546	226	1.146893	2.59197818	Cyanophyceae	3028117	Bacteria	Bacteria	45.4	0.00344	NR	WP_158201107.1	1126	g13137	i0	36.7	11.6681415929204	49	31	65	0	225	79	320	368	WP_158201107.1 Calx-beta domain-containing protein [Microcystis aeruginosa]	diamond	2637	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
29316667	29316667	PRJNA330616_P_NODE_16869_length_204_cov_1.316129_g16460_i0	PRJNA330616	16869	204	1.316129	2.68490316	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	118	2.7699999999999997e-30	NR	MBX9694561.1	2847862	g16460	i0	80.6	0.985294117647059	67	13	98.5	0	202	2	41	107	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	201	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29316671	29316671	PRJNA330616_P_NODE_22549_length_178_cov_1.317829_g22140_i0	PRJNA330616	22549	178	1.317829	2.34573562	Microcystis aeruginosa	1126	Bacteria	Bacteria	53.5	2.03e-6	NR	WP_002803245.1	1126	g22140	i0	42.1	3.75842696629213	57	31	96.1	1	173	3	39	93	WP_002803245.1 hypothetical protein [Microcystis aeruginosa]	diamond	669	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
29442763	29442763	PRJNA330616_P_NODE_30070_length_163_cov_0.894737_g29661_i0	PRJNA330616	30070	163	0.894737	1.45842131	Chlorogloea sp. CCALA 695	2107693	Bacteria	Bacteria	99.4	1.1200000000000001e-22	NR	WP_199192475.1	2107693	g29661	i0	90.6	0.975460122699387	53	5	97.5	0	3	161	116	168	WP_199192475.1 alkaline phosphatase PhoX [Chlorogloea sp. CCALA 695]	diamond	159	99.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Entophysalidaceae	Chlorogloea	Chlorogloea sp. CCALA 695
30137405	30137405	PRJNA330616_P_NODE_25752_length_167_cov_0.864407_g25343_i0	PRJNA330616	25752	167	0.864407	1.44355969	Leptolyngbyaceae cyanobacterium	3088178	Bacteria	Bacteria	97.1	5.48e-22	NR	HEY9780886.1	3088178	g25343	i0	85.5	0.988023952095808	55	8	98.8	0	165	1	295	349	HEY9780886.1 transposase [Leptolyngbyaceae cyanobacterium]	diamond	165	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium
30137412	30137412	PRJNA330616_P_NODE_30952_length_162_cov_0.902655_g30543_i0	PRJNA330616	30952	162	0.902655	1.4623011	Tolypothrix sp. NIES-4	3100432	Bacteria	Bacteria	75.9	2.19e-14	NR	WP_089130578.1	2005459	g30543	i0	86	2.38888888888889	43	6	79.6	0	131	3	1	43	WP_089130578.1 scytonemin biosynthesis PEP-CTERM protein ScyF [Tolypothrix sp. NIES-4075]	diamond	387	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Tolypothrichaceae	Tolypothrix	Tolypothrix sp. NIES-4075
31261023	31261023	PRJNA330616_P_NODE_32535_length_161_cov_0.910714_g32126_i0	PRJNA330616	32535	161	0.910714	1.46624954	Tolypothrix	111782	Bacteria	Bacteria	100	1.94e-25	NR	WP_029637773.1	1161	g32126	i0	100	1.97515527950311	53	0	98.8	0	1	159	67	119	WP_029637773.1 MULTISPECIES: tetratricopeptide repeat protein [Nostocales]	diamond	318	100	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
31496878	31496878	PRJNA330616_P_NODE_10876_length_251_cov_0.980198_g10467_i0	PRJNA330616	10876	251	0.980198	2.46029698	Pseudanabaena sp.	1153	Bacteria	Bacteria	158	5.769999999999999e-43	NR	MFM7602565.1	1153	g10467	i0	94	0.99203187250996006	83	5	99.2	0	249	1	684	766	MFM7602565.1 DUF4132 domain-containing protein [Pseudanabaena sp.]	diamond	249	158	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31971143	31971143	PRJNA330616_P_NODE_20078_length_188_cov_1.467626_g19669_i0	PRJNA330616	20078	188	1.467626	2.75913688	Cyanobacteria bacterium SZAS-4	2807733	Bacteria	Bacteria	58.2	6.47e-8	NR	MBS1955634.1	2807733	g19669	i0	50	0.98936170212766	62	29	95.7	1	2	181	486	547	MBS1955634.1 tetratricopeptide repeat protein [Cyanobacteria bacterium SZAS-4]	diamond	186	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS-4
32635063	32635063	PRJNA330616_P_NODE_28460_length_164_cov_1.773913_g28051_i0	PRJNA330616	28460	164	1.773913	2.90921732	Microcystis aeruginosa Ma_OC_H_1987	1126	Bacteria	Bacteria	55.8	5.81e-8	NR	TRT87209.1	2486262	g28051	i0	53.3	0.823170731707317	45	21	82.3	0	162	28	95	139	TRT87209.1 MAG: hypothetical protein EWV63_09030 [Microcystis aeruginosa Ma_OC_H_19870700_S124]	diamond	135	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
32855619	32855619	PRJNA330616_P_NODE_24640_length_170_cov_1.264463_g24231_i0	PRJNA330616	24640	170	1.264463	2.1495871	Leptolyngbya sp. DLM2.Bin15	2480212	Bacteria	Bacteria	111	9.79e-28	NR	TVQ18745.1	2480212	g24231	i0	89.3	1.95882352941176	56	6	98.8	0	1	168	242	297	TVQ18745.1 MAG: alpha/beta fold hydrolase [Leptolyngbya sp. DLM2.Bin15]	diamond	333	111	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. DLM2.Bin15
32855631	32855631	PRJNA330616_P_NODE_6620_length_325_cov_1.398551_g6211_i0	PRJNA330616	6620	325	1.398551	4.54529075	Leptolyngbya sp. PCC 64	47254	Bacteria	Bacteria	57.8	4.59e-7	NR	WP_008308156.1	1173264	g6211	i0	41.5	2.16923076923077	94	41	86.8	2	40	321	10	89	WP_008308156.1 FecCD family ABC transporter permease [Leptolyngbya sp. PCC 6406]	diamond	705	57.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. PCC 6406

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