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

12 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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
4150273	4150273	PRJNA1196438_P_NODE_61324_length_256_cov_2.256831_g60897_i0	PRJNA1196438	61324	256	2.256831	5.77748736	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	172	1.71e-38	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g60897	i0	80.172	0.90625	232	44	90	2	24	254	643557	643327	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	232	172	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
4150593	4150593	PRJNA1196438_P_NODE_85764_length_212_cov_5.266187_g85336_i0	PRJNA1196438	85764	212	5.266187	11.16431644	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	187	4.9e-43	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g85336	i0	94.355	3.2122641509434	124	4	57	3	2	122	1207363	1207240	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	681	187	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
6700958	6700958	PRJNA1196438_P_NODE_39626_length_289_cov_2.893519_g39199_i0	PRJNA1196438	39626	289	2.893519	8.36226991	Nodosilinea sp. E11	3037479	Bacteria	Bacteria	287	6.740000000000001e-73	NTclustered	gi\|2593238647\|gb\|CP136520.1\|	3037479	g39199	i0	85.56	1.57093425605536	277	37	96	2	1	276	3688481	3688755	Nodosilinea sp. E11 chromosome	blastn	454	287	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. E11
7421377	7421377	PRJNA1196438_P_NODE_7846_length_369_cov_4.070946_g7424_i0	PRJNA1196438	7846	369	4.070946	15.02179074	Synechococcus	1129	Bacteria	Bacteria	119	3.41e-22	NTclustered	gi\|1940480550\|gb\|CP060397.1\|	1353136	g7424	i0	84	0.677506775067751	125	18	34	2	1	124	2565784	2565661	Synechococcus sp. CBW1004 chromosome, complete genome	blastn	250	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. CBW1004
7976416	7976416	PRJNA1196438_P_NODE_37907_length_292_cov_1.584475_g37480_i0	PRJNA1196438	37907	292	1.584475	4.626667	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	300	8.75e-77	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g37480	i0	85.274	2.97602739726027	292	42	100	1	1	292	4408003	4408293	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	869	300	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
14352514	14352514	PRJNA1196438_P_NODE_70072_length_247_cov_1.793103_g69645_i0	PRJNA1196438	70072	247	1.793103	4.42896441	Chroococcidiopsis sp. CCMEE 29	155894	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|2245450207\|gb\|CP083761.1\|	155894	g69645	i0	95.238	0.425101214574899	105	5	43	0	141	245	2873191	2873295	Chroococcidiopsis sp. CCMEE 29 chromosome	blastn	105	167	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 29
18174727	18174727	PRJNA1196438_P_NODE_4215_length_478_cov_4.054321_g3799_i0	PRJNA1196438	4215	478	4.054321	19.37965438	Synechococcus sp. MIT S1220	3082549	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2895575621\|gb\|CP138939.1\|	3082549	g3799	i0	100	0.0585774058577406	28	0	6	0	383	410	1840349	1840376	Synechococcus sp. MIT S1220 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. MIT S1220
18174769	18174769	PRJNA1196438_P_NODE_45715_length_280_cov_1.502415_g45288_i0	PRJNA1196438	45715	280	1.502415	4.206762	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	499	7.669999999999998e-137	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g45288	i0	98.925	105.507142857143	279	3	99	0	1	279	428	150	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	29542	499	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
20724650	20724650	PRJNA1196438_P_NODE_56357_length_263_cov_3.436842_g55930_i0	PRJNA1196438	56357	263	3.436842	9.03889446	Nostoc sp. NIES-4103	2005458	Bacteria	Bacteria	285	2.1699999999999997e-72	NTclustered	gi\|1210228378\|dbj\|AP018288.1\|	2005458	g55930	i0	86.26	5.91254752851711	262	36	99	0	1	262	7069486	7069747	Nostoc sp. NIES-4103 DNA, nearly complete genome	blastn	1555	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. NIES-4103
21445409	21445409	PRJNA1196438_P_NODE_72937_length_245_cov_0.906977_g72510_i0	PRJNA1196438	72937	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	63.9	1.02e-5	NTclustered	gi\|2080647037\|gb\|CP080598.1\|	984208	g72510	i0	91.667	27.5959183673469	48	1	32	3	96	142	826382	826427	Sphaerospermopsis torques-reginae ITEP-024 chromosome	blastn	6761	63.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Sphaerospermopsis	Sphaerospermopsis torques-reginae
24549712	24549712	PRJNA1196438_P_NODE_73600_length_244_cov_1.795322_g73173_i0	PRJNA1196438	73600	244	1.795322	4.38058568	Nostoc flagelliforme	1306274	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|1297075411\|gb\|CP024785.1\|	2038116	g73173	i0	93.004	6.22131147540984	243	14	99	1	1	243	4510004	4510243	Nostoc flagelliforme CCNUN1 chromosome, complete genome	blastn	1518	351	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc flagelliforme
24549799	24549799	PRJNA1196438_P_NODE_81220_length_231_cov_2.949367_g80793_i0	PRJNA1196438	81220	231	2.949367	6.81303777	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	115	2.6e-21	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g80793	i0	91.566	0.359307359307359	83	7	36	0	148	230	1603096	1603014	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	83	115	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium

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