metadata: contig_metadata: 13 rows where bioproject = "PRJNA1249042" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where bioproject = "PRJNA1249042" 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
4880198	4880198	PRJNA1249042_S_NODE_104464_length_158_cov_1.669565_g104250_i0	PRJNA1249042	104464	158	1.669565	2.6379127000000002	Nostoc	1177	Bacteria	Bacteria	52.8	0.013	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g104250	i0	100	0.708860759493671	28	0	18	0	42	69	7834513	7834486	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme
9282722	9282722	PRJNA1249042_S_NODE_40108_length_224_cov_1.751381_g39894_i0	PRJNA1249042	40108	224	1.751381	3.92309344	Gloeotrichia echinulata	212360	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2813986847\|gb\|CP170511.1\|	3350243	g39894	i0	100	0.125	28	0	13	0	70	97	3607193	3607220	MAG: Gloeotrichia echinulata GP01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Gloeotrichiaceae	Gloeotrichia	Gloeotrichia echinulata
11833048	11833048	PRJNA1249042_S_NODE_39530_length_225_cov_1.291209_g39316_i0	PRJNA1249042	39530	225	1.291209	2.90522025	Candidatus Gastranaerophilales bacterium HUM_1	1916322	Bacteria	Bacteria	138	1.6999999999999998e-36	NR	DAA99850.1	1916229	g39316	i0	98.6	4.93333333333333	74	1	98.7	0	3	224	296	369	DAA99850.1 MAG TPA: molecular chaperone DnaK [Candidatus Gastranaerophilales bacterium HUM_10]	diamond	1110	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_10
14383939	14383939	PRJNA1249042_S_NODE_88532_length_170_cov_2.842520_g88318_i0	PRJNA1249042	88532	170	2.84252	4.832284	cyanobacterium endosymbiont of Rhopalodia gibberula	1763363	Bacteria	Bacteria	171	3.7599999999999997e-38	NTclustered	gi\|1264230396\|dbj\|AP018341.1\|	1763363	g88318	i0	88.079	87.5117647058824	151	9	86	7	1	147	1576145	1576000	Cyanobacterium endosymbiont of Rhopalodia gibberula DNA, complete genome, isolate: RgSB	blastn	14877	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibberula
16931921	16931921	PRJNA1249042_S_NODE_65614_length_192_cov_1.845638_g65400_i0	PRJNA1249042	65614	192	1.845638	3.54362496	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	126	9.6e-25	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g65400	i0	80.22	3.71875	182	25	92	10	10	185	2366807	2366983	Leptolyngbya sp. 7M chromosome	blastn	714	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
20755795	20755795	PRJNA1249042_S_NODE_15817_length_278_cov_2.885106_g15603_i0	PRJNA1249042	15817	278	2.885106	8.02059468	Prochlorococcus marinus	1219	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2895549752\|gb\|CP138919.1\|	1570015	g15603	i0	100	0.10431654676259	29	0	10	0	30	58	850389	850361	Prochlorococcus marinus str. MIT 1012 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
26947014	26947014	PRJNA1249042_S_NODE_57102_length_201_cov_2.677215_g56888_i0	PRJNA1249042	57102	201	2.677215	5.38120215	Cyanobacteria bacterium RUI128	2861361	Bacteria	Bacteria	132	2.01e-37	NR	MCR5266542.1	2861361	g56888	i0	97	1	67	2	100	0	201	1	93	159	MCR5266542.1 aminoacyl-tRNA hydrolase [Cyanobacteria bacterium RUI128]	diamond	201	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium RUI128
27263388	27263388	PRJNA1249042_S_NODE_29463_length_242_cov_3.638191_g29249_i0	PRJNA1249042	29463	242	3.638191	8.80442222	Dolichospermum sp. ST_sed9	2916813	Bacteria	Bacteria	65.5	2.47e-10	NR	MDD1425369.1	2916813	g29249	i0	40.5	3.90495867768595	79	47	97.9	0	1	237	170	248	MDD1425369.1 restriction endonuclease subunit S [Dolichospermum sp. ST_sed9]	diamond	945	65.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum sp. ST_sed9
30484467	30484467	PRJNA1249042_S_NODE_102813_length_159_cov_2.215517_g102599_i0	PRJNA1249042	102813	159	2.215517	3.52267203	Chamaesiphon sp.	2814140	Bacteria	Bacteria	42.7	0.0122	NR	WP_373539040.1	2814140	g102599	i0	51.4	0.69811320754717	37	14	62.3	1	19	117	219	255	WP_373539040.1 glycosyltransferase family 2 protein [Chamaesiphon sp.]	diamond	111	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon sp.
31274291	31274291	PRJNA1249042_S_NODE_1195_length_3148_cov_56.481804_g1012_i1	PRJNA1249042	1195	3148	56.481804	1778.04718992	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	1112	0	NR	MEL7079446.1	3023143	g1012	i1	63.9	0.886277001270648	930	319	87.7	4	2926	167	61	983	MEL7079446.1 reverse transcriptase family protein [Cyanobacteria bacterium J06582_2]	diamond	2790	1112	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
31590817	31590817	PRJNA1249042_S_NODE_1036_length_4088_cov_46.838319_g1012_i0	PRJNA1249042	1036	4088	46.838319	1914.75048072	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	1155	0	NR	MEL7079446.1	3023143	g1012	i0	63.3	0.727984344422701	992	340	71.7	8	992	3922	1	983	MEL7079446.1 reverse transcriptase family protein [Cyanobacteria bacterium J06582_2]	diamond	2976	1155	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
32350127	32350127	PRJNA1249042_S_NODE_60779_length_197_cov_2.272727_g60565_i0	PRJNA1249042	60779	197	2.272727	4.47727219	Cyanobacteria bacterium J06641_5	3023219	Bacteria	Bacteria	41.6	0.0282	NR	MEO0947216.1	3023219	g60565	i0	42.9	0.746192893401015	49	27	73.1	1	32	175	77	125	MEO0947216.1 hypothetical protein [Cyanobacteria bacterium J06641_5]	diamond	147	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06641_5
32602889	32602889	PRJNA1249042_S_NODE_1220_length_3012_cov_58.402492_g1012_i2	PRJNA1249042	1220	3012	58.402492	1759.08305904	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	1085	0	NR	MEL7079446.1	3023143	g1012	i2	63.9	0.902390438247012	906	310	89.2	4	159	2846	85	983	MEL7079446.1 reverse transcriptase family protein [Cyanobacteria bacterium J06582_2]	diamond	2718	1085	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2

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