metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA564810" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA564810" 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
1829642	1829642	PRJNA564810_S_NODE_1042_length_400_cov_1.937313_g1020_i0	PRJNA564810	1042	400	1.937313	7.749252	Microcystis aeruginosa	1126	Bacteria	Bacteria	527	5.2199999999999985e-145	NTclustered	gi\|2673719\|emb\|AJ003181.1\|	324056	g1020	i0	94.94	24.21	336	17	84	0	51	386	1	336	Microcystis aeruginosa EAWAG175 partial pcB and pcA genes, strain EAWAG175	blastn	9684	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Microcystaceae	Microcystis	Microcystis aeruginosa
6932220	6932220	PRJNA564810_S_NODE_586_length_469_cov_10.824257_g564_i0	PRJNA564810	586	469	10.824257	50.76576533	Aliterella chasmolithica	2739056	Bacteria	Bacteria	617	3.58e-172	NTclustered	gi\|1713066352\|gb\|MN243145.1\|	2599943	g564	i0	91.537	118.714285714286	449	36	96	2	1	448	2412	1965	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	55677	617	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella chasmolithica
6932226	6932226	PRJNA564810_S_NODE_7006_length_223_cov_1.386076_g6984_i0	PRJNA564810	7006	223	1.386076	3.09094948	Gloeocapsopsis dulcis	2859516	Bacteria	Bacteria	139	1.48e-28	NTclustered	gi\|2583116464\|gb\|CP119968.1\|	2859516	g6984	i0	87.603	4.98206278026906	121	13	53	2	90	208	703339	703459	Gloeocapsopsis dulcis strain AAB1 chromosome, complete genome	blastn	1111	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Chroococcaceae	Gloeocapsopsis	Gloeocapsopsis dulcis
11336735	11336735	PRJNA564810_S_NODE_729_length_443_cov_1.100529_g707_i0	PRJNA564810	729	443	1.100529	4.87534347	Nodularia	159191	Bacteria	Bacteria	285	3.88e-72	NTclustered	gi\|604876398\|gb\|CP007203.2\|	313624	g707	i0	83.28	8.40632054176072	311	51	70	1	111	420	1068697	1068387	Nodularia spumigena CCY9414 genome	blastn	3724	285	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Nodulariaceae	Nodularia	Nodularia spumigena
16436250	16436250	PRJNA564810_S_NODE_1913_length_341_cov_3.550725_g1891_i0	PRJNA564810	1913	341	3.550725	12.10797225	Cyanophyceae	3028117	Bacteria	Bacteria	294	4.85e-75	NTclustered	gi\|1199827411\|gb\|CP019636.1\|	1940762	g1891	i0	83.232	89.7800586510264	328	47	95	7	9	331	6831650	6831974	Nostocales cyanobacterium HT-58-2 chromosome, complete genome	blastn	30615	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales			Nostocales cyanobacterium HT-58-2
19680648	19680648	PRJNA564810_S_NODE_1696_length_351_cov_2.360140_g1674_i0	PRJNA564810	1696	351	2.36014	8.2840914	Aliterella sp. ETH-LAL4-MM48	3237182	Bacteria	Bacteria	507	5.89e-139	NTclustered	gi\|2774606087\|gb\|PQ057073.1\|	3237182	g1674	i0	97.315	85.5498575498575	298	8	85	0	54	351	1355	1058	Aliterella sp. ETH-LAL4-MM48 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	30028	507	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcidiopsidales	Aliterellaceae	Aliterella	Aliterella sp. ETH-LAL4-MM48

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