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

7 rows where analysis = "blastn", bioproject = "PRJEB81171" 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
1413951	1413951	PRJEB81171_P_NODE_2302_length_438_cov_1.115068_g2176_i0	PRJEB81171	2302	438	1.115068	4.88399784	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	593	5.609999999999998e-165	NTclustered	gi\|225696260\|gb\|FJ805927.1\|	259957	g2176	i0	91.156	122.337899543379	441	34	100	5	1	438	3408	2970	Uncultured Chroococcidiopsis sp. clone AS3_3 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	53584	593	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
1413956	1413956	PRJEB81171_P_NODE_2502_length_419_cov_1.615607_g2375_i0	PRJEB81171	2502	419	1.615607	6.76939333	Stenomitos frigidus	1886765	Bacteria	Bacteria	645	1.4499999999999995e-180	NTclustered	gi\|2814759481\|gb\|CP170648.1\|	3070788	g2375	i0	94.928	116.794749403341	414	17	98	4	8	419	19583	19172	MAG: Stenomitos frigidus ULC029 chromosome, complete genome	blastn	48937	645	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Leptolyngbyales	Leptolyngbyaceae	Stenomitos	Stenomitos frigidus
3965655	3965655	PRJEB81171_P_NODE_9884_length_242_cov_1.727811_g9757_i0	PRJEB81171	9884	242	1.727811	4.18130262	Thermosynechococcus vestitus	146786	Bacteria	Bacteria	122	1.6399999999999998e-23	NTclustered	gi\|47118315\|dbj\|BA000039.2\|	197221	g9757	i0	82.27	27.0578512396694	141	25	58	0	1	141	2531024	2530884	Thermosynechococcus elongatus BP-1 DNA, complete genome	blastn	6548	122	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Acaryochloridales	Thermosynechococcaceae	Thermosynechococcus	Thermosynechococcus vestitus
5241966	5241966	PRJEB81171_P_NODE_2845_length_391_cov_1.861635_g2718_i0	PRJEB81171	2845	391	1.861635	7.27899285	Calothrix sp. NIES-4101	2005461	Bacteria	Bacteria	475	1.87e-129	NTclustered	gi\|1210217881\|dbj\|AP018280.1\|	2005461	g2718	i0	90.582	171.470588235294	361	31	92	2	1	360	1243227	1243585	Calothrix sp. NIES-4101 DNA, complete genome	blastn	67045	475	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. NIES-4101
12892849	12892849	PRJEB81171_P_NODE_3011_length_380_cov_1.892508_g2884_i0	PRJEB81171	3011	380	1.892508	7.1915304	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	662	0	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g2884	i0	98.153	119.507894736842	379	7	99	0	2	380	113	491	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	45413	662	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
12892975	12892975	PRJEB81171_P_NODE_8471_length_249_cov_1.079545_g8344_i0	PRJEB81171	8471	249	1.079545	2.68806705	Macrochaete psychrophila	1844959	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|1026261016\|gb\|KT336439.2\|	1781141	g8344	i0	96.787	292.927710843374	249	8	100	0	1	249	2347	2099	Macrochaete psychrophila CCALA 32 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	72939	416	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Macrochaete	Macrochaete psychrophila
20540431	20540431	PRJEB81171_P_NODE_9097_length_246_cov_0.901734_g8970_i0	PRJEB81171	9097	246	0.901734	2.21826564	Cylindrospermopsis curvispora	747548	Bacteria	Bacteria	152	2.13e-32	NTclustered	gi\|1899440624\|gb\|CP060822.1\|	2666332	g8970	i0	81.481	0.768292682926829	189	31	76	4	1	187	669855	670041	Cylindrospermopsis curvispora GIHE-G1 chromosome, complete genome	blastn	189	152	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Aphanizomenonaceae	Cylindrospermopsis	Cylindrospermopsis curvispora

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