metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA797655" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA797655" and tax_phylum = "Cyanobacteriota"

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