metadata: contig_metadata: 11 rows where bioproject = "PRJNA1215774" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJNA1215774" 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
2881837	2881837	PRJNA1215774_P_NODE_31023_length_380_cov_1.003257_g30703_i0	PRJNA1215774	31023	380	1.003257	3.8123766	Leptolyngbya sp. BL-A-14	3104317	Bacteria	Bacteria	597	3.709999999999999e-166	NTclustered	gi\|2804745243\|gb\|CP166621.1\|	3104317	g30703	i0	95.026	184.365789473684	382	15	100	4	1	380	1778555	1778934	MAG: Leptolyngbya sp. BL-A-14 chromosome, complete genome	blastn	70059	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. BL-A-14
21447646	21447646	PRJNA1215774_P_NODE_76817_length_246_cov_0.890173_g76497_i0	PRJNA1215774	76817	246	0.890173	2.18982558	Bacillati	1783272	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2830894453\|gb\|CP170743.1\|	184925	g76497	i0	100	1.58943089430894	30	0	12	0	102	131	1506615	1506586	Chlorogloeopsis fritschii PCC 9212 chromosome, complete genome	blastn	391	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Chlorogloeopsidaceae	Chlorogloeopsis	Chlorogloeopsis fritschii
23283671	23283671	PRJNA1215774_P_NODE_74019_length_248_cov_0.880000_g73699_i0	PRJNA1215774	74019	248	0.88	2.1824	Leptolyngbya sp. NIES-3755	1752064	Bacteria	Bacteria	416	6.9e-112	NTclustered	gi\|965629957\|dbj\|AP017308.1\|	1752064	g73699	i0	97.154	194.342741935484	246	7	99	0	1	246	1246169	1245924	Leptolyngbya sp. NIES-3755 DNA, complete genome	blastn	48197	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. NIES-3755
26851421	26851421	PRJNA1215774_P_NODE_70021_length_250_cov_0.870056_g69701_i0	PRJNA1215774	70021	250	0.870056	2.17514	Candidatus Sericytochromatia bacterium	2762020	Bacteria	Bacteria	144	9.74e-41	NR	MEZ0369360.1	2762020	g69701	i0	89.2	0.996	83	8	99.6	1	1	249	13	94	MEZ0369360.1 slipin family protein [Candidatus Sericytochromatia bacterium]	diamond	249	144	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati		Candidatus Sericytochromatia				Candidatus Sericytochromatia bacterium
27546643	27546643	PRJNA1215774_P_NODE_84584_length_241_cov_0.916667_g84264_i0	PRJNA1215774	84584	241	0.916667	2.20916747	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	90.9	1.19e-19	NR	MDD9899179.1	2052166	g84264	i0	48.8	1.04564315352697	84	37	97.1	1	1	234	79	162	MDD9899179.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	252	90.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29238955	29238955	PRJNA1215774_P_NODE_75169_length_247_cov_0.885057_g74849_i0	PRJNA1215774	75169	247	0.885057	2.18609079	Cyanophyceae	3028117	Bacteria	Bacteria	52.8	1.1e-5	NR	WP_019499047.1	118173	g74849	i0	37.3	1.67611336032389	67	41	80.2	1	20	217	104	170	WP_019499047.1 hypothetical protein [Pseudanabaena sp. PCC 6802]	diamond	414	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
29883317	29883317	PRJNA1215774_P_NODE_51871_length_292_cov_2.109589_g51551_i0	PRJNA1215774	51871	292	2.109589	6.15999988	Richelia intracellularis HH	1164990	Bacteria	Bacteria	119	1.29e-32	NR	CCH68009.1	1165094	g51551	i0	96.4	0.565068493150685	55	2	56.5	0	290	126	38	92	CCH68009.1 hypothetical protein RINTHH_18540 [Richelia intracellularis HH01]	diamond	165	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
29946414	29946414	PRJNA1215774_P_NODE_71511_length_249_cov_0.875000_g71191_i0	PRJNA1215774	71511	249	0.875	2.17875	Prochloron sp. SP5CPC1	2653678	Bacteria	Bacteria	105	1.81e-25	NR	MBC6418372.1	2653678	g71191	i0	87.1	0.746987951807229	62	8	74.7	0	2	187	110	171	MBC6418372.1 prohibitin family protein [Candidatus Paraprochloron terpiosi SP5CPC1]	diamond	186	105	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Prochloraceae	Prochloron	Prochloron sp. SP5CPC1
31083772	31083772	PRJNA1215774_P_NODE_73215_length_248_cov_0.880000_g72895_i0	PRJNA1215774	73215	248	0.88	2.1824	unclassified Moorena	2683338	Bacteria	Bacteria	66.2	7.35e-11	NR	WP_287297058.1	2683338	g72895	i0	78	2.96370967741935	41	9	49.6	0	106	228	1	41	WP_287297058.1 MULTISPECIES: glycosyltransferase family 2 protein [unclassified Moorena]	diamond	735	66.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Moorena
31304948	31304948	PRJNA1215774_P_NODE_13615_length_592_cov_1.832370_g13298_i0	PRJNA1215774	13615	592	1.83237	10.8476304	Synechococcales cyanobacterium	2478492	Bacteria	Bacteria	95.9	4.45e-19	NR	MFM7547221.1	2478492	g13298	i0	78.2	1.11486486486486	55	12	27.9	0	590	426	749	803	MFM7547221.1 IS630 family transposase [Synechococcales cyanobacterium]	diamond	660	95.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium
31779313	31779313	PRJNA1215774_P_NODE_34697_length_358_cov_1.350877_g34377_i0	PRJNA1215774	34697	358	1.350877	4.83613966	Cyanobium sp. A2C-AMD	2823695	Bacteria	Bacteria	194	1.52e-59	NR	WP_255017364.1	2823695	g34377	i0	75.6	1.9944134078212301	119	29	99.7	0	1	357	5	123	WP_255017364.1 DUF6602 domain-containing protein [Cyanobium sp. A2C-AMD]	diamond	714	194	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. A2C-AMD

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