metadata: contig_metadata: 8 rows where bioproject = "PRJNA543299" and tax_clade = "Cyanobacteriota/Melainabacteria group"

8 rows where bioproject = "PRJNA543299" 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
10713696	10713696	PRJNA543299_P_NODE_19529_length_170_cov_1.099174_g19372_i0	PRJNA543299	19529	170	1.099174	1.8685958	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	191	2.89e-44	NTclustered	gi\|225696206\|gb\|FJ805873.1\|	259957	g19372	i0	88.199	107.664705882353	161	18	94	1	1	160	3133	2973	Uncultured Chroococcidiopsis sp. clone A2_15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	18303	191	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
22186473	22186473	PRJNA543299_P_NODE_25138_length_162_cov_0.902655_g24981_i0	PRJNA543299	25138	162	0.902655	1.4623011	Chamaesiphon minutus	1173032	Bacteria	Bacteria	278	2.04e-70	NTclustered	gi\|485099149\|ref\|NR_102544.1\|	1173020	g24981	i0	97.531	154.253086419753	162	4	100	0	1	162	1063	902	Chamaesiphon minutus PCC 6605 strain PCC 6605 23S ribosomal RNA, complete sequence	blastn	24989	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Gomontiellales	Chamaesiphonaceae	Chamaesiphon	Chamaesiphon minutus
27014555	27014555	PRJNA543299_P_NODE_20362_length_167_cov_0.864407_g20205_i0	PRJNA543299	20362	167	0.864407	1.44355969	Komarekiella delphini-convector	3050158	Bacteria	Bacteria	42.4	0.0183	NR	WP_191758044.1	3050158	g20205	i0	42.6	1.94011976047904	54	30	95.2	1	2	160	261	314	WP_191758044.1 patatin-like phospholipase family protein [Komarekiella delphini-convector]	diamond	324	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Komarekiella	Komarekiella delphini-convector
27930733	27930733	PRJNA543299_P_NODE_16165_length_187_cov_1.014493_g16008_i0	PRJNA543299	16165	187	1.014493	1.89710191	Cyanobium sp. FGCU6	2974642	Bacteria	Bacteria	42	0.0333	NR	MCS5693127.1	2974642	g16008	i0	42.3	0.834224598930481	52	28	80.2	1	10	159	14	65	MCS5693127.1 metallophosphoesterase [Cyanobium sp. FGCU6]	diamond	156	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. FGCU6
28783064	28783064	PRJNA543299_P_NODE_25867_length_161_cov_0.910714_g25710_i0	PRJNA543299	25867	161	0.910714	1.46624954	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	45.4	0.00136	NR	MBX9685888.1	2364082	g25710	i0	40.4	0.875776397515528	47	28	87.6	0	15	155	184	230	MBX9685888.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	141	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales bacterium
29113906	29113906	PRJNA543299_P_NODE_24148_length_163_cov_0.894737_g23991_i0	PRJNA543299	24148	163	0.894737	1.45842131	Gloeothece	28070	Bacteria	Bacteria	62.4	1.44e-9	NR	WP_012597707.1	2546356	g23991	i0	66.7	3.90184049079755	42	14	77.3	0	129	4	1	42	WP_012597707.1 1-deoxy-D-xylulose-5-phosphate reductoisomerase [Gloeothece citriformis]	diamond	636	62.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece citriformis
29208708	29208708	PRJNA543299_P_NODE_22389_length_165_cov_0.879310_g22232_i0	PRJNA543299	22389	165	0.87931	1.4508615	Bacteria	2	Bacteria	Bacteria	61.2	3.71e-9	NR	MBD1832446.1	2692764	g22232	i0	69	1.52727272727273	42	13	76.4	0	39	164	1	42	MBD1832446.1 site-specific integrase [Cyanobacteria bacterium FACHB-472]	diamond	252	61.6	0.993506493506494	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium FACHB-472
30029702	30029702	PRJNA543299_P_NODE_8071_length_261_cov_1.150943_g7914_i0	PRJNA543299	8071	261	1.150943	3.00396123	Scytonema	1203	Bacteria	Bacteria	53.9	5.36e-6	NR	WP_073635825.1	1137095	g7914	i0	58.3	1.24137931034483	36	15	41.4	0	71	178	869	904	WP_073635825.1 hypothetical protein [Scytonema sp. HK-05]	diamond	324	53.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. HK-05

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