metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
723066	723066	PRJNA744060_P_NODE_21361_length_350_cov_1.819495_g21032_i0	PRJNA744060	21361	350	1.819495	6.3682325	Thalassoporum mexicanum	3457544	Bacteria	Bacteria	58.4	7.11e-4	NTclustered	gi\|427988066\|gb\|CP003592.1\|	82654	g21032	i0	94.595	0.517142857142857	37	2	11	0	217	253	253897	253933	Pseudanabaena sp. PCC 7367, complete genome	blastn	181	58.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Thalassoporaceae	Thalassoporum	Thalassoporum mexicanum
8376858	8376858	PRJNA744060_P_NODE_46527_length_249_cov_0.886364_g46198_i0	PRJNA744060	46527	249	0.886364	2.20704636	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	388	1.51e-103	NTclustered	gi\|225696187\|gb\|FJ805854.1\|	259957	g46198	i0	94.779	185.887550200803	249	13	100	0	1	249	1873	1625	Uncultured Chroococcidiopsis sp. clone AR2_1 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	46286	388	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
13476884	13476884	PRJNA744060_P_NODE_20051_length_361_cov_1.312500_g19722_i0	PRJNA744060	20051	361	1.3125	4.738125	uncultured Chroococcidiopsis sp.	259957	Bacteria	Bacteria	569	7.639999999999997e-158	NTclustered	gi\|453199515\|gb\|JQ997495.1\|	259957	g19722	i0	95.068	124.975069252078	365	13	99	3	1	360	86	450	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	45116	569	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Chroococcidiopsidaceae	Chroococcidiopsis	uncultured Chroococcidiopsis sp.
16501496	16501496	PRJNA744060_P_NODE_9813_length_512_cov_1.902050_g9486_i0	PRJNA744060	9813	512	1.90205	9.738496	Bacteria	2	Bacteria	Bacteria	553	1.1299999999999995e-152	NTclustered	gi\|184189902\|gb\|EU641380.1\|	1211	g9486	i0	86.497	102.603515625	511	59	98	8	1	504	838	331	Uncultured cyanobacterium clone LW9m-1-74 16S ribosomal RNA gene, partial sequence	blastn	52533	553	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
17301745	17301745	PRJNA744060_P_NODE_53774_length_230_cov_2.171975_g53445_i0	PRJNA744060	53774	230	2.171975	4.9955425	Halomicronema hongdechloris	1209493	Bacteria	Bacteria	52.8	0.021	NTclustered	gi\|1562104929\|gb\|CP021983.2\|	1641165	g53445	i0	100	0.121739130434783	28	0	12	0	68	95	4905534	4905507	Halomicronema hongdechloris C2206 genome	blastn	28	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nodosilineales	Nodosilineaceae	Halomicronema	Halomicronema hongdechloris

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