metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_clade = "Cyanobacteriota/Melainabacteria group"

9 rows where analysis = "blastn", bioproject = "PRJNA902848" 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
3798960	3798960	PRJNA902848_P_NODE_14123_length_251_cov_1.365169_g14073_i0	PRJNA902848	14123	251	1.365169	3.42657419	Aliterella	1827277	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|321140180\|gb\|GQ325743.1\|	1211	g14073	i0	100	99.99203187251	251	0	100	0	1	251	409	659	Uncultured cyanobacterium clone SP1_1B_34 16S ribosomal RNA gene, partial sequence	blastn	25098	464	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
4710417	4710417	PRJNA902848_P_NODE_11444_length_269_cov_0.892857_g11394_i0	PRJNA902848	11444	269	0.892857	2.40178533	Allocoleopsis franciscana	2886352	Bacteria	Bacteria	462	9.61e-126	NTclustered	gi\|485099150\|ref\|NR_102545.1\|	1173027	g11394	i0	98.842	156.174721189591	259	3	96	0	1	259	1779	1521	Microcoleus sp. PCC 7113 strain PCC 7113 23S ribosomal RNA, complete sequence	blastn	42011	462	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Coleofasciculales	Coleofasciculaceae	Allocoleopsis	Allocoleopsis franciscana
4710632	4710632	PRJNA902848_P_NODE_2084_length_512_cov_2.079727_g2035_i0	PRJNA902848	2084	512	2.079727	10.64820224	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	643	6.499999999999998e-180	NTclustered	gi\|225696183\|gb\|FJ805850.1\|	259957	g2035	i0	89.341	128.396484375	516	49	100	6	1	512	2747	3260	Uncultured Chroococcidiopsis sp. clone AR1_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	65739	643	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7259974	7259974	PRJNA902848_P_NODE_13566_length_252_cov_0.871508_g13516_i0	PRJNA902848	13566	252	0.871508	2.19620016	Anabaena cylindrica	1165	Bacteria	Bacteria	427	3.2499999999999993e-115	NTclustered	gi\|1210081632\|dbj\|AP018166.1\|	272123	g13516	i0	97.222	9.46825396825397	252	7	100	0	1	252	1699590	1699339	Anabaena cylindrica PCC 7122 DNA, nearly complete genome	blastn	2386	427	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Anabaena	Anabaena cylindrica
10175700	10175700	PRJNA902848_P_NODE_7408_length_321_cov_1.883065_g7358_i0	PRJNA902848	7408	321	1.883065	6.04463865	root	1	Root_unresolved	Root_unresolved	593	3.9899999999999986e-165	NTclustered	gi\|47594\|emb\|X53842.1\|	1148	g7358	i0	100	104.006230529595	321	0	100	0	1	321	342	22	Synechocystis sp. ndhE gene (partial), psaC gene for photosystem I iron-sulfur protein and ndhD-like ORF	blastn	33386	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Merismopediaceae	Synechocystis	Synechocystis sp. PCC 6803
11085549	11085549	PRJNA902848_P_NODE_15089_length_250_cov_0.881356_g15039_i0	PRJNA902848	15089	250	0.881356	2.20339	Stanieria sp. PCC 7301	118165	Bacteria	Bacteria	436	5.349999999999999e-118	NTclustered	gi\|1373447558\|gb\|KY979120.1\|	118165	g15039	i0	98.776	173.144	245	3	98	0	1	245	22	266	Stanieria sp. PCC 7301 strain UTEX LB 1635 23S ribosomal RNA gene, partial sequence	blastn	43286	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pleurocapsales	Dermocarpellaceae	Stanieria	Stanieria sp. PCC 7301
12361012	12361012	PRJNA902848_P_NODE_20090_length_242_cov_0.923077_g20040_i0	PRJNA902848	20090	242	0.923077	2.23384634	Cyanobium sp. NS01	261284	Bacteria	Bacteria	259	1.2e-64	NTclustered	gi\|1895767613\|gb\|CP047940.1\|	261284	g20040	i0	86.498	17.8636363636364	237	30	98	2	7	242	2659854	2659619	Cyanobium sp. NS01 chromosome, complete genome	blastn	4323	259	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Prochlorococcaceae	Cyanobium	Cyanobium sp. NS01
25473567	25473567	PRJNA902848_P_NODE_12120_length_262_cov_1.068783_g12070_i0	PRJNA902848	12120	262	1.068783	2.80021146	Cyanophyceae	3028117	Bacteria	Bacteria	449	7.26e-122	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g12070	i0	97.701	137.603053435115	261	6	99	0	1	261	428	168	Uncultured Chroococcidiopsis sp. clone GKJWQY101AIMXN 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	36052	453	0.991169977924945	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
25473576	25473576	PRJNA902848_P_NODE_12460_length_258_cov_1.281081_g12410_i0	PRJNA902848	12460	258	1.281081	3.30518898	Richelia	98443	Bacteria	Bacteria	390	4.38e-104	NTclustered	gi\|2059364121\|gb\|CP021056.1\|	1357546	g12410	i0	93.87	174.290697674419	261	13	100	3	1	258	2717816	2718076	Richelia sinica FACHB-800 strain FACHB 800 chromosome, complete genome	blastn	44967	392	0.994897959183674	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Richelia	Richelia sinica

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