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

5 rows where analysis = "blastn", bioproject = "PRJNA725806" 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
6298393	6298393	PRJNA725806_P_NODE_12725_length_354_cov_5.113565_g12435_i0	PRJNA725806	12725	354	5.113565	18.1020201	Bacillati	1783272	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|156231356\|gb\|CP000804.1\|	383372	g12435	i0	100	0.15819209039548	28	0	8	0	231	258	3946681	3946708	Roseiflexus castenholzii DSM 13941, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus castenholzii
12191254	12191254	PRJNA725806_P_NODE_43510_length_259_cov_3.099099_g43213_i0	PRJNA725806	43510	259	3.099099	8.02666641	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g43213	i0	100	0.108108108108108	28	0	11	0	64	91	1563839	1563866	Leptolinea sp. HRD-7 DNA, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7
13465610	13465610	PRJNA725806_P_NODE_196331_length_150_cov_1.132743_g196029_i0	PRJNA725806	196331	150	1.132743	1.6991145	Ktedonobacteria bacterium brp13	2717365	Bacteria	Bacteria	200	4.119999999999999e-47	NTclustered	gi\|1915456248\|dbj\|AP024096.1\|	2717365	g196029	i0	92.254	19.48	142	10	95	1	9	150	792780	792640	Ktedonobacteria bacterium brp13 DNA, complete genome	blastn	2922	200	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria				Ktedonobacteria bacterium brp13
18563453	18563453	PRJNA725806_P_NODE_110995_length_190_cov_1.235294_g110693_i0	PRJNA725806	110995	190	1.235294	2.3470586	Thermosporothrix sp. COM3	2490863	Bacteria	Bacteria	261	2.49e-65	NTclustered	gi\|1606557374\|dbj\|AP019376.1\|	2490863	g110693	i0	93.714	229.863157894737	175	9	92	2	17	190	3565269	3565096	Thermosporothrix sp. COM3 DNA, nearly complete genome	blastn	43674	261	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Thermosporotrichaceae	Thermosporothrix	Thermosporothrix sp. COM3
23664840	23664840	PRJNA725806_P_NODE_177379_length_157_cov_1.300000_g177077_i0	PRJNA725806	177379	157	1.3	2.041	uncultured Chloroflexia bacterium	1672391	Bacteria	Bacteria	148	1.61e-31	NTclustered	gi\|2874253706\|emb\|OY969433.1\|	1672391	g177077	i0	85.034	8.47770700636943	147	21	93	1	1	146	1067519	1067373	MAG: uncultured Chloroflexia bacterium isolate MFD00008.bin.1.123 genome assembly, chromosome: 1	blastn	1331	148	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia				uncultured Chloroflexia 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);;