metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA529224" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA529224" and tax_phylum = "Fibrobacterota"

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_species
1773186	1773186	PRJNA529224_S_NODE_922_length_213_cov_137.315217_g915_i0	PRJNA529224	922	213	137.315217	292.48141221	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	377	2.72e-100	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g915	i0	98.592	247.446009389671	213	3	100	0	1	213	2981750	2981538	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	52706	377	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
5601762	5601762	PRJNA529224_S_NODE_1065_length_201_cov_27.697674_g1058_i0	PRJNA529224	1065	201	27.697674	55.67232474	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	316	5.61e-82	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g1058	i0	95.05	236.004975124378	202	8	100	2	1	201	2060800	2060600	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	47437	316	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
5601791	5601791	PRJNA529224_S_NODE_505_length_272_cov_28.559671_g498_i0	PRJNA529224	505	272	28.559671	77.68230512	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	422	1.65e-113	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g498	i0	94.815	156.466911764706	270	14	99	0	1	270	2980893	2980624	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	42559	422	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
14526889	14526889	PRJNA529224_S_NODE_12_length_781_cov_362.204787_g9_i0	PRJNA529224	12	781	362.204787	2828.81938647	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	817	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g9	i0	85.623	203.444302176697	786	103	100	10	1	781	2981708	2982488	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	158890	817	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
14526903	14526903	PRJNA529224_S_NODE_252_length_355_cov_21.739264_g245_i0	PRJNA529224	252	355	21.739264	77.1743872	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	289	2.35e-73	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g245	i0	82.123	402.645070422535	358	45	100	14	1	354	2060628	2060286	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	142939	289	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
15800616	15800616	PRJNA529224_S_NODE_13_length_714_cov_363.388321_g9_i1	PRJNA529224	13	714	363.388321	2594.59261194	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	725	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g9	i1	85.042	182.666666666667	722	96	100	11	1	714	2981771	2982488	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	130424	725	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
17075320	17075320	PRJNA529224_S_NODE_954_length_210_cov_23.850829_g947_i0	PRJNA529224	954	210	23.850829	50.0867409	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	278	2.79e-70	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g947	i0	90.476	131.066666666667	210	20	100	0	1	210	2980795	2981004	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	27524	278	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota bacterium
22174785	22174785	PRJNA529224_S_NODE_598_length_252_cov_47.968610_g591_i0	PRJNA529224	598	252	47.96861	120.8808972	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	388	1.5299999999999998e-103	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g591	i0	94.779	562.511904761905	249	13	99	0	2	250	2062530	2062778	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	141753	388	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacterota 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);;