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

6 rows where analysis = "blastn", bioproject = "PRJNA1005695" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2276246	2276246	PRJNA1005695_P_NODE_30102_length_272_cov_1.567839_g29250_i0	PRJNA1005695	30102	272	1.567839	4.26452208	Chloroflexus	1107	Bacteria	Bacteria	209	1.4e-49	NTclustered	gi\|470482818\|ref\|NR_076553.1\|	1108	g29250	i0	92.466	72.2058823529412	146	11	54	0	127	272	417	562	Chloroflexus aurantiacus strain J-10-fl 23S ribosomal RNA gene, complete sequence	blastn	19640	209	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Chloroflexaceae	Chloroflexus	Chloroflexus aurantiacus
2703794	2703794	PRJNA1005695_P_NODE_34443_length_253_cov_1.894444_g33591_i0	PRJNA1005695	34443	253	1.894444	4.79294332	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	86.1	2.26e-12	NTclustered	gi\|2893356041\|emb\|OZ220464.1\|	2026734	g33591	i0	94.545	3.68379446640316	55	3	22	0	1	55	2380736	2380682	MAG: Dehalococcoidia bacterium isolate 865023ef-8e16-4315-bfec-facb54b4b210 genome assembly, chromosome: 1	blastn	932	86.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
7806044	7806044	PRJNA1005695_P_NODE_24487_length_303_cov_2.304348_g23635_i0	PRJNA1005695	24487	303	2.304348	6.98217444	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	189	2.0599999999999996e-43	NTclustered	gi\|2874253766\|emb\|OY969711.1\|	1672391	g23635	i0	83.105	309.221122112211	219	25	70	10	61	272	240405	240192	MAG: uncultured Chloroflexia bacterium isolate MFD09730.bin.c.1 genome assembly, chromosome: 1	blastn	93694	189	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia bacterium
9929129	9929129	PRJNA1005695_P_NODE_3088_length_912_cov_5.060787_g2476_i0	PRJNA1005695	3088	912	5.060787	46.15437744	Caldilineaceae	475964	Bacteria	Bacteria	985	0	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g2476	i0	86.304	244.176535087719	920	108	99	10	7	912	1856	941	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	222689	985	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11204422	11204422	PRJNA1005695_P_NODE_29649_length_274_cov_2.149254_g28797_i0	PRJNA1005695	29649	274	2.149254	5.88895596	Caldilinea	233191	Bacteria	Bacteria	285	2.28e-72	NTclustered	gi\|470476010\|ref\|NR_076314.1\|	133453	g28797	i0	86.09	129.839416058394	266	35	97	1	9	274	1236	1499	Caldilinea aerophila strain STL-6-O1 23S ribosomal RNA gene, complete sequence	blastn	35576	285	1	Bacteria	Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea aerophila
11632244	11632244	PRJNA1005695_P_NODE_40730_length_237_cov_2.567073_g39878_i0	PRJNA1005695	40730	237	2.567073	6.08396301	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	246	9.09e-61	NTclustered	gi\|2621704001\|emb\|OY762956.1\|	2026734	g39878	i0	85.654	145.016877637131	237	30	99	4	3	237	1513676	1513442	MAG: Dehalococcoidia bacterium isolate caf6cba7-c187-4a53-abc2-184ab5dfaca7 genome assembly, chromosome: 1	blastn	34369	246	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium

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