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

4 rows where analysis = "blastn", bioproject = "PRJEB58983" 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
6503148	6503148	PRJEB58983_P_NODE_25046_length_265_cov_1.265625_g24631_i0	PRJEB58983	25046	265	1.265625	3.35390625	Synechococcus sp. UTEX LB 2390	2137605	Bacteria	Bacteria	448	2.6399999999999996e-121	NTclustered	gi\|1373447567\|gb\|KY979129.1\|	2137605	g24631	i0	97.004	156.166037735849	267	6	100	2	1	265	416	150	Synechococcus sp. UTEX LB 2390 23S ribosomal RNA gene, partial sequence	blastn	41384	448	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Synechococcales	Synechococcaceae	Synechococcus	Synechococcus sp. UTEX LB 2390
9052265	9052265	PRJEB58983_P_NODE_30688_length_246_cov_0.901734_g30273_i0	PRJEB58983	30688	246	0.901734	2.21826564	[Synechococcus] sp. NIES-970	1827144	Bacteria	Bacteria	239	1.59e-58	NTclustered	gi\|1143527503\|dbj\|AP017959.1\|	1827144	g30273	i0	84.362	23.260162601626	243	38	99	0	1	243	397881	397639	Synechococcus sp. NIES-970 DNA, complete genome	blastn	5722	239	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Chroococcales	Geminocystaceae	Picosynechococcus	[Synechococcus] sp. NIES-970
12878496	12878496	PRJEB58983_P_NODE_23151_length_273_cov_4.760000_g22736_i0	PRJEB58983	23151	273	4.76	12.9948	Pseudanabaenaceae cyanobacterium PMC-1017.18	2575741	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|1628791265\|gb\|MK874330.1\|	2575741	g22736	i0	98.535	99.2564102564103	273	4	100	0	1	273	378	650	Pseudanabaenaceae cyanobacterium PMC-1017.18 16S ribosomal RNA gene, partial sequence	blastn	27097	483	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Pseudanabaenales	Pseudanabaenaceae		Pseudanabaenaceae cyanobacterium PMC-1017.18
17976397	17976397	PRJEB58983_P_NODE_19495_length_293_cov_1.168182_g19080_i0	PRJEB58983	19495	293	1.168182	3.42277326	uncultured cyanobacterium	1211	Bacteria	Bacteria	501	2.24e-137	NTclustered	gi\|429732865\|gb\|JX887884.1\|	1211	g19080	i0	97.603	100.334470989761	292	7	99	0	2	293	1248	957	Uncultured cyanobacterium clone Emix2.2 16S ribosomal RNA gene, 16S-23S ribosomal RNA intergenic spacer, and tRNA-Ile gene, partial sequence	blastn	29398	501	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium

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