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

11 rows where bioproject = "PRJNA1139127" 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
1032213	1032213	PRJNA1139127_P_NODE_1161_length_1940_cov_10.323514_g1064_i0	PRJNA1139127	1161	1940	10.323514	200.2761716	Oscillatoriales	1150	Bacteria	Bacteria	3356	0	NTclustered	gi\|225696243\|gb\|FJ805910.1\|	1211	g1064	i0	98.132	198.789690721649	1927	33	99	3	16	1940	1716	3641	Uncultured cyanobacterium clone AN2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	385652	3382	0.992312241277351	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
1032255	1032255	PRJNA1139127_P_NODE_26041_length_353_cov_1.092857_g25549_i0	PRJNA1139127	26041	353	1.092857	3.85778521	Oscillatoriales	1150	Bacteria	Bacteria	597	3.42e-166	NTclustered	gi\|428238862\|gb\|CP003614.1\|	179408	g25549	i0	97.167	19.1699716713881	353	10	100	0	1	353	79168	79520	Oscillatoria nigro-viridis PCC 7112 chromosome, complete genome	blastn	6767	597	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Phormidium	Phormidium nigroviride
3582769	3582769	PRJNA1139127_P_NODE_24543_length_368_cov_2.277966_g24051_i0	PRJNA1139127	24543	368	2.277966	8.38291488	Cyanophyceae	3028117	Bacteria	Bacteria	538	2.1999999999999998e-148	NTclustered	gi\|984535223\|dbj\|AP017367.1\|	1080068	g24051	i0	93.188	143.39402173913	367	23	99	2	2	367	280894	280529	Leptolyngbya sp. O-77 DNA, complete genome	blastn	52769	538	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. O-77
7410221	7410221	PRJNA1139127_P_NODE_31506_length_309_cov_2.309322_g31013_i0	PRJNA1139127	31506	309	2.309322	7.13580498	Cyanophyceae	3028117	Bacteria	Bacteria	250	9.53e-62	NTclustered	gi\|371909853\|emb\|FN813311.1\|	460260	g31013	i0	86.207	5.80906148867314	232	31	75	1	13	244	505	275	Phormidium autumnale CCALA 143 phycocyanin operon, strain CCALA 143	blastn	1795	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus autumnalis
7937973	7937973	PRJNA1139127_P_NODE_12327_length_593_cov_2.163462_g11855_i0	PRJNA1139127	12327	593	2.163462	12.82932966	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	470	1.37e-127	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g11855	i0	81.113	1.26306913996627	593	106	99	6	4	593	1338413	1337824	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	749	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
11763739	11763739	PRJNA1139127_P_NODE_25550_length_358_cov_0.971930_g25058_i0	PRJNA1139127	25550	358	0.97193	3.4795094	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	390	6.33e-104	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g25058	i0	86.517	92.7737430167598	356	46	99	2	1	355	2776352	2776706	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	33213	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
13039007	13039007	PRJNA1139127_P_NODE_43831_length_250_cov_0.870056_g43338_i0	PRJNA1139127	43831	250	0.870056	2.17514	Microcoleus vaginatus	119532	Bacteria	Bacteria	263	9.61e-66	NTclustered	gi\|2212803077\|gb\|CP031705.1\|	2303329	g43338	i0	85.771	3.28	253	30	100	6	1	250	1909922	1910171	Microcoleus vaginatus HSN003, whole genome shotgun sequence	blastn	820	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus
20686679	20686679	PRJNA1139127_P_NODE_41477_length_255_cov_1.005495_g40984_i0	PRJNA1139127	41477	255	1.005495	2.56401225	Microcoleus anatoxicus	2705319	Bacteria	Bacteria	228	3.589999999999999e-55	NTclustered	gi\|2812421464\|gb\|CP120853.1\|	2705319	g40984	i0	85.022	10.4705882352941	227	30	88	4	21	245	135732	135508	MAG: Microcoleus anatoxicus isolate Neu2020_A chromosome, complete genome	blastn	2670	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus anatoxicus
26849063	26849063	PRJNA1139127_P_NODE_14681_length_528_cov_1.224176_g14198_i0	PRJNA1139127	14681	528	1.224176	6.46364928	Cyanobacteria bacterium FACHB-63	2692766	Bacteria	Bacteria	70.5	1.16e-11	NR	MBD1847221.1	2692766	g14198	i0	77.8	0.528409090909091	45	10	25.6	0	507	373	119	163	MBD1847221.1 phage tail protein [Cyanobacteria bacterium FACHB-63]	diamond	279	70.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium FACHB-63
27418296	27418296	PRJNA1139127_P_NODE_42043_length_253_cov_0.866667_g41550_i0	PRJNA1139127	42043	253	0.866667	2.19266751	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	157	2.11e-42	NR	MBX9695215.1	2847862	g41550	i0	90.5	0.99604743083004	84	8	99.6	0	253	2	94	177	MBX9695215.1 Tn3 family transposase [Cyanobacteriota bacterium]	diamond	252	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28523249	28523249	PRJNA1139127_P_NODE_43627_length_250_cov_0.881356_g43134_i0	PRJNA1139127	43627	250	0.881356	2.20339	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	161	3.5099999999999998e-47	NR	MBX9571636.1	2364082	g43134	i0	100	0.996	83	0	99.6	0	1	249	109	191	MBX9571636.1 3-methyl-2-oxobutanoate hydroxymethyltransferase [Candidatus Obscuribacterales bacterium]	diamond	249	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium

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