metadata: contig_metadata: 10 rows where bioproject = "PRJNA1164198" and tax_clade = "Cyanobacteriota/Melainabacteria group"

10 rows where bioproject = "PRJNA1164198" 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
312051	312051	PRJNA1164198_P_NODE_7381_length_461_cov_2.904639_g7120_i0	PRJNA1164198	7381	461	2.904639	13.39038579	Cyanophyceae	3028117	Bacteria	Bacteria	228	2.8699999999999993e-74	NR	MBW4553369.1	2835086	g7120	i0	72.3	7.7114967462039	148	41	96.3	0	7	450	2	149	MBW4553369.1 nucleoside-diphosphate kinase [Aphanocapsa sp. GSE-SYN-MK-11-07L]	diamond	3555	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Aphanocapsa	Aphanocapsa sp. GSE-SYN-MK-11-07L
4867539	4867539	PRJNA1164198_P_NODE_13364_length_339_cov_1.172932_g13095_i0	PRJNA1164198	13364	339	1.172932	3.97623948	Cyanophyceae	3028117	Bacteria	Bacteria	534	2.61e-147	NTclustered	gi\|225696219\|gb\|FJ805886.1\|	259957	g13095	i0	95.266	161.312684365782	338	15	99	1	3	339	2608	2271	Uncultured Chroococcidiopsis sp. clone NA4_4 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	54685	538	0.992565055762082	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7965192	7965192	PRJNA1164198_P_NODE_18847_length_285_cov_2.547170_g18578_i0	PRJNA1164198	18847	285	2.54717	7.2594345	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	433	8.05e-117	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g18578	i0	94.035	229.961403508772	285	17	100	0	1	285	1477630	1477914	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	65539	433	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
13065515	13065515	PRJNA1164198_P_NODE_11031_length_374_cov_2.199336_g10763_i0	PRJNA1164198	11031	374	2.199336	8.22551664	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	652	0	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g10763	i0	98.128	101.393048128342	374	7	100	0	1	374	514205	513832	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	37921	652	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
13792809	13792809	PRJNA1164198_P_NODE_20811_length_272_cov_1.482412_g20542_i0	PRJNA1164198	20811	272	1.482412	4.03216064	Bacteria	2	Bacteria	Bacteria	470	5.81e-128	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g20542	i0	98.141	574.643382352941	269	5	99	0	1	269	1479307	1479575	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	156303	470	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
23264195	23264195	PRJNA1164198_P_NODE_21539_length_268_cov_1.200000_g21270_i0	PRJNA1164198	21539	268	1.2	3.216	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	254	6.27e-63	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g21270	i0	84.211	327.328358208955	266	36	98	5	1	263	1477003	1477265	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	87724	254	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
23264217	23264217	PRJNA1164198_P_NODE_25759_length_250_cov_1.322034_g25490_i0	PRJNA1164198	25759	250	1.322034	3.305085	Oscillatoria lutea	212356	Bacteria	Bacteria	435	1.92e-117	NTclustered	gi\|1345606792\|gb\|MG968526.1\|	2081949	g25490	i0	98	143.04	250	5	100	0	1	250	710	461	Oscillatoria lutea UTEX B 1814 23S ribosomal RNA gene, partial sequence	blastn	35760	435	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria lutea
28903454	28903454	PRJNA1164198_P_NODE_15048_length_319_cov_1.097561_g14779_i0	PRJNA1164198	15048	319	1.097561	3.50121959	Coleofasciculus sp. G2-EDA-02	3069529	Bacteria	Bacteria	67.4	2.18e-11	NR	MEQ9671065.1	3069529	g14779	i0	35.7	1.84326018808777	98	62	91.2	1	15	305	8	105	MEQ9671065.1 TerB family tellurite resistance protein [Coleofasciculus sp. G2-EDA-02]	diamond	588	67.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Coleofasciculus	Coleofasciculus sp. G2-EDA-02
28903462	28903462	PRJNA1164198_P_NODE_26748_length_249_cov_0.886364_g26479_i0	PRJNA1164198	26748	249	0.886364	2.20704636	Synechocystis sp. LKSZ1	3144951	Bacteria	Bacteria	42	0.0105	NR	BFM39746.1	3144951	g26479	i0	44.2	0.518072289156627	43	21	51.8	1	66	194	25	64	BFM39746.1 hypothetical protein OLK001_16720 [Synechocystis sp. LKSZ1]	diamond	129	42	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. LKSZ1
32526159	32526159	PRJNA1164198_P_NODE_18099_length_291_cov_1.284404_g17830_i0	PRJNA1164198	18099	291	1.284404	3.73761564	Nostocaceae	1162	Bacteria	Bacteria	46.6	0.00298	NR	WP_190466015.1	197653	g17830	i0	31	2.6701030927835	87	58	87.6	2	284	30	1177	1263	WP_190466015.1 GAF domain-containing protein [Anabaena azotica]	diamond	777	46.6	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena azotica

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