metadata: contig_metadata: 11 rows where bioproject = "PRJEB43370" and tax_clade = "Cyanobacteriota/Melainabacteria group"

11 rows where bioproject = "PRJEB43370" 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
2610175	2610175	PRJEB43370_P_NODE_9203_length_165_cov_1.465517_g9160_i0	PRJEB43370	9203	165	1.465517	2.41810305	Stanieria sp. NIES-3757	1807358	Bacteria	Bacteria	95.3	2.26e-15	NTclustered	gi\|1003382826\|dbj\|AP017375.1\|	1807358	g9160	i0	87.654	0.490909090909091	81	10	49	0	5	85	2190362	2190442	Stanieria sp. NIES-3757 DNA, complete genome	blastn	81	95.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. NIES-3757
26653326	26653326	PRJEB43370_P_NODE_4181_length_218_cov_0.923077_g4138_i0	PRJEB43370	4181	218	0.923077	2.01230786	Nostoc sp. UHCC	1180	Bacteria	Bacteria	56.2	4.73e-7	NR	QSJ14844.1	2814655	g4138	i0	46.2	1.78899082568807	65	33	89.4	1	195	1	857	919	QSJ14844.1 FAD-binding protein [Nostoc sp. UHCC 0702]	diamond	390	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. UHCC 0702
28044197	28044197	PRJEB43370_P_NODE_6385_length_182_cov_1.172932_g6342_i0	PRJEB43370	6385	182	1.172932	2.13473624	Synechococcales cyanobacterium	2478492	Bacteria	Bacteria	81.3	1.45e-16	NR	MEB3294576.1	2478492	g6342	i0	60	0.989010989010989	60	24	98.9	0	3	182	98	157	MEB3294576.1 S-methyl-5'-thioadenosine phosphorylase [Synechococcales cyanobacterium]	diamond	180	81.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales			Synechococcales cyanobacterium
28132405	28132405	PRJEB43370_P_NODE_9845_length_164_cov_0.904348_g9802_i0	PRJEB43370	9845	164	0.904348	1.48313072	Bacillati	1783272	Bacteria	Bacteria	57.4	8.57e-8	NR	WP_011320615.1	1162	g9802	i0	49	4.31707317073171	49	25	89.6	0	6	152	249	297	WP_011320615.1 MULTISPECIES: cytochrome P450 [Nostocaceae]	diamond	708	57.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae
28960096	28960096	PRJEB43370_P_NODE_5948_length_187_cov_1.884058_g5905_i0	PRJEB43370	5948	187	1.884058	3.52318846	Potamolinea sp.	3100419	Bacteria	Bacteria	48.5	1.58e-4	NR	MFB8788235.1	3100419	g5905	i0	53.3	0.962566844919786	60	28	96.3	0	182	3	749	808	MFB8788235.1 colicin uptake protein [Potamolinea sp.]	diamond	180	48.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Wilmottiaceae	Potamolinea	Potamolinea sp.
30033581	30033581	PRJEB43370_P_NODE_10951_length_162_cov_0.920354_g10908_i0	PRJEB43370	10951	162	0.920354	1.49097348	Cyanobacteria bacterium P01_D01_bin.105	3023268	Bacteria	Bacteria	52.4	4.71e-6	NR	MEM6453342.1	3023268	g10908	i0	49.1	2.05555555555556	55	20	87	1	20	160	74	128	MEM6453342.1 GAF domain-containing protein [Cyanobacteria bacterium P01_D01_bin.105]	diamond	333	52.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_D01_bin.105
30096533	30096533	PRJEB43370_P_NODE_3492_length_234_cov_2.075676_g3449_i0	PRJEB43370	3492	234	2.075676	4.85708184	unclassified Roseofilum	2620099	Bacteria	Bacteria	92.8	8.92e-21	NR	WP_318719907.1	2620099	g3449	i0	65.2	0.884615384615385	69	24	88.5	0	223	17	1	69	WP_318719907.1 MULTISPECIES: phytoene/squalene synthase family protein [unclassified Roseofilum]	diamond	207	92.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Desertifilales	Desertifilaceae	Roseofilum
31543866	31543866	PRJEB43370_P_NODE_6696_length_177_cov_1.625000_g6653_i0	PRJEB43370	6696	177	1.625	2.87625	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	45.4	0.00172	NR	PZU95061.1	1153	g6653	i0	43.4	5.47457627118644	53	30	89.8	0	3	161	1408	1460	PZU95061.1 MAG: hypothetical protein DCE90_13265 [Pseudanabaena sp.]	diamond	969	45.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp.
31670231	31670231	PRJEB43370_P_NODE_2337_length_282_cov_1.785408_g2294_i0	PRJEB43370	2337	282	1.785408	5.03485056	Cyanophyceae	3028117	Bacteria	Bacteria	146	1.0899999999999997e-42	NR	WP_224410038.1	331517	g2294	i0	70.2	11	94	28	100	0	1	282	55	148	WP_224410038.1 nucleoside-diphosphate kinase [Oscillatoria salina]	diamond	3102	146	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Oscillatoriaceae	Oscillatoria	Oscillatoria salina
31834917	31834917	PRJEB43370_P_NODE_10637_length_162_cov_0.920354_g10594_i0	PRJEB43370	10637	162	0.920354	1.49097348	Cyanobacteriota bacterium	2847862	Bacteria	Bacteria	47.8	1.96e-4	NR	MBY0404933.1	2847862	g10594	i0	44	1.88888888888889	50	28	92.6	0	160	11	107	156	MBY0404933.1 DUF3050 domain-containing protein [Cyanobacteriota bacterium]	diamond	306	47.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteriota bacterium
32839453	32839453	PRJEB43370_P_NODE_10580_length_162_cov_1.681416_g10537_i0	PRJEB43370	10580	162	1.681416	2.72389392	Bacteria	2	Bacteria	Bacteria	82	1.72e-16	NR	WP_007353156.1	1501433	g10537	i0	70.8	3.61111111111111	48	14	88.9	0	145	2	531	578	WP_007353156.1 MULTISPECIES: FAD-binding protein [Kamptonema]	diamond	585	82	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Kamptonema

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