metadata: contig_metadata: 14 rows where bioproject = "PRJNA421571", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

14 rows where bioproject = "PRJNA421571", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
2361021	2361021	PRJNA421571_P_NODE_27982_length_623_cov_2.538182_g25477_i0	PRJNA421571	27982	623	2.538182	15.81287386	Cyanophyceae	3028117	Bacteria	Bacteria	270	2.1899999999999994e-89	NR	NJK59565.1	2720466	g25477	i0	74.6	6.78491171749599	173	44	83.3	0	19	537	5	177	NJK59565.1 peroxiredoxin [Oscillatoriales cyanobacterium SM2_1_8]	diamond	4227	271	0.996309963099631	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales			Oscillatoriales cyanobacterium SM2_1_8
13175619	13175619	PRJNA421571_P_NODE_103411_length_243_cov_0.905882_g100862_i0	PRJNA421571	103411	243	0.905882	2.20129326	Prochlorococcus sp. MIT 1011	3082520	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2895599930\|gb\|CP138983.1\|	3082520	g100862	i0	100	0.119341563786008	29	0	12	0	155	183	1493733	1493761	Prochlorococcus sp. MIT 1011 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Prochlorococcus	Prochlorococcus sp. MIT 1011
13178139	13178139	PRJNA421571_P_NODE_94951_length_249_cov_0.875000_g92402_i0	PRJNA421571	94951	249	0.875	2.17875	Planktothricoides raciborskii	132608	Bacteria	Bacteria	75	4.81e-9	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g92402	i0	91.071	13.3172690763052	56	3	22	1	77	132	4742346	4742293	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	3316	75	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
15726931	15726931	PRJNA421571_P_NODE_88233_length_258_cov_1.664865_g85684_i0	PRJNA421571	88233	258	1.664865	4.2953517	Cyanobacteria bacterium P01_A01_bin.135	3023243	Bacteria	Bacteria	139	5.5e-40	NR	MEO0406224.1	3023243	g85684	i0	75.3	1.97674418604651	85	21	98.8	0	256	2	51	135	MEO0406224.1 nucleoside-diphosphate kinase [Cyanobacteria bacterium P01_A01_bin.135]	diamond	510	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.135
26917484	26917484	PRJNA421571_P_NODE_92582_length_251_cov_0.865169_g90033_i0	PRJNA421571	92582	251	0.865169	2.17157419	Leptolyngbyaceae cyanobacterium bins.59	2971804	Bacteria	Bacteria	138	2.72e-38	NR	MDX2098332.1	2971804	g90033	i0	74.7	2.97609561752988	83	21	99.2	0	3	251	89	171	MDX2098332.1 metal-dependent phosphohydrolase [Leptolyngbyaceae cyanobacterium bins.59]	diamond	747	138	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae		Leptolyngbyaceae cyanobacterium bins.59
27075612	27075612	PRJNA421571_P_NODE_103462_length_243_cov_0.905882_g100913_i0	PRJNA421571	103462	243	0.905882	2.20129326	Cyanobacteria bacterium SZAS LIN-3	2807732	Bacteria	Bacteria	93.2	5.56e-20	NR	MBS1993985.1	2807732	g100913	i0	60.8	0.975308641975309	79	29	97.5	2	240	4	370	446	MBS1993985.1 IS1380 family transposase [Cyanobacteria bacterium SZAS LIN-3]	diamond	237	93.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium SZAS LIN-3
27107070	27107070	PRJNA421571_P_NODE_60062_length_339_cov_1.928571_g57513_i0	PRJNA421571	60062	339	1.928571	6.53785569	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0243	NR	MEB3306271.1	2847862	g57513	i0	34.2	0.672566371681416	76	42	67.3	1	95	322	1	68	MEB3306271.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	228	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28307384	28307384	PRJNA421571_P_NODE_43466_length_436_cov_1.214876_g40918_i0	PRJNA421571	43466	436	1.214876	5.29685936	Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40	3070899	Bacteria	Bacteria	181	1.3900000000000001e-49	NR	MDQ5938180.1	3070899	g40918	i0	61.4	2.99311926605505	145	56	99.8	0	435	1	64	208	MDQ5938180.1 hypothetical protein [Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40]	diamond	1305	181	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium erpe_2018_sw_21hr_WHONDRS-SW48-000092_B_bin.40
29033815	29033815	PRJNA421571_P_NODE_32268_length_556_cov_1.753623_g29732_i0	PRJNA421571	32268	556	1.753623	9.75014388	Cyanobacteria bacterium P01_A01_bin.114	3023240	Bacteria	Bacteria	102	7.720000000000001e-22	NR	MEO0459073.1	3023240	g29732	i0	35.3	2.74640287769784	184	71	98.2	6	1	546	342	479	MEO0459073.1 carotenoid oxygenase family protein [Cyanobacteria bacterium P01_A01_bin.114]	diamond	1527	102	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.114
29696234	29696234	PRJNA421571_P_NODE_54490_length_365_cov_1.054795_g51941_i0	PRJNA421571	54490	365	1.054795	3.85000175	Cyanobacteria bacterium HKST-UBA02	2775582	Bacteria	Bacteria	182	2.27e-50	NR	MCA9801389.1	2775582	g51941	i0	80.2	2.98356164383562	121	24	99.5	0	2	364	425	545	MCA9801389.1 efflux RND transporter permease subunit [Cyanobacteria bacterium HKST-UBA02]	diamond	1089	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium HKST-UBA02
29727935	29727935	PRJNA421571_P_NODE_68570_length_308_cov_1.923404_g66021_i0	PRJNA421571	68570	308	1.923404	5.92408432	Scytonema sp. RU_4_4	2720447	Bacteria	Bacteria	50.1	1.95e-4	NR	NJM73224.1	2720447	g66021	i0	38.8	0.652597402597403	67	39	63.3	2	200	6	267	333	NJM73224.1 CHAT domain-containing protein [Scytonema sp. RU_4_4]	diamond	201	50.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Scytonemataceae	Scytonema	Scytonema sp. RU_4_4
29917822	29917822	PRJNA421571_P_NODE_106531_length_241_cov_0.916667_g103982_i0	PRJNA421571	106531	241	0.916667	2.20916747	Cyanobacteria bacterium P01_G01_bin.38	3023303	Bacteria	Bacteria	48.5	3.26e-4	NR	MEM8808590.1	3023303	g103982	i0	45.7	0.572614107883817	46	23	57.3	1	6	143	457	500	MEM8808590.1 hypothetical protein [Cyanobacteria bacterium P01_G01_bin.38]	diamond	138	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_G01_bin.38
32098750	32098750	PRJNA421571_P_NODE_29998_length_590_cov_1.477756_g27477_i0	PRJNA421571	29998	590	1.477756	8.7187604	Cyanobacteria bacterium J06597_1	3023147	Bacteria	Bacteria	81.6	3.88e-14	NR	MEL7083842.1	3023147	g27477	i0	44.8	4.03220338983051	96	53	48.8	0	6	293	774	869	MEL7083842.1 ATP-dependent chaperone ClpB [Cyanobacteria bacterium J06597_1]	diamond	2379	81.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J06597_1
32178864	32178864	PRJNA421571_P_NODE_96798_length_248_cov_0.880000_g94249_i0	PRJNA421571	96798	248	0.88	2.1824	Leptolyngbya	47251	Bacteria	Bacteria	50.4	7.54e-5	NR	MBE7383934.1	2607768	g94249	i0	74.1	1.30645161290323	27	7	32.7	0	236	156	558	584	MBE7383934.1 hypothetical protein [Leptolyngbya sp. SIO1E4]	diamond	324	50.8	0.992125984251969	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. SIO1E4

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