metadata: contig_metadata: 16 rows where bioproject = "PRJEB30004" and tax_clade = "Cyanobacteriota/Melainabacteria group"

16 rows where bioproject = "PRJEB30004" 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
2577006	2577006	PRJEB30004_P_NODE_104023_length_610_cov_3.005254_g88984_i0	PRJEB30004	104023	610	3.005254	18.3320494	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	344	8.9e-90	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g88984	i0	77.671	89.055737704918	627	99	99	31	6	606	1478124	1478735	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	54324	344	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
4816500	4816500	PRJEB30004_P_NODE_465204_length_202_cov_1.901840_g449577_i0	PRJEB30004	465204	202	1.90184	3.8417168	Bacteria	2	Bacteria	Bacteria	374	3.3e-99	NTclustered	gi\|389547670\|gb\|JQ402598.1\|	1211	g449577	i0	100	96.7029702970297	202	0	100	0	1	202	4	205	Uncultured cyanobacterium clone CNY_02999 16S ribosomal RNA gene, partial sequence	blastn	19534	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
5144237	5144237	PRJEB30004_P_NODE_425325_length_216_cov_3.593220_g409698_i0	PRJEB30004	425325	216	3.59322	7.7613552	cyanobacterium endosymbiont of Rhopalodia gibberula	1763363	Bacteria	Bacteria	82.4	2.43e-11	NTclustered	gi\|1264230396\|dbj\|AP018341.1\|	1763363	g409698	i0	88.235	7.65740740740741	68	8	31	0	18	85	1576176	1576109	Cyanobacterium endosymbiont of Rhopalodia gibberula DNA, complete genome, isolate: RgSB	blastn	1654	82.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium endosymbiont of Rhopalodia gibberula
8971024	8971024	PRJEB30004_P_NODE_469608_length_201_cov_1.240741_g453981_i0	PRJEB30004	469608	201	1.240741	2.49388941	Gloeocapsa sp. 20201027-1	2802214	Bacteria	Bacteria	292	9.46e-75	NTclustered	gi\|1953559107\|gb\|MW449597.1\|	2802214	g453981	i0	95.135	102.442786069652	185	9	92	0	1	185	364	180	Gloeocapsa sp. 20201027-1 23S ribosomal RNA gene, partial sequence	blastn	20591	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. 20201027-1
8972836	8972836	PRJEB30004_P_NODE_507288_length_189_cov_2.233333_g491661_i0	PRJEB30004	507288	189	2.233333	4.22099937	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	124	3.3899999999999996e-24	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g491661	i0	97.26	98.9470899470899	73	2	39	0	1	73	3680959	3681031	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	18701	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
19176439	19176439	PRJEB30004_P_NODE_614856_length_164_cov_1.136000_g599229_i0	PRJEB30004	614856	164	1.136	1.86304	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	202	1.28e-47	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g599229	i0	89.375	289.94512195122	160	17	98	0	1	160	1768	1927	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	47551	202	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20115174	20115174	PRJEB30004_P_NODE_569556_length_173_cov_2.320896_g553929_i0	PRJEB30004	569556	173	2.320896	4.01515008	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	115	1.58e-28	NR	WP_008235596.1	1164990	g553929	i0	87.7	19.7687861271676	57	7	98.8	0	171	1	461	517	WP_008235596.1 nickel-dependent hydrogenase large subunit [Richelia intracellularis]	diamond	3420	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia intracellularis
21390642	21390642	PRJEB30004_P_NODE_218197_length_355_cov_3.686709_g202570_i0	PRJEB30004	218197	355	3.686709	13.08781695	root	1	Root_unresolved	Root_unresolved	656	0	NTclustered	gi\|238632324\|gb\|FJ967932.1\|	1211	g202570	i0	100	100.997183098592	355	0	100	0	1	355	783	429	Uncultured cyanobacterium clone BAC_2_G07 16S ribosomal RNA (rrn) gene, partial sequence	blastn	35854	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
26741465	26741465	PRJEB30004_P_NODE_255261_length_317_cov_1.834532_g239634_i0	PRJEB30004	255261	317	1.834532	5.81546644	Stenomitos	1844270	Bacteria	Bacteria	131	5.67e-33	NR	MCY7282017.1	2880266	g239634	i0	58.5	4.00315457413249	106	40	98.4	3	5	316	364	467	MCY7282017.1 toxin [Cyanobacteria bacterium CAN_BIN43]	diamond	1269	132	0.992424242424242	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CAN_BIN43
27633674	27633674	PRJEB30004_P_NODE_540324_length_180_cov_2.843972_g524697_i0	PRJEB30004	540324	180	2.843972	5.1191496	Chamaesiphon polymorphus	2107691	Bacteria	Bacteria	45.4	0.00173	NR	WP_106299967.1	2107691	g524697	i0	51.3	0.65	39	19	65	0	119	3	13	51	WP_106299967.1 SGNH/GDSL hydrolase family protein [Chamaesiphon polymorphus]	diamond	117	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon polymorphus
29338631	29338631	PRJEB30004_P_NODE_473509_length_199_cov_2.612500_g457882_i0	PRJEB30004	473509	199	2.6125	5.198875	Synechococcus sp. CCY	1131	Bacteria	Bacteria	91.3	1.86e-20	NR	WP_216910510.1	2815603	g457882	i0	60	0.979899497487437	65	26	98	0	195	1	3	67	WP_216910510.1 hypothetical protein [Synechococcus sp. CCY 0621]	diamond	195	91.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CCY 0621
29458015	29458015	PRJEB30004_P_NODE_257750_length_315_cov_1.528986_g242123_i0	PRJEB30004	257750	315	1.528986	4.8163059	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	163	3.48e-44	NR	HVO23940.1	2053573	g242123	i0	76.5	1.95238095238095	102	24	97.1	0	8	313	785	886	HVO23940.1 TonB-dependent receptor [Candidatus Margulisiibacteriota bacterium]	diamond	615	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
30216176	30216176	PRJEB30004_P_NODE_462572_length_203_cov_1.707317_g446945_i0	PRJEB30004	462572	203	1.707317	3.46585351	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	90.5	3.34e-19	NR	MFN9661037.1	2847862	g446945	i0	65.6	4.41871921182266	61	21	90.1	0	188	6	598	658	MFN9661037.1 amino acid adenylation domain-containing protein [Cyanobacteriota bacterium]	diamond	897	90.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32119813	32119813	PRJEB30004_P_NODE_293138_length_286_cov_3.975709_g277511_i0	PRJEB30004	293138	286	3.975709	11.37052774	Alkalinema sp. FACHB-956	2692768	Bacteria	Bacteria	125	4.059999999999999e-31	NR	WP_190574486.1	2692768	g277511	i0	60.9	1.93006993006993	92	36	96.5	0	1	276	1029	1120	WP_190574486.1 SpvB/TcaC N-terminal domain-containing protein [Alkalinema sp. FACHB-956]	diamond	552	125	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Alkalinema	Alkalinema sp. FACHB-956
32531169	32531169	PRJEB30004_P_NODE_491099_length_194_cov_1.593548_g475472_i0	PRJEB30004	491099	194	1.593548	3.09148312	Tildeniella nuda	2303521	Bacteria	Bacteria	45.8	2.91e-4	NR	MBW4578520.1	2136405	g475472	i0	59.4	1.48453608247423	32	13	49.5	0	194	99	63	94	MBW4578520.1 DUF1871 family protein [Tildeniella nuda ZEHNDER 1965/U140]	diamond	288	45.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Tildeniella	Tildeniella nuda
32650312	32650312	PRJEB30004_P_NODE_632420_length_160_cov_1.867769_g616793_i0	PRJEB30004	632420	160	1.867769	2.9884304	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	48.1	1.53e-4	NR	HEY9841736.1	2364082	g616793	i0	50	3.8625	52	23	95.6	2	153	1	1233	1282	HEY9841736.1 amino acid adenylation domain-containing protein [Candidatus Obscuribacterales bacterium]	diamond	618	48.5	0.991752577319588	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);;