metadata: contig_metadata: 23 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax

23 rows where analysis = "diamond", bioproject = "PRJNA395690" 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
16988893	16988893	PRJNA395690_P_NODE_10354_length_253_cov_1.254902_g10202_i0	PRJNA395690	10354	253	1.254902	3.17490206	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	128	8.17e-37	NR	WP_211626192.1	2812896	g10202	i0	98.6	0.8300395256917	70	1	83	0	2	211	8	77	WP_211626192.1 acyl carrier protein [Leptolyngbya sp. 7M]	diamond	210	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
26902461	26902461	PRJNA395690_P_NODE_9341_length_266_cov_1.631336_g9189_i0	PRJNA395690	9341	266	1.631336	4.33935376	Nostocales	1161	Bacteria	Bacteria	72.8	1.31e-12	NR	WP_347566152.1	2304196	g9189	i0	41.3	7.97368421052632	92	40	93.6	2	3	251	37	123	WP_347566152.1 serine/threonine-protein kinase [Scytonema sp. UIC 10036]	diamond	2121	72.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. UIC 10036
27724301	27724301	PRJNA395690_P_NODE_11364_length_241_cov_4.312500_g11212_i0	PRJNA395690	11364	241	4.3125	10.393125	Cyanophyceae	3028117	Bacteria	Bacteria	55.5	2.25e-7	NR	WP_168358551.1	136072	g11212	i0	34.2	2.82572614107884	79	52	98.3	0	241	5	61	139	WP_168358551.1 hypothetical protein [Dolichospermum planctonicum]	diamond	681	55.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum planctonicum
27850069	27850069	PRJNA395690_P_NODE_13964_length_218_cov_0.905325_g13812_i0	PRJNA395690	13964	218	0.905325	1.9736085	Cyanophyceae	3028117	Bacteria	Bacteria	97.8	2.72e-24	NR	WP_039203500.1	1176	g13812	i0	64.8	9.09633027522936	71	25	97.7	0	217	5	46	116	WP_039203500.1 four helix bundle protein [Aphanizomenon flos-aquae]	diamond	1983	97.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Aphanizomenon	Aphanizomenon flos-aquae
28071181	28071181	PRJNA395690_P_NODE_8085_length_284_cov_1.902128_g7933_i0	PRJNA395690	8085	284	1.902128	5.40204352	Nostocales	1161	Bacteria	Bacteria	147	1.2299999999999999e-40	NR	WP_334738694.1	1180	g7933	i0	66	6.95070422535211	94	32	99.3	0	284	3	44	137	WP_334738694.1 NADH:flavin oxidoreductase [Nostoc sp.]	diamond	1974	147	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp.
28275373	28275373	PRJNA395690_P_NODE_12286_length_232_cov_2.961749_g12134_i0	PRJNA395690	12286	232	2.961749	6.87125768	Microcystis aeruginosa Ma_OC_LR_1954	1126	Bacteria	Bacteria	60.1	9.95e-10	NR	TRT98628.1	2486261	g12134	i0	45.1	0.918103448275862	71	39	91.8	0	7	219	2	72	TRT98628.1 MAG: tetratricopeptide repeat protein, partial [Microcystis aeruginosa Ma_OC_LR_19540900_S633]	diamond	213	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
28292107	28292107	PRJNA395690_P_NODE_31846_length_164_cov_1.382609_g31694_i0	PRJNA395690	31846	164	1.382609	2.26747876	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.00495	NR	WP_029637463.1	1161	g31694	i0	100	37.4268292682927	18	0	32.9	0	3	56	312	329	WP_029637463.1 MULTISPECIES: arsenosugar biosynthesis radical SAM (seleno)protein ArsS [Nostocales]	diamond	6138	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
28401781	28401781	PRJNA395690_P_NODE_22706_length_180_cov_1.534351_g22554_i0	PRJNA395690	22706	180	1.534351	2.7618318	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	78.6	3.89e-15	NR	MEI6371517.1	3064516	g22554	i0	57.9	0.95	57	24	95	0	1	171	1211	1267	MEI6371517.1 reverse transcriptase domain-containing protein [Nostocales cyanobacterium ELA608]	diamond	171	78.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
28513280	28513280	PRJNA395690_P_NODE_1647_length_610_cov_2.327986_g1504_i0	PRJNA395690	1647	610	2.327986	14.2007146	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	167	3.24e-47	NR	EKQ67420.1	864702	g1504	i0	53.4	4.36229508196721	148	66	72.8	1	608	165	152	296	EKQ67420.1 hypothetical protein OsccyDRAFT_3690 [Leptolyngbyaceae cyanobacterium JSC-12]	diamond	2661	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium JSC-12
29064973	29064973	PRJNA395690_P_NODE_6428_length_317_cov_1.936567_g6277_i0	PRJNA395690	6428	317	1.936567	6.13891739	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	196	1.07e-56	NR	WP_211627241.1	2812896	g6277	i0	96.2	2.98107255520505	105	4	99.4	0	315	1	224	328	WP_211627241.1 elongation factor G [Leptolyngbya sp. 7M]	diamond	945	196	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
29349122	29349122	PRJNA395690_P_NODE_9869_length_259_cov_1.214286_g9717_i0	PRJNA395690	9869	259	1.214286	3.14500074	Cyanobacteria bacterium P01_A01_bin.83	3023254	Bacteria	Bacteria	52	2.64e-5	NR	MEM7589939.1	3023254	g9717	i0	32.1	0.972972972972973	84	54	93.8	1	247	5	4414	4497	MEM7589939.1 cadherin domain-containing protein [Cyanobacteria bacterium P01_A01_bin.83]	diamond	252	52	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.83
29380579	29380579	PRJNA395690_P_NODE_2469_length_497_cov_1.330357_g2321_i0	PRJNA395690	2469	497	1.330357	6.61187429	Allocoleopsis sp.	3088169	Bacteria	Bacteria	189	1.19e-57	NR	HEY9704096.1	3088169	g2321	i0	90.2	0.61569416498994	102	10	61.6	0	306	1	1	102	HEY9704096.1 hypothetical protein [Allocoleopsis sp.]	diamond	306	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis sp.
29506800	29506800	PRJNA395690_P_NODE_30230_length_166_cov_0.871795_g30078_i0	PRJNA395690	30230	166	0.871795	1.4471797	Scytonema hofmannii	34078	Bacteria	Bacteria	43.5	0.00707	NR	WP_017739767.1	34078	g30078	i0	40.4	3.03614457831325	57	26	88.6	1	162	16	66	122	WP_017739767.1 hypothetical protein [Scytonema hofmannii]	diamond	504	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema hofmannii
29822423	29822423	PRJNA395690_P_NODE_5451_length_343_cov_1.408163_g5301_i0	PRJNA395690	5451	343	1.408163	4.82999909	Pseudanabaena sp. 'Roaring Creek'	1681830	Bacteria	Bacteria	56.2	1.93e-6	NR	WP_055073598.1	1681830	g5301	i0	38.1	0.551020408163265	63	39	55.1	0	60	248	8	70	WP_055073598.1 hypothetical protein [Pseudanabaena sp. 'Roaring Creek']	diamond	189	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. 'Roaring Creek'
30029032	30029032	PRJNA395690_P_NODE_10791_length_248_cov_1.125628_g10639_i0	PRJNA395690	10791	248	1.125628	2.79155744	Bacillati	1783272	Bacteria	Bacteria	102	3.55e-24	NR	WP_196528307.1	1178	g10639	i0	59.3	2.93951612903226	81	33	98	0	246	4	118	198	WP_196528307.1 ATP-binding protein [Nostoc commune]	diamond	729	103	0.990291262135922	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
30106822	30106822	PRJNA395690_P_NODE_13432_length_222_cov_1.473988_g13280_i0	PRJNA395690	13432	222	1.473988	3.27225336	Symploca sp. SIO1C4	2607765	Bacteria	Bacteria	82.8	2.19e-16	NR	NER26898.1	2607765	g13280	i0	54.2	1.91891891891892	72	33	97.3	0	5	220	397	468	NER26898.1 DUF4347 domain-containing protein [Symploca sp. SIO1C4]	diamond	426	82.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Symploca	Symploca sp. SIO1C4
30265239	30265239	PRJNA395690_P_NODE_4092_length_390_cov_2.184751_g3943_i0	PRJNA395690	4092	390	2.184751	8.5205289	Pleurocapsa sp. FMAR1	3040204	Bacteria	Bacteria	45.4	0.00593	NR	WP_319419070.1	3040204	g3943	i0	74.1	0.207692307692308	27	7	20.8	0	142	222	106	132	WP_319419070.1 nuclear transport factor 2 family protein [Pleurocapsa sp. FMAR1]	diamond	81	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. FMAR1
30643910	30643910	PRJNA395690_P_NODE_2653_length_480_cov_1.459397_g2505_i0	PRJNA395690	2653	480	1.459397	7.0051056	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	254	1.46e-83	NR	WP_211627814.1	2812896	g2505	i0	91.4	3.46875	139	12	86.9	0	2	418	56	194	WP_211627814.1 GTP-binding protein [Leptolyngbya sp. 7M]	diamond	1665	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
30960092	30960092	PRJNA395690_P_NODE_19794_length_187_cov_1.456522_g19642_i0	PRJNA395690	19794	187	1.456522	2.72369614	Microcoleus sp.	44472	Bacteria	Bacteria	77.4	7.32e-15	NR	WP_371124211.1	44472	g19642	i0	66	2.47058823529412	53	18	85	0	185	27	74	126	WP_371124211.1 T4 RnlA family RNA ligase [Microcoleus sp.]	diamond	462	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp.
31971870	31971870	PRJNA395690_P_NODE_18698_length_189_cov_2.528571_g18546_i0	PRJNA395690	18698	189	2.528571	4.77899919	Microcoleus sp. PH2	44472	Bacteria	Bacteria	92.8	4.850000000000001e-21	NR	WP_293229249.1	2798816	g18546	i0	74.1	1.84126984126984	58	15	92.1	0	189	16	180	237	WP_293229249.1 phosphoadenosine phosphosulfate reductase family protein [Microcoleus sp. PH2017_05_CCC_O_A]	diamond	348	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. PH2017_05_CCC_O_A
32003632	32003632	PRJNA395690_P_NODE_14098_length_217_cov_0.910714_g13946_i0	PRJNA395690	14098	217	0.910714	1.97624938	Prochlorothrix sp.	54309	Bacteria	Bacteria	84	8.22e-17	NR	MEB3164683.1	54309	g13946	i0	56.9	0.995391705069124	72	30	99.5	1	2	217	252	322	MEB3164683.1 hypothetical protein [Prochlorothrix sp.]	diamond	216	84	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Prochlorotrichales	Prochlorotrichaceae	Prochlorothrix	Prochlorothrix sp.
32161970	32161970	PRJNA395690_P_NODE_30818_length_165_cov_0.879310_g30666_i0	PRJNA395690	30818	165	0.87931	1.4508615	Alkalinema sp. CACIAM 7	3100328	Bacteria	Bacteria	67	3.64e-11	NR	OUC16020.1	1934309	g30666	i0	57.1	2.03636363636364	56	23	100	1	165	1	447	502	OUC16020.1 MAG: hypothetical protein B0A82_03940 [Alkalinema sp. CACIAM 70d]	diamond	336	67	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. CACIAM 70d
32368660	32368660	PRJNA395690_P_NODE_9639_length_262_cov_1.197183_g9487_i0	PRJNA395690	9639	262	1.197183	3.13661946	Cyanophyceae	3028117	Bacteria	Bacteria	58.9	9.06e-8	NR	WP_193886481.1	1828648	g9487	i0	41.3	3.14885496183206	75	44	85.9	0	32	256	68	142	WP_193886481.1 tetratricopeptide repeat protein [Oculatella sp. LEGE 06141]	diamond	825	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella sp. LEGE 06141

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