metadata: contig_metadata: 14 rows where bioproject = "PRJNA798511" and tax_clade = "Cyanobacteriota/Melainabacteria group"

14 rows where bioproject = "PRJNA798511" 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
3769460	3769460	PRJNA798511_P_NODE_87303_length_252_cov_1.648045_g83037_i0	PRJNA798511	87303	252	1.648045	4.1530734	Planktothrix	54304	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|224581510\|gb\|FJ184461.1\|	603417	g83037	i0	100	0.333333333333333	28	0	11	0	225	252	564	537	Planktothrix mougeotii HAB3342 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; and RbcX (rbcX) gene, complete cds	blastn	84	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix mougeotii
8444173	8444173	PRJNA798511_P_NODE_86447_length_254_cov_1.276243_g82181_i0	PRJNA798511	86447	254	1.276243	3.24165722	Cyanobacterium stanieri	102235	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|428686127\|gb\|CP003940.1\|	292563	g82181	i0	100	0.110236220472441	28	0	11	0	110	137	1369336	1369309	Cyanobacterium stanieri PCC 7202, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium stanieri
13544659	13544659	PRJNA798511_P_NODE_82571_length_261_cov_1.638298_g78305_i0	PRJNA798511	82571	261	1.638298	4.27595778	Synechocystis sp. PCC 7339	2782213	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2092583171\|gb\|CP063659.1\|	2782213	g78305	i0	100	0.10727969348659	28	0	11	0	186	213	821098	821071	Synechocystis sp. PCC 7339 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 7339
19917875	19917875	PRJNA798511_P_NODE_79776_length_267_cov_1.494845_g75510_i0	PRJNA798511	79776	267	1.494845	3.99123615	Cyanobacterium sp. HL-69	2054282	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1298149266\|gb\|CP024912.1\|	2054282	g75510	i0	100	0.104868913857678	28	0	10	0	147	174	3042719	3042692	Cyanobacterium sp. HL-69 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Cyanobacterium	Cyanobacterium sp. HL-69
21193475	21193475	PRJNA798511_P_NODE_77857_length_271_cov_1.939394_g73591_i0	PRJNA798511	77857	271	1.939394	5.25575774	Gloeothece verrucosa	2546359	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|306980173\|gb\|CP002198.1\|	497965	g73591	i0	96.97	0.121771217712177	33	0	12	1	78	109	1255595	1255627	Cyanothece sp. PCC 7822, complete genome	blastn	33	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Aphanothecaceae	Gloeothece	Gloeothece verrucosa
27180119	27180119	PRJNA798511_P_NODE_60282_length_317_cov_0.946721_g56016_i0	PRJNA798511	60282	317	0.946721	3.00110557	Cyanobacteria bacterium J06614_10	3023159	Bacteria	Bacteria	58.9	1.74e-7	NR	MEL6606504.1	3023159	g56016	i0	40.3	1.49526813880126	67	40	63.4	0	3	203	115	181	MEL6606504.1 reverse transcriptase family protein [Cyanobacteria bacterium J06614_10]	diamond	474	58.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06614_10
27938477	27938477	PRJNA798511_P_NODE_79265_length_268_cov_1.579487_g74999_i0	PRJNA798511	79265	268	1.579487	4.23302516	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	110	5.74e-26	NR	MEL7079339.1	3023143	g74999	i0	56.3	0.973880597014925	87	38	97.4	0	8	268	105	191	MEL7079339.1 reverse transcriptase domain-containing protein [Cyanobacteria bacterium J06582_2]	diamond	261	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
29075244	29075244	PRJNA798511_P_NODE_64008_length_305_cov_1.603448_g59742_i0	PRJNA798511	64008	305	1.603448	4.8905164	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	63.9	2.81e-9	NR	MDJ0596593.1	3036786	g59742	i0	46	0.619672131147541	63	34	62	0	80	268	832	894	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	189	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13
29264261	29264261	PRJNA798511_P_NODE_21909_length_731_cov_1.480243_g17844_i0	PRJNA798511	21909	731	1.480243	10.82057633	Cyanobacteria bacterium J06582_2	3023143	Bacteria	Bacteria	48.9	0.014	NR	MEL7079323.1	3023143	g17844	i0	36.2	1.0875512995896	58	37	23.8	0	317	490	1194	1251	MEL7079323.1 hypothetical protein [Cyanobacteria bacterium J06582_2]	diamond	795	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06582_2
30749047	30749047	PRJNA798511_P_NODE_64314_length_304_cov_2.463203_g60048_i0	PRJNA798511	64314	304	2.463203	7.48813712	Microcystis sp. 53602_E8	2904984	Bacteria	Bacteria	64.3	2.05e-9	NR	MCE2664493.1	2904984	g60048	i0	54.2	0.473684210526316	48	22	47.4	0	109	252	744	791	MCE2664493.1 hypothetical protein [Microcystis sp. 53602_E8]	diamond	144	64.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. 53602_E8
30812175	30812175	PRJNA798511_P_NODE_71334_length_286_cov_1.084507_g67068_i0	PRJNA798511	71334	286	1.084507	3.10169002	Cyanobacteria bacterium J06553_1	3023125	Bacteria	Bacteria	47.4	0.00141	NR	MEL7522491.1	3023125	g67068	i0	38.6	0.734265734265734	70	40	72.4	2	19	225	322	389	MEL7522491.1 ribonuclease H family protein [Cyanobacteria bacterium J06553_1]	diamond	210	47.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06553_1
31737938	31737938	PRJNA798511_P_NODE_53977_length_339_cov_1.323308_g49711_i0	PRJNA798511	53977	339	1.323308	4.48601412	Dolichospermum	748770	Bacteria	Bacteria	43.5	0.0418	NR	WP_137906556.1	136072	g49711	i0	45.2	0.743362831858407	42	23	37.2	0	144	19	125	166	WP_137906556.1 (2Fe-2S) ferredoxin domain-containing protein [Dolichospermum planctonicum]	diamond	252	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Dolichospermum	Dolichospermum planctonicum
31760668	31760668	PRJNA798511_P_NODE_80257_length_266_cov_1.440415_g75991_i0	PRJNA798511	80257	266	1.440415	3.8315039	Microcoleus sp. herbarium14	3055439	Bacteria	Bacteria	44.3	0.0135	NR	WP_333365481.1	3055439	g75991	i0	25.6	0.924812030075188	82	56	86.8	1	239	9	266	347	WP_333365481.1 SDR family NAD(P)-dependent oxidoreductase [Microcoleus sp. herbarium14]	diamond	246	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus sp. herbarium14
32140407	32140407	PRJNA798511_P_NODE_19458_length_826_cov_2.253652_g15539_i0	PRJNA798511	19458	826	2.253652	18.61516552	Pleurocapsa sp. MO_226.B13	3036786	Bacteria	Bacteria	68.9	4.69e-9	NR	MDJ0596593.1	3036786	g15539	i0	53.4	1.12227602905569	58	27	21.1	0	51	224	837	894	MDJ0596593.1 reverse transcriptase family protein [Pleurocapsa sp. MO_226.B13]	diamond	927	68.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Hyellaceae	Pleurocapsa	Pleurocapsa sp. MO_226.B13

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