metadata: contig_metadata: 16 rows where bioproject = "PRJNA454503" and tax_clade = "Cyanobacteriota/Melainabacteria group"

16 rows where bioproject = "PRJNA454503" 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
8095422	8095422	PRJNA454503_P_NODE_32147_length_236_cov_2.611429_g31818_i0	PRJNA454503	32147	236	2.6114289999999998	6.16297244	Albertania skiophila	2109500	Bacteria	Bacteria	342	1.12e-89	NTclustered	gi\|1356054890\|gb\|MH030274.1\|	2109501	g31818	i0	92.797	207.016949152542	236	17	100	0	1	236	2187	1952	Albertania skiophila str. SA373 Zammit 2014 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	48856	342	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Albertania	Albertania skiophila
10646877	10646877	PRJNA454503_P_NODE_90549_length_172_cov_4.513514_g90220_i0	PRJNA454503	90549	172	4.513514	7.76324408	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	292	7.81e-75	NTclustered	gi\|225696240\|gb\|FJ805907.1\|	259957	g90220	i0	97.647	162.273255813953	170	4	99	0	1	170	3227	3396	Uncultured Chroococcidiopsis sp. clone NA3_10 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27911	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
17019275	17019275	PRJNA454503_P_NODE_10394_length_347_cov_4.146853_g10065_i0	PRJNA454503	10394	347	4.146853	14.38957991	Oculatella lusitanica	2928764	Bacteria	Bacteria	479	1.2699999999999996e-130	NTclustered	gi\|1793889078\|gb\|MN061918.1\|	2692086	g10065	i0	91.667	157.518731988473	348	25	100	2	1	347	3522	3178	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	54659	479	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella lusitanica
17671316	17671316	PRJNA454503_P_NODE_41814_length_225_cov_0.865854_g41485_i0	PRJNA454503	41814	225	0.865854	1.9481715	root	1	Root_unresolved	Root_unresolved	416	6.159999999999998e-112	NTclustered	gi\|326205832\|gb\|HQ827452.1\|	1211	g41485	i0	100	99.6444444444444	225	0	100	0	1	225	386	162	Uncultured cyanobacterium clone ciam16_P2R2F11 16S ribosomal RNA gene, partial sequence	blastn	22420	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
22770934	22770934	PRJNA454503_P_NODE_89398_length_191_cov_2.223077_g89069_i0	PRJNA454503	89398	191	2.223077	4.24607707	Oculatella	1240886	Bacteria	Bacteria	294	2.47e-75	NTclustered	gi\|1300933890\|gb\|MG652620.1\|	1963209	g89069	i0	94.709	146.099476439791	189	10	99	0	2	190	2223	2411	Oculatella ucrainica KZ-5-4-1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27905	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Oculatella	Oculatella ucrainica
26632977	26632977	PRJNA454503_P_NODE_66941_length_207_cov_1.780822_g66612_i0	PRJNA454503	66941	207	1.780822	3.68630154	Candidatus Synechococcus spongiarum 142	1608213	Bacteria	Bacteria	40.8	0.0324	NR	KKZ15259.1	1608213	g66612	i0	41.2	0.985507246376812	68	22	72.5	2	34	183	17	84	KKZ15259.1 MAG: hypothetical protein TH68_01305 [Candidatus Synechococcus spongiarum 142]	diamond	204	40.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Candidatus Synechococcus spongiarum
26664329	26664329	PRJNA454503_P_NODE_72541_length_206_cov_0.896552_g72212_i0	PRJNA454503	72541	206	0.896552	1.84689712	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	58.2	6.31e-9	NR	MCC6977383.1	2052166	g72212	i0	66.1	0.815533980582524	56	18	80.1	1	166	2	1	56	MCC6977383.1 hypothetical protein [Candidatus Melainabacteria bacterium]	diamond	168	58.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26696185	26696185	PRJNA454503_P_NODE_54821_length_211_cov_0.866667_g54492_i0	PRJNA454503	54821	211	0.866667	1.82866737	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	65.1	2.9e-10	NR	HNB23727.1	2052166	g54492	i0	67.3	0.696682464454976	49	16	69.7	0	62	208	7	55	HNB23727.1 serine/threonine-protein kinase [Candidatus Melainabacteria bacterium]	diamond	147	65.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
26934126	26934126	PRJNA454503_P_NODE_68062_length_207_cov_0.890411_g67733_i0	PRJNA454503	68062	207	0.890411	1.84315077	Bacillati	1783272	Bacteria	Bacteria	119	5.9400000000000005e-33	NR	MBW4459677.1	1602008	g67733	i0	76.8	5	69	16	100	0	1	207	14	82	MBW4459677.1 nuclear transport factor 2 family protein [Nodosilinea sp. WJT8-NPBG4]	diamond	1035	119	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. WJT8-NPBG4
27834163	27834163	PRJNA454503_P_NODE_63244_length_208_cov_2.353741_g62915_i0	PRJNA454503	63244	208	2.353741	4.89578128	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	136	2.24e-35	NR	PZM77956.1	2052166	g62915	i0	97.1	0.995192307692308	69	2	99.5	0	207	1	4000	4068	PZM77956.1 MAG: hypothetical protein DKT66_27160 [Candidatus Melainabacteria bacterium]	diamond	207	136	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27865692	27865692	PRJNA454503_P_NODE_50305_length_215_cov_1.688312_g49976_i0	PRJNA454503	50305	215	1.688312	3.6298708	Coleofasciculaceae cyanobacterium	3081323	Bacteria	Bacteria	142	1.4e-38	NR	HEY9771584.1	3081323	g49976	i0	97.2	0.990697674418605	71	2	99.1	0	213	1	227	297	HEY9771584.1 sodium/proline symporter [Coleofasciculaceae cyanobacterium]	diamond	213	142	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae		Coleofasciculaceae cyanobacterium
28623793	28623793	PRJNA454503_P_NODE_47107_length_218_cov_2.923567_g46778_i0	PRJNA454503	47107	218	2.923567	6.37337606	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	143	5.299999999999999e-38	NR	PZM81424.1	2052166	g46778	i0	95.8	0.990825688073395	72	3	99.1	0	216	1	195	266	PZM81424.1 MAG: hypothetical protein DKT66_19630 [Candidatus Melainabacteria bacterium]	diamond	216	143	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
29223693	29223693	PRJNA454503_P_NODE_63249_length_208_cov_2.340136_g62920_i0	PRJNA454503	63249	208	2.340136	4.86748288	Synechococcus sp. R60.3	2967123	Bacteria	Bacteria	70.1	6.71e-14	NR	MFS8799176.1	2967123	g62920	i0	67.3	0.706730769230769	49	16	70.7	0	55	201	27	75	MFS8799176.1 hypothetical protein [Synechococcus sp. R60.3]	diamond	147	70.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. R60.3
31972719	31972719	PRJNA454503_P_NODE_32678_length_236_cov_1.291429_g32349_i0	PRJNA454503	32678	236	1.291429	3.04777244	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	140	1.23e-37	NR	PZM82883.1	2052166	g32349	i0	92.3	0.991525423728814	78	6	99.2	0	235	2	255	332	PZM82883.1 MAG: hypothetical protein DKT66_12915 [Candidatus Melainabacteria bacterium]	diamond	234	140	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32067553	32067553	PRJNA454503_P_NODE_39078_length_228_cov_1.329341_g38749_i0	PRJNA454503	39078	228	1.329341	3.03089748	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	78.2	9.7e-15	NR	MBC7999982.1	2052166	g38749	i0	85.7	1.13157894736842	42	6	55.3	0	102	227	438	479	MBC7999982.1 PAS domain S-box protein [Candidatus Melainabacteria bacterium]	diamond	258	78.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
32067558	32067558	PRJNA454503_P_NODE_85798_length_202_cov_0.921986_g85469_i0	PRJNA454503	85798	202	0.921986	1.86241172	Candidatus Gastranaerophilales bacterium HUM_9	1916320	Bacteria	Bacteria	124	1.47e-31	NR	DAA96876.1	1916320	g85469	i0	89.6	0.995049504950495	67	7	99.5	0	2	202	103	169	DAA96876.1 MAG TPA: hypothetical protein CPT80_03445 [Candidatus Gastranaerophilales bacterium HUM_9]	diamond	201	124	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium HUM_9

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