metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA771359" and tax_kingdom = "Bacillati"

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
27021690	27021690	PRJNA771359_S_NODE_3022_length_193_cov_2.000000_g2939_i0	PRJNA771359	3022	193	2	3.86	Nostoc sp. CCY 9925	3103865	Bacteria	Bacteria	60.1	1.19e-9	NR	WP_414570021.1	3103865	g2939	i0	91.7	2.23834196891192	36	3	56	0	84	191	1	36	WP_414570021.1 hypothetical protein [Nostoc sp. CCY 9925]	diamond	432	60.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. CCY 9925
28042075	28042075	PRJNA771359_S_NODE_4325_length_163_cov_1.198413_g4242_i0	PRJNA771359	4325	163	1.198413	1.95341319	Bacillota	1239	Bacteria	Bacteria	52	6.98e-6	NR	WP_073338434.1	40575	g4242	i0	46.8	10.0122699386503	47	25	86.5	0	142	2	1215	1261	WP_073338434.1 SdrD B-like domain-containing protein [Clostridium grantii]	diamond	1632	52.4	0.99236641221374	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium grantii
28284790	28284790	PRJNA771359_S_NODE_1986_length_235_cov_4.661616_g1903_i0	PRJNA771359	1986	235	4.661616	10.9547976	Cyanobacteria bacterium UBA11371	2055770	Bacteria	Bacteria	48.9	5.1e-5	NR	HAZ48354.1	2055770	g1903	i0	75	0.408510638297872	32	8	40.9	0	124	219	9	40	HAZ48354.1 hypothetical protein [Cyanobacteria bacterium UBA11371]	diamond	96	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA11371
28421072	28421072	PRJNA771359_S_NODE_4586_length_159_cov_0.950820_g4503_i0	PRJNA771359	4586	159	0.95082	1.5118038	Nostoc	1177	Bacteria	Bacteria	77.8	2.84e-17	NR	WP_251955932.1	1178	g4503	i0	85	4.52830188679245	40	6	75.5	0	158	39	38	77	WP_251955932.1 Nif11-like leader peptide family natural product precursor [Nostoc commune]	diamond	720	77.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc commune
29074575	29074575	PRJNA771359_S_NODE_4668_length_157_cov_11.716667_g4585_i0	PRJNA771359	4668	157	11.716667	18.39516719	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	45.4	1.84e-4	NR	MBX9694480.1	2847862	g4585	i0	80.8	0.496815286624204	26	5	49.7	0	75	152	3	28	MBX9694480.1 hypothetical protein [Cyanobacteriota bacterium]	diamond	78	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
29705429	29705429	PRJNA771359_S_NODE_4070_length_167_cov_2.100000_g3987_i0	PRJNA771359	4070	167	2.1	3.507	Nostoc	1177	Bacteria	Bacteria	92	5.929999999999999e-23	NR	WP_099067786.1	1177	g3987	i0	100	0.790419161676647	44	0	79	0	1	132	26	69	WP_099067786.1 MULTISPECIES: photosystem II assembly protein Psb35 [Nostoc]	diamond	132	92	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc
30369718	30369718	PRJNA771359_S_NODE_5152_length_151_cov_1.973684_g5069_i0	PRJNA771359	5152	151	1.973684	2.98026284	Pseudanabaena sp. PCC 68	1153	Bacteria	Bacteria	113	1.9299999999999995e-31	NR	WP_036947030.1	118173	g5069	i0	100	0.973509933774834	49	0	97.4	0	150	4	21	69	WP_036947030.1 hypothetical protein [Pseudanabaena sp. PCC 6802]	diamond	147	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. PCC 6802
31421680	31421680	PRJNA771359_S_NODE_4196_length_165_cov_1.515625_g4113_i0	PRJNA771359	4196	165	1.515625	2.50078125	Bacillati	1783272	Bacteria	Bacteria	112	2.0800000000000004e-27	NR	WP_304716840.1	1280	g4113	i0	100	1.96363636363636	54	0	98.2	0	2	163	370	423	WP_304716840.1 DUF3526 domain-containing protein, partial [Staphylococcus aureus]	diamond	324	112	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
32139778	32139778	PRJNA771359_S_NODE_3218_length_187_cov_2.186667_g3135_i0	PRJNA771359	3218	187	2.186667	4.08906729	Cyanobacteria bacterium CRU_2_1	2720403	Bacteria	Bacteria	81.3	1e-18	NR	NJR63772.1	2720403	g3135	i0	90.9	0.705882352941177	44	4	70.6	0	3	134	12	55	NJR63772.1 ssl1498 family light-harvesting-like protein [Cyanobacteria bacterium CRU_2_1]	diamond	132	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium CRU_2_1
32266498	32266498	PRJNA771359_S_NODE_3318_length_184_cov_2.074830_g3235_i0	PRJNA771359	3318	184	2.07483	3.8176872	Clostridium sp. BSD278	1506	Bacteria	Bacteria	45.4	0.00197	NR	WP_207736696.1	2787146	g3235	i0	45.3	1.22282608695652	75	24	96.2	4	2	178	3243	3316	WP_207736696.1 SpaA isopeptide-forming pilin-related protein [Clostridium sp. BSD2780061688b_171218_E8]	diamond	225	45.4	1	Bacteria		Bacillati	Bacillota	Clostridia	Eubacteriales	Clostridiaceae	Clostridium	Clostridium sp. BSD2780061688b_171218_E8
32560841	32560841	PRJNA771359_S_NODE_3059_length_192_cov_1.761290_g2976_i0	PRJNA771359	3059	192	1.76129	3.3816768	Bacteria	2	Bacteria	Bacteria	42.4	0.0179	NR	WP_370287739.1	35761	g2976	i0	40	2.578125	55	30	85.9	1	5	169	3	54	WP_370287739.1 hypothetical protein [Nocardioides sp.]	diamond	495	42.4	1	Bacteria		Bacillati	Actinomycetota	Actinomycetes	Propionibacteriales	Nocardioidaceae	Nocardioides	Nocardioides sp.

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