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

10 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
1207028	1207028	PRJNA773247_P_NODE_30001_length_252_cov_1.486034_g29917_i0	PRJNA773247	30001	252	1.486034	3.74480568	Limnospira	2596745	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1832554406\|gb\|CP051185.1\|	1521533	g29917	i0	100	8.50396825396825	252	0	100	0	1	252	4924341	4924090	Limnospira fusiformis SAG 85.79 chromosome, complete genome	blastn	2143	466	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira fusiformis
5035423	5035423	PRJNA773247_P_NODE_32884_length_245_cov_1.348837_g32800_i0	PRJNA773247	32884	245	1.348837	3.30465065	Limnospira	2596745	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g32800	i0	100	8.01632653061225	245	0	100	0	1	245	5719542	5719298	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1964	453	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
6311054	6311054	PRJNA773247_P_NODE_22165_length_301_cov_3.960526_g22081_i0	PRJNA773247	22165	301	3.960526	11.92118326	Limnospira	2596745	Bacteria	Bacteria	556	4.87e-154	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g22081	i0	100	46.6910299003322	301	0	100	0	1	301	2821337	2821637	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	14054	556	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
6311056	6311056	PRJNA773247_P_NODE_22545_length_298_cov_1.968889_g22461_i0	PRJNA773247	22545	298	1.968889	5.86728922	Limnospira	2596745	Bacteria	Bacteria	525	1.3599999999999994e-144	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g22461	i0	99.31	16.7785234899329	290	2	97	0	9	298	5117415	5117126	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	5000	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
13961036	13961036	PRJNA773247_P_NODE_35211_length_239_cov_3.373494_g35127_i0	PRJNA773247	35211	239	3.373494	8.06265066	Limnospira	2596745	Bacteria	Bacteria	424	3.95e-114	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g35127	i0	100	7.65690376569038	229	0	96	0	1	229	2112531	2112759	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	1830	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
18600665	18600665	PRJNA773247_P_NODE_26175_length_273_cov_1.540000_g26091_i0	PRJNA773247	26175	273	1.54	4.2042	Stenomitos frigidus	1886765	Bacteria	Bacteria	460	3.5099999999999996e-125	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g26091	i0	97.07	1	273	8	100	0	1	273	33103	32831	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	273	460	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
19058762	19058762	PRJNA773247_P_NODE_25395_length_278_cov_1.092683_g25311_i0	PRJNA773247	25395	278	1.092683	3.03765874	Oscillatoriales	1150	Bacteria	Bacteria	508	1.26e-139	NTclustered	gi\|2395771017\|gb\|CP066886.2\|	147317	g25311	i0	99.64	122.913669064748	278	1	100	0	1	278	222952	223229	Arthrospira sp. PCC 9108 chromosome, complete genome	blastn	34170	508	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Microcoleaceae	Arthrospira	Arthrospira sp. PCC 9108
20333408	20333408	PRJNA773247_P_NODE_13976_length_401_cov_12.646341_g13892_i0	PRJNA773247	13976	401	12.646341	50.71182741	Limnospira	2596745	Bacteria	Bacteria	710	0	NTclustered	gi\|585302946\|emb\|FO818640.1\|	376219	g13892	i0	99.237	15.1745635910224	393	3	98	0	9	401	2838458	2838850	Arthrospira sp. str. PCC 8005 chromosome, complete genome	blastn	6085	710	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
22426120	22426120	PRJNA773247_P_NODE_19558_length_325_cov_6.789683_g19474_i0	PRJNA773247	19558	325	6.789683	22.06646975	Limnospira indica	147322	Bacteria	Bacteria	545	1.15e-150	NTclustered	gi\|1893852475\|gb\|CP060212.1\|	2760438	g19474	i0	98.697	7.57538461538462	307	4	94	0	13	319	6162495	6162801	MAG: Limnospira indica BM01 chromosome	blastn	2462	545	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oscillatoriales	Sirenicapillariaceae	Limnospira	Limnospira indica
23701968	23701968	PRJNA773247_P_NODE_34259_length_242_cov_1.479290_g34175_i0	PRJNA773247	34259	242	1.47929	3.5798818	Stenomitos frigidus	1886765	Bacteria	Bacteria	302	1.96e-77	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g34175	i0	89.3	1.00413223140496	243	22	99	3	2	242	32867	32627	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	243	302	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus

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