metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax_clade = "Cyanobacteriota/Melainabacteria group"

15 rows where analysis = "blastn", bioproject = "PRJNA473824" 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
446663	446663	PRJNA473824_P_NODE_171321_length_150_cov_2.946903_g170683_i0	PRJNA473824	171321	150	2.946903	4.4203545	Pseudanabaena sp. Chao 1811	2963092	Bacteria	Bacteria	145	1.9599999999999997e-30	NTclustered	gi\|2429870828\|gb\|CP101416.1\|	2963092	g170683	i0	84.568	2.16	162	7	96	2	1	144	3407358	3407519	Pseudanabaena sp. Chao 1811 chromosome, complete genome	blastn	324	145	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. Chao 1811
447312	447312	PRJNA473824_P_NODE_77341_length_173_cov_3.529412_g76703_i0	PRJNA473824	77341	173	3.529412	6.10588276	Chroococcidiopsis sp. CCNUC1	2653189	Bacteria	Bacteria	139	1.08e-28	NTclustered	gi\|2245130261\|gb\|CP097481.1\|	2653189	g76703	i0	100	0.872832369942196	75	0	87	0	99	173	199573	199499	Chroococcidiopsis sp. CCNUC1 plasmid pA, complete sequence	blastn	151	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCNUC1
4273628	4273628	PRJNA473824_P_NODE_19064_length_271_cov_1.286325_g18426_i0	PRJNA473824	19064	271	1.286325	3.48594075	Chroococcidiopsis thermalis	54299	Bacteria	Bacteria	289	1.74e-73	NTclustered	gi\|428006994\|gb\|CP003597.1\|	251229	g18426	i0	86.923	132.464944649446	260	30	95	4	1	258	1272804	1273061	Chroococcidiopsis thermalis PCC 7203, complete genome	blastn	35898	289	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
8099347	8099347	PRJNA473824_P_NODE_127967_length_160_cov_5.707317_g127329_i0	PRJNA473824	127967	160	5.707317	9.1317072	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	163	5.88e-36	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g127329	i0	85	5.05	160	24	100	0	1	160	2189291	2189132	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	808	163	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
9374761	9374761	PRJNA473824_P_NODE_40128_length_192_cov_1.509677_g39490_i0	PRJNA473824	40128	192	1.509677	2.89857984	Planktothricoides raciborskii	132608	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2754673971\|gb\|CP159837.1\|	2792601	g39490	i0	100	0.734375	29	0	15	0	164	192	4513357	4513329	Planktothricoides raciborskii GIHE-MW2 chromosome, complete genome	blastn	141	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Planktothricoides	Planktothricoides raciborskii
11924880	11924880	PRJNA473824_P_NODE_125390_length_164_cov_1.842520_g124752_i0	PRJNA473824	125390	164	1.84252	3.0217328	Gloeocapsa sp. PCC 7428	1173026	Bacteria	Bacteria	143	7.9e-30	NTclustered	gi\|428262672\|gb\|CP003646.1\|	1173026	g124752	i0	85.401	6.03658536585366	137	20	84	0	1	137	2827119	2826983	Gloeocapsa sp. PCC 7428, complete genome	blastn	990	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsa	Gloeocapsa sp. PCC 7428
11924936	11924936	PRJNA473824_P_NODE_129830_length_158_cov_2.256198_g129192_i0	PRJNA473824	129830	158	2.256198	3.56479284	Calothrix sp. NIES-3974	2005462	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1210184319\|dbj\|AP018254.1\|	2005462	g129192	i0	100	0.563291139240506	29	0	20	0	97	125	5069792	5069764	Calothrix sp. NIES-3974 DNA, complete genome	blastn	89	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-3974
11925719	11925719	PRJNA473824_P_NODE_51330_length_174_cov_1.065693_g50692_i0	PRJNA473824	51330	174	1.065693	1.85430582	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	126	8.5e-25	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g50692	i0	86.726	92.5747126436782	113	15	65	0	5	117	3680970	3681082	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	16108	126	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
13199798	13199798	PRJNA473824_P_NODE_113791_length_173_cov_2.367647_g113153_i0	PRJNA473824	113791	173	2.367647	4.09602931	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	97.1	6.62e-16	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g113153	i0	89.474	0.439306358381503	76	8	44	0	98	173	2675002	2675077	Allocoleopsis franciscana PCC 7113, complete genome	blastn	76	97.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
13849698	13849698	PRJNA473824_P_NODE_10771_length_380_cov_10.679300_g10140_i0	PRJNA473824	10771	380	10.6793	40.58134	Anabaenopsis	110103	Bacteria	Bacteria	351	3.19e-92	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g10140	i0	83.594	94.6710526315789	384	53	99	9	1	378	6832032	6831653	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	35975	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
14475085	14475085	PRJNA473824_P_NODE_16092_length_297_cov_1.550000_g15454_i0	PRJNA473824	16092	297	1.55	4.6035	Calothrix sp. PCC 6303	1170562	Bacteria	Bacteria	296	1.15e-75	NTclustered	gi\|428233323\|gb\|CP003610.1\|	1170562	g15454	i0	85.512	55.6464646464646	283	41	95	0	1	283	735513	735231	Calothrix sp. PCC 6303, complete genome	blastn	16527	296	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 6303
15124347	15124347	PRJNA473824_P_NODE_32592_length_210_cov_1.352601_g31954_i0	PRJNA473824	32592	210	1.352601	2.8404621	Chroococcidiopsis	54298	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g31954	i0	99.524	109.342857142857	210	1	100	0	1	210	501	292	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	22962	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
18298775	18298775	PRJNA473824_P_NODE_73135_length_173_cov_3.727941_g72497_i0	PRJNA473824	73135	173	3.727941	6.44933793	Cyanobium gracile	59930	Bacteria	Bacteria	108	3.06e-19	NTclustered	gi\|427344508\|gb\|CP003495.1\|	292564	g72497	i0	92.105	10.5895953757225	76	6	44	0	98	173	1910536	1910461	Cyanobium gracile PCC 6307, complete genome	blastn	1832	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium gracile
18947860	18947860	PRJNA473824_P_NODE_172255_length_150_cov_0.840708_g171617_i0	PRJNA473824	172255	150	0.840708	1.261062	Chroococcidiopsis	54298	Bacteria	Bacteria	267	4.009999999999999e-67	NTclustered	gi\|485099142\|ref\|NR_102537.1\|	251229	g171617	i0	98.667	146.986666666667	150	2	100	0	1	150	213	64	Chroococcidiopsis thermalis PCC 7203 strain PCC 7203 23S ribosomal RNA, complete sequence	blastn	22048	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis thermalis
22773621	22773621	PRJNA473824_P_NODE_66418_length_173_cov_4.183824_g65780_i0	PRJNA473824	66418	173	4.183824	7.23801552	Synechococcus	1129	Bacteria	Bacteria	185	1.3699999999999999e-42	NTclustered	gi\|2045437416\|gb\|CP075523.1\|	2741953	g65780	i0	82.659	2	173	27	100	1	1	173	68267	68436	Synechococcus sp. LA31 chromosome	blastn	346	185	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. LA31

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