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

12 rows where analysis = "blastn", bioproject = "PRJNA358490" 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
399091	399091	PRJNA358490_P_NODE_4381_length_669_cov_106.001587_g4129_i0	PRJNA358490	4381	669	106.001587	709.15061703	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	859	0	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g4129	i0	90.274	142.14798206278	658	62	98	2	13	669	1243701	1243045	Calothrix sp. NIES-4101 DNA, complete genome	blastn	95097	859	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
1073213	1073213	PRJNA358490_P_NODE_1441_length_1128_cov_56.377410_g1317_i1	PRJNA358490	1441	1128	56.37741	635.9371848	Thermoleptolyngbya	2303528	Bacteria	Bacteria	1581	0	NTclustered	gi\|2592622306\|gb\|CP053540.1\|	2547457	g1317	i1	92.185	146.130319148936	1126	77	99	10	1	1119	312944	311823	Thermoleptolyngbya oregonensis NK1-22 chromosome, complete genome	blastn	164835	1581	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Oculatellales	Oculatellaceae	Thermoleptolyngbya	Thermoleptolyngbya oregonensis
10001339	10001339	PRJNA358490_P_NODE_14748_length_186_cov_1.653061_g14404_i0	PRJNA358490	14748	186	1.653061	3.07469346	root	1	Root_unresolved	Root_unresolved	303	3.98e-78	NTclustered	gi\|192337829\|gb\|EU751438.1\|	1211	g14404	i0	99.405	90.0967741935484	168	0	90	1	20	186	488	655	Uncultured cyanobacterium clone HK05-E01 16S ribosomal RNA gene, partial sequence	blastn	16758	303	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
12551775	12551775	PRJNA358490_P_NODE_9230_length_373_cov_7.104790_g1317_i3	PRJNA358490	9230	373	7.10479	26.5008667	Nodosilinea	1120752	Bacteria	Bacteria	656	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g1317	i3	98.391	186.495978552279	373	6	100	0	1	373	2423	2795	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	69563	656	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
13152721	13152721	PRJNA358490_P_NODE_16931_length_161_cov_1.672131_g16587_i0	PRJNA358490	16931	161	1.672131	2.69213091	Aliterella chasmolithica	2739056	Bacteria	Bacteria	244	2.06e-60	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g16587	i0	94.375	129.055900621118	160	8	99	1	1	159	1970	2129	Aliterella chasmolithica PJ S15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	20778	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
13826597	13826597	PRJNA358490_P_NODE_1431_length_1132_cov_14.558097_g1317_i0	PRJNA358490	1431	1132	14.558097	164.79765804	Nodosilinea	1120752	Bacteria	Bacteria	1962	0	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g1317	i0	98.387	147.943462897527	1116	18	99	0	17	1132	3546	2431	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	167472	1962	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B
15100979	15100979	PRJNA358490_P_NODE_1372_length_1148_cov_65.611362_g1265_i0	PRJNA358490	1372	1148	65.611362	753.21843576	Cyanophyceae	3028117	Bacteria	Bacteria	1567	0	NTclustered	gi\|225696224\|gb\|FJ805891.1\|	259957	g1265	i0	92.246	159.952961672474	1122	61	97	21	23	1133	1918	3024	Uncultured Chroococcidiopsis sp. clone NA2_5 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	183626	1567	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
15701593	15701593	PRJNA358490_P_NODE_10753_length_296_cov_5.603113_g10411_i0	PRJNA358490	10753	296	5.603113	16.58521448	Leptolyngbya sp. 7M	2812896	Bacteria	Bacteria	436	6.489999999999999e-118	NTclustered	gi\|2028908486\|gb\|CP070897.1\|	2812896	g10411	i0	95.273	98.9763513513514	275	13	93	0	1	275	2150699	2150425	Leptolyngbya sp. 7M chromosome	blastn	29297	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Leptolyngbya	Leptolyngbya sp. 7M
18924698	18924698	PRJNA358490_P_NODE_4495_length_659_cov_96.956452_g1317_i2	PRJNA358490	4495	659	96.956452	638.94301868	Nodosilinea	1120752	Bacteria	Bacteria	1011	0	NTclustered	gi\|46409896\|gb\|AY584521.1\|	118166	g1317	i2	94.402	187.497723823976	661	32	100	5	1	659	107	764	Leptolyngbya sp. PCC 7104 23S ribosomal RNA gene, partial sequence	blastn	123561	1018	0.993123772102161	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea nodulosa
20800497	20800497	PRJNA358490_P_NODE_16717_length_163_cov_1.645161_g16373_i0	PRJNA358490	16717	163	1.645161	2.68161243	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	169	1.29e-37	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g16373	i0	88.971	4.30674846625767	136	15	83	0	28	163	511180	511045	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	702	169	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
21474859	21474859	PRJNA358490_P_NODE_1117_length_1243_cov_22.587209_g1032_i0	PRJNA358490	1117	1243	22.587209	280.75900787	Nostocaceae	1162	Bacteria	Bacteria	1437	0	NTclustered	gi\|1796909370\|gb\|CP046703.1\|	76335	g1032	i0	93.272	269.68543845535	981	56	97	8	1	974	3059908	3058931	Nostoc sp. ATCC 53789 chromosome, complete genome	blastn	335219	1447	0.993089149965446	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc sp. ATCC 53789
23350914	23350914	PRJNA358490_P_NODE_12719_length_229_cov_1.700000_g12375_i0	PRJNA358490	12719	229	1.7	3.893	Nodosilinea sp. 2.2B	2876719	Bacteria	Bacteria	285	1.85e-72	NTclustered	gi\|2095813679\|gb\|OK161231.1\|	2876719	g12375	i0	89.083	153.825327510917	229	25	100	0	1	229	2158	2386	Nodosilinea sp. 2.2B 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	35226	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Nodosilinea	Nodosilinea sp. 2.2B

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