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

7 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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
1588945	1588945	PRJNA1167252_P_NODE_14722_length_320_cov_1.858300_g14449_i0	PRJNA1167252	14722	320	1.8583	5.94656	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	592	1.4299999999999996e-164	NTclustered	gi\|428249989\|gb\|CP003630.1\|	1173027	g14449	i0	100	149.740625	320	0	100	0	1	320	2624733	2624414	Allocoleopsis franciscana PCC 7113, complete genome	blastn	47917	592	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4141182	4141182	PRJNA1167252_P_NODE_16244_length_304_cov_1.350649_g15971_i0	PRJNA1167252	16244	304	1.350649	4.10597296	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	512	1.08e-140	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g15971	i0	97.039	251.276315789474	304	9	100	0	1	304	1859020	1859323	Calothrix sp. PCC 7716 DNA, complete genome	blastn	76388	512	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
9242557	9242557	PRJNA1167252_P_NODE_26628_length_247_cov_0.896552_g26355_i0	PRJNA1167252	26628	247	0.896552	2.21448344	Calothrix parietina	32054	Bacteria	Bacteria	414	2.47e-111	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g26355	i0	96.761	233.898785425101	247	8	100	0	1	247	632	386	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	57773	414	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
9242759	9242759	PRJNA1167252_P_NODE_6848_length_497_cov_1.141509_g6575_i0	PRJNA1167252	6848	497	1.141509	5.67329973	Oculatella lusitanica	2928764	Bacteria	Bacteria	754	0	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g6575	i0	94.845	130.613682092555	485	22	97	3	15	497	3237	2754	Oculatella lusitanica LEGE 161147 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	64915	754	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
18166034	18166034	PRJNA1167252_P_NODE_19055_length_279_cov_2.135922_g18782_i0	PRJNA1167252	19055	279	2.135922	5.95922238	Pycnacronema caatingensis	2785931	Bacteria	Bacteria	398	2.8599999999999996e-106	NTclustered	gi\|2547515306\|gb\|OR288164.1\|	3062397	g18782	i0	92.473	185.924731182796	279	19	99	2	1	278	1909	2186	Pycnacronema caatingensis Mel-10-33-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	51873	398	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Pycnacronema	Pycnacronema caatingensis
18166189	18166189	PRJNA1167252_P_NODE_24435_length_250_cov_0.881356_g24162_i0	PRJNA1167252	24435	250	0.881356	2.20339	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	171	5.99e-38	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g24162	i0	86.25	0.64	160	19	63	3	1	158	29380	29538	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	160	171	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
25266223	25266223	PRJNA1167252_P_NODE_21020_length_264_cov_1.633508_g20747_i0	PRJNA1167252	21020	264	1.633508	4.31246112	Microcoleus	44471	Bacteria	Bacteria	488	1.5499999999999999e-133	NTclustered	gi\|2212798032\|gb\|CP031740.1\|	669365	g20747	i0	100	194.723484848485	264	0	100	0	1	264	100708	100971	Microcoleus vaginatus PCC 9802 chromosome, complete genome	blastn	51407	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Microcoleus	Microcoleus vaginatus

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