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

5 rows where analysis = "blastn", bioproject = "PRJEB56699" 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
124576	124576	PRJEB56699_P_NODE_4201_length_238_cov_3.602871_g3971_i0	PRJEB56699	4201	238	3.602871	8.57483298	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	363	8.69e-96	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g3971	i0	94.191	241.726890756303	241	8	100	4	1	238	1858572	1858335	Calothrix sp. PCC 7716 DNA, complete genome	blastn	57531	363	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
6502836	6502836	PRJEB56699_P_NODE_1386_length_498_cov_6.861407_g1188_i0	PRJEB56699	1386	498	6.861407	34.16980686	Calothrix parietina	32054	Bacteria	Bacteria	881	0	NTclustered	gi\|1345606777\|gb\|MG968511.1\|	2081933	g1188	i0	98.982	191.913654618474	491	5	99	0	8	498	1	491	Calothrix parietina UTEX LB 1952 23S ribosomal RNA gene, partial sequence	blastn	95573	881	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix parietina
12471007	12471007	PRJEB56699_P_NODE_4450_length_227_cov_4.015152_g4220_i0	PRJEB56699	4450	227	4.015152	9.11439504	root	1	Root_unresolved	Root_unresolved	401	1.7399999999999995e-107	NTclustered	gi\|353256004\|gb\|JN090916.1\|	1211	g4220	i0	100	102.863436123348	217	0	96	0	1	217	368	584	Uncultured cyanobacterium clone D57C8 16S ribosomal RNA gene, partial sequence	blastn	23350	401	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota					uncultured cyanobacterium
15427000	15427000	PRJEB56699_P_NODE_1313_length_514_cov_4.562887_g1118_i0	PRJEB56699	1313	514	4.562887	23.45323918	Calothrix sp. PCC 7716	2853227	Bacteria	Bacteria	889	0	NTclustered	gi\|2083844586\|dbj\|AP025018.1\|	2853227	g1118	i0	97.86	289.928015564202	514	11	100	0	1	514	1858808	1859321	Calothrix sp. PCC 7716 DNA, complete genome	blastn	149023	889	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Cyanobacteriota	Cyanophyceae	Nostocales	Calotrichaceae	Calothrix	Calothrix sp. PCC 7716
18843646	18843646	PRJEB56699_P_NODE_5535_length_195_cov_2.403614_g5305_i0	PRJEB56699	5535	195	2.403614	4.6870473	Dulcicalothrix	2662189	Bacteria	Bacteria	318	1.5e-82	NTclustered	gi\|443300358\|gb\|KC216389.1\|	1211	g5305	i0	96.842	97.8615384615385	190	6	97	0	1	190	208	19	Uncultured cyanobacterium clone DBS-107 16S ribosomal RNA gene, partial sequence	blastn	19083	318	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);;