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

10 rows where bioproject = "PRJEB12366" 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
1295028	1295028	PRJEB12366_S_NODE_182_length_330_cov_17.261017_g174_i0	PRJEB12366	182	330	17.261017	56.9613561	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	366	9.77e-97	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g174	i0	87.821	46.3181818181818	312	38	95	0	10	321	3680021	3679710	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	15285	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
6398944	6398944	PRJEB12366_S_NODE_4066_length_153_cov_11.991525_g4058_i0	PRJEB12366	4066	153	11.991525	18.34703325	Aliterella chasmolithica	2739056	Bacteria	Bacteria	255	8.900000000000001e-64	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g4058	i0	96.732	126.803921568627	153	5	100	0	1	153	2119	1967	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	19401	255	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
10223574	10223574	PRJEB12366_S_NODE_229_length_310_cov_20.170909_g221_i0	PRJEB12366	229	310	20.170909	62.5298179	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	348	3.3e-91	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g221	i0	87.879	43.0161290322581	297	35	95	1	6	301	3679725	3680021	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13335	348	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
11498838	11498838	PRJEB12366_S_NODE_30_length_599_cov_85.737589_g25_i0	PRJEB12366	30	599	85.737589	513.56815811	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	612	2.17e-170	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g25	i0	86.98	81.0267111853089	553	60	91	11	28	574	3682681	3682135	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	48535	612	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
16597540	16597540	PRJEB12366_P_NODE_12994_length_202_cov_1.089820_g12804_i0	PRJEB12366	12994	202	1.08982	2.2014364	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	309	9.45e-80	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g12804	i0	94.5	136.138613861386	200	11	99	0	3	202	3205	3006	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27500	309	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16597545	16597545	PRJEB12366_P_NODE_13754_length_194_cov_1.509434_g13564_i0	PRJEB12366	13754	194	1.509434	2.92830196	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	318	1.5e-82	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g13564	i0	96.373	202.618556701031	193	7	99	0	2	194	1783	1591	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	39308	318	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
19146318	19146318	PRJEB12366_S_NODE_2556_length_171_cov_2.316176_g2548_i0	PRJEB12366	2556	171	2.316176	3.96066096	Chroococcidiopsis sp. CCMEE 010	2941234	Bacteria	Bacteria	211	2.23e-50	NTclustered	gi\|2594665719\|gb\|OR413562.1\|	2941234	g2548	i0	92.053	37.8245614035088	151	11	88	1	1	150	2490	2340	Chroococcidiopsis sp. CCMEE 010 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile (trnI) and tRNA-Ala (trnA) genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	6468	211	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	Chroococcidiopsis sp. CCMEE 010
22972798	22972798	PRJEB12366_S_NODE_39_length_545_cov_10.533333_g32_i0	PRJEB12366	39	545	10.533333	57.40666485	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	555	3.349999999999999e-153	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g32	i0	85.688	282.743119266055	538	64	98	11	11	542	3680690	3681220	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	154095	555	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
24246599	24246599	PRJEB12366_P_NODE_6640_length_311_cov_3.173913_g6450_i0	PRJEB12366	6640	311	3.173913	9.87086943	Annamia dubia	2815909	Bacteria	Bacteria	104	7.91e-18	NTclustered	gi\|2663421582\|dbj\|AP025630.1\|	2759045	g6450	i0	76.699	7.5016077170418	206	36	64	10	4	203	2054606	2054805	Annamia dubia NIES-4383 DNA, complete genome	blastn	2333	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Annamia	Annamia dubia
29938344	29938344	PRJEB12366_P_NODE_13911_length_193_cov_1.012658_g13721_i0	PRJEB12366	13911	193	1.012658	1.95442994	Planktothrix sp. FACHB-1355	2692854	Bacteria	Bacteria	114	1.4e-31	NR	WP_191055919.1	2692854	g13721	i0	84.2	1.78756476683938	57	9	88.6	0	2	172	15	71	WP_191055919.1 MbtH family protein [Planktothrix sp. FACHB-1355]	diamond	345	114	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix sp. FACHB-1355

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