metadata: contig_metadata: 19 rows where bioproject = "PRJNA902848" and tax_clade = "Cyanobacteriota/Melainabacteria group"

19 rows where bioproject = "PRJNA902848" 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
3798960	3798960	PRJNA902848_P_NODE_14123_length_251_cov_1.365169_g14073_i0	PRJNA902848	14123	251	1.365169	3.42657419	Aliterella	1827277	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|321140180\|gb\|GQ325743.1\|	1211	g14073	i0	100	99.99203187251	251	0	100	0	1	251	409	659	Uncultured cyanobacterium clone SP1_1B_34 16S ribosomal RNA gene, partial sequence	blastn	25098	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4710417	4710417	PRJNA902848_P_NODE_11444_length_269_cov_0.892857_g11394_i0	PRJNA902848	11444	269	0.892857	2.40178533	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	462	9.61e-126	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g11394	i0	98.842	156.174721189591	259	3	96	0	1	259	1779	1521	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	42011	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4710632	4710632	PRJNA902848_P_NODE_2084_length_512_cov_2.079727_g2035_i0	PRJNA902848	2084	512	2.079727	10.64820224	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	643	6.499999999999998e-180	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g2035	i0	89.341	128.396484375	516	49	100	6	1	512	2747	3260	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	65739	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7259974	7259974	PRJNA902848_P_NODE_13566_length_252_cov_0.871508_g13516_i0	PRJNA902848	13566	252	0.871508	2.19620016	Anabaena cylindrica	1165	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g13516	i0	97.222	9.46825396825397	252	7	100	0	1	252	1699590	1699339	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	2386	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
10175700	10175700	PRJNA902848_P_NODE_7408_length_321_cov_1.883065_g7358_i0	PRJNA902848	7408	321	1.883065	6.04463865	root	1	Root_unresolved	Root_unresolved	593	3.9899999999999986e-165	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g7358	i0	100	104.006230529595	321	0	100	0	1	321	342	22	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	33386	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
11085549	11085549	PRJNA902848_P_NODE_15089_length_250_cov_0.881356_g15039_i0	PRJNA902848	15089	250	0.881356	2.20339	Stanieria sp. PCC 7301	118165	Bacteria	Bacteria	436	5.349999999999999e-118	NTclustered	gi\|1373447558\|gb\|KY979120.1\|	118165	g15039	i0	98.776	173.144	245	3	98	0	1	245	22	266	Stanieria sp. PCC 7301 strain UTEX LB 1635 23S ribosomal RNA gene, partial sequence	blastn	43286	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. PCC 7301
12361012	12361012	PRJNA902848_P_NODE_20090_length_242_cov_0.923077_g20040_i0	PRJNA902848	20090	242	0.923077	2.23384634	Cyanobium sp. NS01	261284	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g20040	i0	86.498	17.8636363636364	237	30	98	2	7	242	2659854	2659619	Cyanobium sp. NS01 chromosome, complete genome	blastn	4323	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
25473567	25473567	PRJNA902848_P_NODE_12120_length_262_cov_1.068783_g12070_i0	PRJNA902848	12120	262	1.068783	2.80021146	Cyanophyceae	3028117	Bacteria	Bacteria	449	7.26e-122	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g12070	i0	97.701	137.603053435115	261	6	99	0	1	261	428	168	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36052	453	0.991169977924945	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25473576	25473576	PRJNA902848_P_NODE_12460_length_258_cov_1.281081_g12410_i0	PRJNA902848	12460	258	1.281081	3.30518898	Richelia	98443	Bacteria	Bacteria	390	4.38e-104	NTclustered	gi\|2059364121\|gb\|CP021056.1\|	1357546	g12410	i0	93.87	174.290697674419	261	13	100	3	1	258	2717816	2718076	Richelia sinica FACHB-800 strain FACHB 800 chromosome, complete genome	blastn	44967	392	0.994897959183674	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica
26802599	26802599	PRJNA902848_P_NODE_8281_length_307_cov_2.000000_g8231_i0	PRJNA902848	8281	307	2	6.14	cyanobacterium TDX16	1503470	Bacteria	Bacteria	61.6	5.27e-10	NR	OWY71756.1	1503470	g8231	i0	72	0.488599348534202	50	14	48.9	0	12	161	34	83	OWY71756.1 hypothetical protein B7486_08805 [cyanobacterium TDX16]	diamond	150	61.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16
26834462	26834462	PRJNA902848_P_NODE_16621_length_247_cov_1.787356_g16571_i0	PRJNA902848	16621	247	1.787356	4.41476932	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	157	1.7499999999999999e-46	NR	MEB3194172.1	2847862	g16571	i0	97.5	0.983805668016194	81	2	98.4	0	3	245	60	140	MEB3194172.1 ABC transporter ATP-binding protein [Cyanobacteriota bacterium]	diamond	243	157	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
26866289	26866289	PRJNA902848_P_NODE_10301_length_281_cov_1.418269_g10251_i0	PRJNA902848	10301	281	1.418269	3.98533589	Synechococcales	1890424	Bacteria	Bacteria	107	1.62e-28	NR	WP_198953869.1	1890424	g10251	i0	84.2	0.608540925266904	57	9	60.9	0	176	6	1	57	WP_198953869.1 MULTISPECIES: hypothetical protein [Synechococcales]	diamond	171	107	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales
28263425	28263425	PRJNA902848_P_NODE_15306_length_250_cov_0.881356_g15256_i0	PRJNA902848	15306	250	0.881356	2.20339	Bacillati	1783272	Bacteria	Bacteria	134	6.67e-36	NR	WP_323272828.1	1118279	g15256	i0	73.2	2.94	82	22	98.4	0	2	247	248	329	WP_323272828.1 ISAs1 family transposase [Limnoraphis robusta]	diamond	735	135	0.992592592592593	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnoraphis	Limnoraphis robusta
28571699	28571699	PRJNA902848_P_NODE_14247_length_251_cov_0.876404_g14197_i0	PRJNA902848	14247	251	0.876404	2.19977404	Nodosilinea sp.	2497642	Bacteria	Bacteria	59.7	4.28e-8	NR	MFM7324549.1	2497642	g14197	i0	43.4	2.86852589641434	83	43	95.6	2	11	250	202	283	MFM7324549.1 NADH-quinone oxidoreductase subunit M [Nodosilinea sp.]	diamond	720	59.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp.
30000388	30000388	PRJNA902848_P_NODE_20011_length_242_cov_0.923077_g19961_i0	PRJNA902848	20011	242	0.923077	2.23384634	Prochlorococcus	1218	Bacteria	Bacteria	118	9.529999999999999e-30	NR	WP_261792576.1	1219	g19961	i0	80.3	4.06611570247934	66	13	81.8	0	3	200	296	361	WP_261792576.1 FkbM family methyltransferase [Prochlorococcus marinus]	diamond	984	118	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus marinus
30845792	30845792	PRJNA902848_P_NODE_20374_length_242_cov_0.923077_g20324_i0	PRJNA902848	20374	242	0.923077	2.23384634	Nodosilinea sp.	2497642	Bacteria	Bacteria	58.2	1.34e-7	NR	HSM84046.1	2497642	g20324	i0	44.2	0.644628099173554	52	29	64.5	0	235	80	510	561	HSM84046.1 glycosyltransferase family 39 protein [Nodosilinea sp.]	diamond	156	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp.
31327328	31327328	PRJNA902848_P_NODE_18875_length_244_cov_0.912281_g18825_i0	PRJNA902848	18875	244	0.912281	2.22596564	Cyanophyceae	3028117	Bacteria	Bacteria	92.4	3.54e-20	NR	TAF53186.1	1151	g18825	i0	61.3	2.76639344262295	75	28	91	1	15	236	1	75	TAF53186.1 MAG: hypothetical protein EAZ61_07195 [Oscillatoriales cyanobacterium]	diamond	675	92.8	0.995689655172414	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium
31446330	31446330	PRJNA902848_P_NODE_17616_length_246_cov_0.901734_g17566_i0	PRJNA902848	17616	246	0.901734	2.21826564	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	150	3.7e-42	NR	MBL0189678.1	2711154	g17566	i0	86.4	0.98780487804878	81	11	98.8	0	245	3	36	116	MBL0189678.1 aldo/keto reductase [Candidatus Obscuribacter sp.]	diamond	243	150	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32490529	32490529	PRJNA902848_P_NODE_6739_length_333_cov_2.615385_g6689_i0	PRJNA902848	6739	333	2.615385	8.70923205	cyanobacterium TDX16	1503470	Bacteria	Bacteria	49.3	4.68e-5	NR	OWY71756.1	1503470	g6689	i0	70.3	0.333333333333333	37	11	33.3	0	195	85	47	83	OWY71756.1 hypothetical protein B7486_08805 [cyanobacterium TDX16]	diamond	111	49.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					cyanobacterium TDX16

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