metadata: contig_metadata: 6 rows where bioproject = "PRJNA751877", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

6 rows where bioproject = "PRJNA751877", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax_phylum = "Cyanobacteriota"

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
3752030	3752030	PRJNA751877_P_NODE_28983_length_242_cov_1.366864_g28861_i0	PRJNA751877	28983	242	1.366864	3.30781088	Nostocaceae	1162	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g28861	i0	100	5.26446280991736	242	0	100	0	1	242	4275044	4274803	Nostoc sp. PCC 7120 DNA, complete genome	blastn	1274	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
13954248	13954248	PRJNA751877_P_NODE_27731_length_244_cov_0.900585_g27609_i0	PRJNA751877	27731	244	0.900585	2.1974274	Nostocales	1161	Bacteria	Bacteria	390	4.11e-104	NTclustered	gi\|1373819911\|dbj\|AP018318.1\|	196308	g27609	i0	95.492	50.2295081967213	244	11	100	0	1	244	2577285	2577042	Nostoc sp. HK-01 DNA, complete genome	blastn	12256	390	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. HK-01
19051917	19051917	PRJNA751877_P_NODE_21935_length_252_cov_1.720670_g21813_i0	PRJNA751877	21935	252	1.72067	4.3360884	Nostocaceae	1162	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|47118302\|dbj\|BA000019.2\|	103690	g21813	i0	100	5	252	0	100	0	1	252	4275074	4275325	Nostoc sp. PCC 7120 DNA, complete genome	blastn	1260	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. PCC 7120 = FACHB-418
27157183	27157183	PRJNA751877_P_NODE_29282_length_242_cov_0.911243_g29160_i0	PRJNA751877	29282	242	0.911243	2.20520806	Bacteria	2	Bacteria	Bacteria	108	1.65e-27	NR	WP_015166226.1	82654	g29160	i0	61.3	19.5371900826446	75	29	93	0	18	242	3	77	WP_015166226.1 peroxiredoxin [Pseudanabaena sp. PCC 7367]	diamond	4728	109	0.990825688073395	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
29105597	29105597	PRJNA751877_P_NODE_16888_length_285_cov_1.089623_g16766_i0	PRJNA751877	16888	285	1.089623	3.10542555	Pseudanabaena sp. SR411	1980935	Bacteria	Bacteria	69.7	8.29e-12	NR	WP_094530082.1	1980935	g16766	i0	49.3	0.789473684210526	75	37	77.9	1	222	1	1	75	WP_094530082.1 hypothetical protein [Pseudanabaena sp. SR411]	diamond	225	69.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae	Pseudanabaena	Pseudanabaena sp. SR411
32329373	32329373	PRJNA751877_P_NODE_26099_length_246_cov_0.890173_g25977_i0	PRJNA751877	26099	246	0.890173	2.18982558	Cyanobacteria bacterium P01_A01_bin.37	3023248	Bacteria	Bacteria	86.3	1.46e-17	NR	MEM7770880.1	3023248	g25977	i0	48.8	1	82	42	100	0	246	1	71	152	MEM7770880.1 ISKra4 family transposase [Cyanobacteria bacterium P01_A01_bin.37]	diamond	246	86.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					Cyanobacteria bacterium P01_A01_bin.37

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