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

7 rows where analysis = "blastn", bioproject = "PRJNA797655" 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
785630	785630	PRJNA797655_S_NODE_231101_length_165_cov_2.360656_g230496_i0	PRJNA797655	231101	165	2.360656	3.8950824	uncultured Rivularia sp.	447564	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621703013\|emb\|OY762007.1\|	447564	g230496	i0	97.059	0.206060606060606	34	0	20	1	35	67	567255	567222	MAG: uncultured Rivularia sp. isolate bc3217e8-a359-4fa3-9fd5-735ade2a2895 genome assembly, chromosome: 1	blastn	34	56.5	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Rivulariaceae	Rivularia	uncultured Rivularia sp.
2057937	2057937	PRJNA797655_S_NODE_117482_length_230_cov_2.053476_g116877_i0	PRJNA797655	117482	230	2.053476	4.7229948	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	226	1.1399999999999999e-54	NTclustered	gi\|225696191\|gb\|FJ805858.1\|	259957	g116877	i0	84.416	16.9608695652174	231	34	100	2	1	230	3226	2997	Uncultured Chroococcidiopsis sp. clone AS1_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	3901	226	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
7164290	7164290	PRJNA797655_S_NODE_24046_length_392_cov_1.830946_g23442_i0	PRJNA797655	24046	392	1.830946	7.17730832	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	604	2.2899999999999992e-168	NTclustered	gi\|225696188\|gb\|FJ805855.1\|	259957	g23442	i0	94.643	105.68112244898	392	18	100	2	1	392	3223	2835	Uncultured Chroococcidiopsis sp. clone AR2_2 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	41427	604	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
9710231	9710231	PRJNA797655_S_NODE_112068_length_235_cov_1.250000_g111463_i0	PRJNA797655	112068	235	1.25	2.9375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g111463	i0	100	0.119148936170213	28	0	12	0	78	105	354451	354478	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
12268403	12268403	PRJNA797655_S_NODE_84490_length_262_cov_3.301370_g83885_i0	PRJNA797655	84490	262	3.30137	8.6495894	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	446	9.379999999999998e-121	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g83885	i0	97.328	1	262	7	100	0	1	262	16586	16325	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	262	446	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Gastranaerophilales			Candidatus Gastranaerophilales bacterium
14816644	14816644	PRJNA797655_S_NODE_59692_length_297_cov_1.456693_g59087_i0	PRJNA797655	59692	297	1.456693	4.32637821	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g59087	i0	88.889	0.151515151515152	45	2	14	2	47	88	1079068	1079112	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	45	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium MEL.A1
22895187	22895187	PRJNA797655_S_NODE_98118_length_248_cov_1.609756_g97513_i0	PRJNA797655	98118	248	1.609756	3.99219488	Nostoc	1177	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|186463002\|gb\|CP001037.1\|	63737	g97513	i0	100	0.451612903225806	28	0	11	0	22	49	7834486	7834513	Nostoc punctiforme PCC 73102 strain ATCC 29133 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nostocaceae	Nostoc	Nostoc punctiforme

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