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

11 rows where bioproject = "PRJNA835051" 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
2101627	2101627	PRJNA835051_S_NODE_48882_length_218_cov_2.171429_g48586_i0	PRJNA835051	48882	218	2.171429	4.73371522	uncultured Rivularia sp.	447564	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g48586	i0	100	0.128440366972477	28	0	13	0	2	29	8263514	8263541	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
7607346	7607346	PRJNA835051_S_NODE_115646_length_159_cov_1.620690_g115350_i0	PRJNA835051	115646	159	1.62069	2.5768971	Oscillatoriales	1150	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|1566846289\|dbj\|LC455669.1\|	118562	g115350	i0	100	171.22641509434	159	0	100	0	1	159	32	190	Arthrospira platensis NIES-46 gene for 23S ribosomal RNA, partial sequence	blastn	27225	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira platensis
12305770	12305770	PRJNA835051_S_NODE_85350_length_180_cov_2.065693_g85054_i0	PRJNA835051	85350	180	2.065693	3.7182474	uncultured Rivularia sp.	447564	Bacteria	Bacteria	69.4	1.52e-7	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g85054	i0	95.455	66.3611111111111	44	1	24	1	137	180	8260939	8260897	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	11945	69.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
27117621	27117621	PRJNA835051_S_NODE_41702_length_229_cov_1.290323_g41406_i0	PRJNA835051	41702	229	1.290323	2.95483967	Oculatellaceae cyanobacterium	3088181	Bacteria	Bacteria	146	6.179999999999998e-42	NR	HEY9755775.1	3088181	g41406	i0	100	1.99126637554585	76	0	99.6	0	229	2	170	245	HEY9755775.1 DeoR/GlpR family DNA-binding transcription regulator [Oculatellaceae cyanobacterium]	diamond	456	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae		Oculatellaceae cyanobacterium
27339229	27339229	PRJNA835051_S_NODE_21303_length_272_cov_2.454148_g21007_i0	PRJNA835051	21303	272	2.454148	6.67528256	Synechocystis sp. LKSZ1	3144951	Bacteria	Bacteria	46.2	0.00313	NR	WP_353671840.1	3144951	g21007	i0	50	0.397058823529412	36	15	36.4	1	207	109	177	212	WP_353671840.1 SulP family inorganic anion transporter [Synechocystis sp. LKSZ1]	diamond	108	46.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. LKSZ1
28917617	28917617	PRJNA835051_S_NODE_26048_length_259_cov_2.199074_g25752_i0	PRJNA835051	26048	259	2.199074	5.69560166	Nostocales	1161	Bacteria	Bacteria	43.1	0.0338	NR	WP_038074897.1	1161	g25752	i0	53.3	0.347490347490348	30	14	34.7	0	148	59	259	288	WP_038074897.1 MULTISPECIES: ATP-binding protein [Nostocales]	diamond	90	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales
30307893	30307893	PRJNA835051_S_NODE_44232_length_225_cov_1.307692_g43936_i0	PRJNA835051	44232	225	1.307692	2.942307	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	137	2.08e-39	NR	MFA7336101.1	2364082	g43936	i0	84.9	1.94666666666667	73	11	97.3	0	220	2	61	133	MFA7336101.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	438	137	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
30559919	30559919	PRJNA835051_S_NODE_26173_length_259_cov_1.703704_g25877_i0	PRJNA835051	26173	259	1.703704	4.41259336	Synechococcus sp. WH 8	1131	Bacteria	Bacteria	41.6	0.0323	NR	EHA63790.1	166318	g25877	i0	33.8	0.926640926640927	80	47	85.7	3	248	27	6	85	EHA63790.1 hypothetical protein Syn8016DRAFT_0831 [Synechococcus sp. WH 8016]	diamond	240	41.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. WH 8016
30916389	30916389	PRJNA835051_S_NODE_74134_length_190_cov_1.292517_g73838_i0	PRJNA835051	74134	190	1.292517	2.4557823	Bacteria	2	Bacteria	Bacteria	128	1.03e-32	NR	HCB11816.1	2055789	g73838	i0	100	2.93684210526316	62	0	97.9	0	3	188	61	122	HCB11816.1 hypothetical protein [Cyanobacteria bacterium UBA11991]	diamond	558	128	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11991
32109410	32109410	PRJNA835051_S_NODE_33538_length_243_cov_1.425000_g33242_i0	PRJNA835051	33538	243	1.425	3.46275	Pleurocapsa minor	54308	Bacteria	Bacteria	42.4	0.0499	NR	MBW4437650.1	2839663	g33242	i0	39.6	0.654320987654321	53	30	64.2	2	78	233	155	206	MBW4437650.1 MFS transporter [Pleurocapsa minor GSE-CHR-MK 17-07R]	diamond	159	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa minor
32584093	32584093	PRJNA835051_S_NODE_106999_length_164_cov_2.925620_g106703_i0	PRJNA835051	106999	164	2.92562	4.7980168	Aliterella atlantica	1827278	Bacteria	Bacteria	90.5	1.89e-19	NR	WP_045053616.1	1827278	g106703	i0	85.2	0.98780487804878	54	8	98.8	0	163	2	30	83	WP_045053616.1 GumC family protein [Aliterella atlantica]	diamond	162	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella atlantica

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