metadata: contig_metadata: 15 rows where bioproject = "PRJNA436017", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

15 rows where bioproject = "PRJNA436017", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
1089097	1089097	PRJNA436017_P_NODE_621_length_1126_cov_26.383838_g512_i0	PRJNA436017	621	1126	26.383838	297.08201588	Leptolyngbya	47251	Bacteria	Bacteria	1038	0	NTclustered	gi\|46409901\|gb\|AY584526.1\|	272134	g512	i0	93.352	100.730017761989	707	39	62	6	1	701	623	1327	Leptolyngbya boryana PCC 6306 23S ribosomal RNA gene, partial sequence	blastn	113422	1038	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya boryana
2364453	2364453	PRJNA436017_P_NODE_16662_length_202_cov_1.127273_g16364_i0	PRJNA436017	16662	202	1.127273	2.27709146	Limnospira	2596745	Bacteria	Bacteria	348	2e-91	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g16364	i0	98.01	7.91584158415842	201	3	99	1	1	200	3445515	3445715	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1599	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
8084129	8084129	PRJNA436017_P_NODE_25447_length_161_cov_20.379032_g25149_i0	PRJNA436017	25447	161	20.379032	32.81024152	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	291	2.6e-74	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g25149	i0	100	164.807453416149	157	0	98	0	1	157	1244356	1244512	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	26534	291	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
15116789	15116789	PRJNA436017_P_NODE_1152_length_872_cov_41.756886_g980_i0	PRJNA436017	1152	872	41.756886	364.12004592	Oscillatoriales	1150	Bacteria	Bacteria	1520	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g980	i0	99.639	163.577981651376	832	3	95	0	41	872	813274	812443	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	142640	1520	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
15733628	15733628	PRJNA436017_P_NODE_7493_length_324_cov_3.675958_g7196_i0	PRJNA436017	7493	324	3.675958	11.91010392	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	211	4.74e-50	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g7196	i0	78.979	1.62962962962963	333	53	100	13	1	324	125730	126054	Leptolyngbya sp. 7M chromosome	blastn	528	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
17007983	17007983	PRJNA436017_P_NODE_17654_length_195_cov_1.683544_g17356_i0	PRJNA436017	17654	195	1.683544	3.2829108	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	350	5.34e-92	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g17356	i0	98.974	1	195	2	100	0	1	195	3901	3707	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	195	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
17008145	17008145	PRJNA436017_P_NODE_274_length_1493_cov_406.616071_g155_i1	PRJNA436017	274	1493	406.616071	6070.77794003	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	1622	0	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g155	i1	87.535	230.156731413262	1420	156	94	18	1	1410	1246173	1244765	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	343624	1622	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
22107567	22107567	PRJNA436017_P_NODE_5378_length_391_cov_1.567797_g5082_i0	PRJNA436017	5378	391	1.567797	6.13008627	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	94.7	3.9200000000000006e-21	NR	MBX9690859.1	2847862	g5082	i0	40	0.997442455242967	130	70	99.7	2	2	391	86	207	MBX9690859.1 AMP-binding protein [Cyanobacteriota bacterium]	diamond	390	94.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
27771023	27771023	PRJNA436017_P_NODE_9324_length_285_cov_0.935484_g9026_i0	PRJNA436017	9324	285	0.935484	2.6661294	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	113	5.13e-28	NR	MBX9694561.1	2847862	g9026	i0	70.2	0.884210526315789	84	21	84.2	1	240	1	15	98	MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	252	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28370632	28370632	PRJNA436017_P_NODE_16346_length_204_cov_1.341317_g16048_i0	PRJNA436017	16346	204	1.341317	2.73628668	Richelia intracellularis	1164990	Bacteria	Bacteria	58.5	5.1e-9	NR	CDN15762.1	1164990	g16048	i0	66.7	1.20588235294118	42	14	61.8	0	198	73	4	45	CDN15762.1 hypothetical protein RintRC_0033 [Richelia intracellularis]	diamond	246	58.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
29934472	29934472	PRJNA436017_P_NODE_25651_length_161_cov_1.258065_g25353_i0	PRJNA436017	25651	161	1.258065	2.02548465	Cyanophyceae	3028117	Bacteria	Bacteria	80.1	7.96e-16	NR	WP_036536179.1	1501145	g25353	i0	69.8	5.92546583850932	53	16	98.8	0	161	3	351	403	WP_036536179.1 glutamate synthase subunit beta [Neosynechococcus sphagnicola]	diamond	954	80.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Neosynechococcales	Neosynechococcaceae	Neosynechococcus	Neosynechococcus sphagnicola
30044170	30044170	PRJNA436017_P_NODE_29731_length_150_cov_1.035398_g29433_i0	PRJNA436017	29731	150	1.035398	1.553097	Cyanobacteria bacterium P01_H01_bin.152	3023315	Bacteria	Bacteria	72	4.82e-13	NR	MEM1278527.1	3023315	g29433	i0	60.4	2.84	48	19	96	0	149	6	556	603	MEM1278527.1 glycoside hydrolase family 19 protein [Cyanobacteria bacterium P01_H01_bin.152]	diamond	426	72	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_H01_bin.152
30297523	30297523	PRJNA436017_P_NODE_21952_length_174_cov_2.255474_g21654_i0	PRJNA436017	21952	174	2.255474	3.92452476	Nostocales cyanobacterium ELA608	3064516	Bacteria	Bacteria	45.1	0.00148	NR	MEI6371987.1	3064516	g21654	i0	40.4	0.982758620689655	57	34	98.3	0	172	2	15	71	MEI6371987.1 NADH-quinone oxidoreductase subunit C [Nostocales cyanobacterium ELA608]	diamond	171	45.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium ELA608
31292912	31292912	PRJNA436017_P_NODE_27695_length_155_cov_1.322034_g27397_i0	PRJNA436017	27695	155	1.322034	2.0491527	Cyanophyceae	3028117	Bacteria	Bacteria	43.9	0.00443	NR	OAB62278.1	322866	g27397	i0	47.5	2.36129032258065	40	21	77.4	0	20	139	634	673	OAB62278.1 hypothetical protein AY599_10795 [Leptolyngbya valderiana BDU 20041]	diamond	366	43.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya valderiana
32098942	32098942	PRJNA436017_P_NODE_24418_length_165_cov_1.375000_g24120_i0	PRJNA436017	24418	165	1.375	2.26875	Nostoc sp. CHAB 5715	2780400	Bacteria	Bacteria	48.1	1.47e-4	NR	WP_229458700.1	2780400	g24120	i0	87.5	0.436363636363636	24	3	43.6	0	74	3	1	24	WP_229458700.1 hypothetical protein [Nostoc sp. CHAB 5715]	diamond	72	48.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CHAB 5715

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