metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax_clade = "Cyanobacteriota/Melainabacteria group"

13 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
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
1705777	1705777	PRJNA436017_P_NODE_302_length_1459_cov_13.627989_g243_i0	PRJNA436017	302	1459	13.627989	198.83235951	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1122	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g243	i0	80.92	73.4139821795751	1478	232	100	38	1	1459	3682680	3681234	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	107111	1122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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
6808747	6808747	PRJNA436017_P_NODE_786_length_1034_cov_20.251755_g652_i0	PRJNA436017	786	1034	20.251755	209.4031467	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	966	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g652	i0	83.699	136.557059961315	1049	145	99	24	2	1034	3681642	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	141200	966	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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
13184615	13184615	PRJNA436017_P_NODE_431_length_1296_cov_32.846704_g352_i0	PRJNA436017	431	1296	32.846704	425.69328384	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1199	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g352	i0	83.61	117.571759259259	1324	170	100	42	1	1296	3681376	3682680	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1199	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14459752	14459752	PRJNA436017_P_NODE_432_length_1296_cov_32.671962_g353_i0	PRJNA436017	432	1296	32.671962	423.42862752	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1194	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g353	i0	83.535	117.571759259259	1324	171	100	42	1	1296	3682680	3681376	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	152373	1194	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
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
18282582	18282582	PRJNA436017_P_NODE_555_length_1171_cov_14.016755_g452_i0	PRJNA436017	555	1171	14.016755	164.13620105	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1048	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g452	i0	83.193	65.932536293766	1184	160	99	28	1	1170	3682680	3681522	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	77207	1048	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
20832316	20832316	PRJNA436017_P_NODE_14497_length_219_cov_1.043956_g14199_i0	PRJNA436017	14497	219	1.043956	2.28626364	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	143	1.12e-29	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g14199	i0	78.924	351.826484018265	223	38	99	9	2	219	1479107	1479325	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	77050	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1

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