metadata: contig_metadata: 4 rows where bioproject = "PRJNA1241156" and tax_clade = "Cyanobacteriota/Melainabacteria group"

4 rows where bioproject = "PRJNA1241156" 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
2900551	2900551	PRJNA1241156_S_NODE_24103_length_350_cov_3.039088_g23643_i0	PRJNA1241156	24103	350	3.039088	10.636808	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	433	1.0099999999999999e-116	NTclustered	gi\|225696257\|gb\|FJ805924.1\|	259957	g23643	i0	89.045	118.314285714286	356	30	100	8	1	350	1694	2046	Uncultured Chroococcidiopsis sp. clone AS2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41410	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
6727952	6727952	PRJNA1241156_S_NODE_51806_length_271_cov_7.035088_g51346_i0	PRJNA1241156	51806	271	7.035088	19.06508848	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	294	3.74e-75	NTclustered	gi\|225696177\|gb\|FJ805844.1\|	259957	g51346	i0	86.347	160.726937269373	271	35	100	2	1	271	1777	2045	Uncultured Chroococcidiopsis sp. clone AU1_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43557	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
27705773	27705773	PRJNA1241156_S_NODE_54924_length_264_cov_4.416290_g54464_i0	PRJNA1241156	54924	264	4.41629	11.6590056	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	43.1	0.0354	NR	MEB3300926.1	2847862	g54464	i0	33	1	88	46	92	2	261	19	90	171	MEB3300926.1 DUF3370 domain-containing protein [Cyanobacteriota bacterium]	diamond	264	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
28778790	28778790	PRJNA1241156_S_NODE_35987_length_313_cov_4.748148_g35527_i0	PRJNA1241156	35987	313	4.748148	14.86170324	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	85.9	5.01e-17	NR	MCM1266179.1	2137880	g35527	i0	46.6	0.987220447284345	103	55	98.7	0	311	3	233	335	MCM1266179.1 hypothetical protein [Candidatus Gastranaerophilales bacterium]	diamond	309	85.9	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);;