metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA283169" and tax_clade = "Cyanobacteriota/Melainabacteria group"

12 rows where analysis = "diamond", bioproject = "PRJNA283169" 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
27010745	27010745	PRJNA283169_P_NODE_8102_length_162_cov_0.911504_g8039_i0	PRJNA283169	8102	162	0.911504	1.47663648	Vampirovibrionales bacterium	2692181	Bacteria	Bacteria	104	2.5699999999999997e-24	NR	MEB3244940.1	2692181	g8039	i0	88.9	5	54	6	100	0	162	1	283	336	MEB3244940.1 DNA topoisomerase (ATP-hydrolyzing) subunit B [Vampirovibrionales bacterium]	diamond	810	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Vampirovibrionales			Vampirovibrionales bacterium
28400585	28400585	PRJNA283169_P_NODE_3886_length_212_cov_1.245399_g3823_i0	PRJNA283169	3886	212	1.245399	2.64024588	Chroococcales cyanobacterium	3088180	Bacteria	Bacteria	42.4	0.0346	NR	HEY9712213.1	3088180	g3823	i0	49.1	0.806603773584906	57	25	80.7	2	14	184	657	709	HEY9712213.1 fibronectin type III domain-containing protein [Chroococcales cyanobacterium]	diamond	171	42.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales			Chroococcales cyanobacterium
28481397	28481397	PRJNA283169_P_NODE_6406_length_169_cov_1.300000_g6343_i0	PRJNA283169	6406	169	1.3	2.197	Acaryochloris	155977	Bacteria	Bacteria	42.7	0.0036	NR	PZD74015.1	1764569	g6343	i0	43.6	1.95266272189349	55	29	94.1	2	162	4	35	89	PZD74015.1 hypothetical protein C1752_01762 [Acaryochloris thomasi RCC1774]	diamond	330	42.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Acaryochloridaceae	Acaryochloris	Acaryochloris thomasi
29000832	29000832	PRJNA283169_P_NODE_5828_length_177_cov_1.625000_g5765_i0	PRJNA283169	5828	177	1.625	2.87625	Cyanobacteria bacterium J149	2420335	Bacteria	Bacteria	43.5	0.00432	NR	RMD72956.1	2420335	g5765	i0	70.4	0.457627118644068	27	8	45.8	0	95	175	3	29	RMD72956.1 MAG: hypothetical protein D6822_00435, partial [Cyanobacteria bacterium J149]	diamond	81	43.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium J149
29239234	29239234	PRJNA283169_P_NODE_6249_length_171_cov_1.745902_g6186_i0	PRJNA283169	6249	171	1.745902	2.98549242	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	57	1.28e-7	NR	MFN7464261.1	1153	g6186	i0	48.1	1.89473684210526	54	28	94.7	0	5	166	290	343	MFN7464261.1 phage terminase large subunit [Pseudanabaena sp.]	diamond	324	57	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
29442250	29442250	PRJNA283169_S_NODE_2890_length_171_cov_0.139344_g2876_i0	PRJNA283169	2890	171	0.139344	0.23827824	Candidatus Margulisiibacteriota bacterium	2053573	Bacteria	Bacteria	55.8	3.43e-7	NR	MSR88993.1	2053573	g2876	i0	69.4	0.631578947368421	36	11	63.2	0	64	171	270	305	MSR88993.1 DUF229 domain-containing protein [Candidatus Margulisiibacteriota bacterium]	diamond	108	55.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Margulisiibacteriota					Candidatus Margulisiibacteriota bacterium
29979343	29979343	PRJNA283169_S_NODE_2491_length_182_cov_0.060150_g2477_i0	PRJNA283169	2491	182	0.06015	0.109473	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	108	7.69e-26	NR	MDD9898265.1	2052166	g2477	i0	85	0.989010989010989	60	9	98.9	0	182	3	481	540	MDD9898265.1 ribonucleoside-diphosphate reductase subunit alpha [Candidatus Melainabacteria bacterium]	diamond	180	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
31147936	31147936	PRJNA283169_P_NODE_2835_length_246_cov_2.091371_g2772_i0	PRJNA283169	2835	246	2.091371	5.14477266	Trichocoleus desertorum	1481672	Bacteria	Bacteria	53.5	4.98e-6	NR	MBW4487535.1	1382647	g2772	i0	43.8	0.780487804878049	64	31	75.6	2	239	54	160	220	MBW4487535.1 methyltransferase, TIGR04325 family [Trichocoleus desertorum ATA4-8-CV12]	diamond	192	53.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Trichocoleusaceae	Trichocoleus	Trichocoleus desertorum
31717633	31717633	PRJNA283169_P_NODE_737_length_447_cov_1.565327_g675_i0	PRJNA283169	737	447	1.565327	6.99701169	Microcystis sp. M	1127	Bacteria	Bacteria	108	4.68e-24	NR	WP_287729196.1	2771171	g675	i0	41.7	0.932885906040268	139	78	93.3	1	420	4	7	142	WP_287729196.1 hypothetical protein [Microcystis sp. M061S2]	diamond	417	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis sp. M061S2
32065556	32065556	PRJNA283169_P_NODE_8198_length_162_cov_0.876106_g8135_i0	PRJNA283169	8198	162	0.876106	1.41929172	Planktothrix agardhii	1160	Bacteria	Bacteria	48.9	7.77e-5	NR	WP_071782872.1	1160	g8135	i0	52.5	0.740740740740741	40	19	74.1	0	5	124	184	223	WP_071782872.1 glycoside hydrolase family protein [Planktothrix agardhii]	diamond	120	48.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Planktothrix	Planktothrix agardhii
32209910	32209910	PRJNA283169_P_NODE_6958_length_166_cov_1.230769_g6895_i0	PRJNA283169	6958	166	1.230769	2.04307654	Symploca	105591	Bacteria	Bacteria	60.5	1.37e-9	NR	HBL58647.1	2055779	g6895	i0	41.3	7.69879518072289	63	29	99.4	2	166	2	21	83	HBL58647.1 hypothetical protein [Cyanobacteria bacterium UBA8803]	diamond	1278	60.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium UBA8803
32792052	32792052	PRJNA283169_P_NODE_7080_length_166_cov_0.880342_g7017_i0	PRJNA283169	7080	166	0.880342	1.46136772	Synechococcus lacustris	2116544	Bacteria	Bacteria	110	3.53e-29	NR	WP_353078761.1	2116544	g7017	i0	92.7	0.993975903614458	55	4	99.4	0	2	166	73	127	WP_353078761.1 hypothetical protein [Synechococcus lacustris]	diamond	165	110	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus lacustris

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