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

8 rows where analysis = "blastn", bioproject = "PRJNA168635" 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_class	tax_order	tax_family	tax_genus	tax_species
364613	364613	PRJNA168635_P_NODE_35041_length_153_cov_2.182692_g34625_i0	PRJNA168635	35041	153	2.182692	3.33951876	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	255	8.900000000000001e-64	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g34625	i0	97.351	85.4117647058823	151	3	99	1	2	151	73966	73816	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	13068	255	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
4191763	4191763	PRJNA168635_P_NODE_3524_length_444_cov_71.870886_g3124_i0	PRJNA168635	3524	444	71.870886	319.10673384	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	737	0	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g3124	i0	96.84	283.331081081081	443	11	99	2	2	442	2981769	2981328	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	125799	737	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
5467993	5467993	PRJNA168635_P_NODE_4905_length_381_cov_2.801205_g4501_i0	PRJNA168635	4905	381	2.801205	10.67259105	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	255	2.58e-63	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g4501	i0	80.22	134.64829396325501	364	52	94	15	23	381	2060264	2060612	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	51301	255	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
13118381	13118381	PRJNA168635_P_NODE_29371_length_164_cov_6.643478_g28955_i0	PRJNA168635	29371	164	6.643478	10.89530392	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	150	4.72e-32	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g28955	i0	83.636	21.9756097560976	165	22	100	3	1	164	1594808	1594968	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	3604	150	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
15081859	15081859	PRJNA168635_P_NODE_2992_length_481_cov_5.523148_g2600_i0	PRJNA168635	2992	481	5.523148	26.56634188	Fibrobacter	832	Bacteria	Bacteria	388	3.1399999999999997e-103	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g2600	i0	90.508	136.573804573805	295	27	61	1	188	481	2221	2515	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	65692	388	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
18216489	18216489	PRJNA168635_P_NODE_8915_length_281_cov_2.762931_g8500_i0	PRJNA168635	8915	281	2.762931	7.76383611	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	278	3.9300000000000005e-70	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g8500	i0	88.596	295.366548042705	228	26	81	0	54	281	2982053	2981826	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	82998	278	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
19490210	19490210	PRJNA168635_P_NODE_11096_length_246_cov_6.045685_g10681_i0	PRJNA168635	11096	246	6.045685	14.8723851	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	351	1.96e-92	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g10681	i0	92.623	283.821138211382	244	18	99	0	3	246	2062778	2062535	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	69820	351	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
24590581	24590581	PRJNA168635_P_NODE_14660_length_210_cov_3.664596_g14244_i0	PRJNA168635	14660	210	3.664596	7.6956516	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	272	1.3e-68	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g14244	i0	100	232.838095238095	147	0	83	0	64	210	2982052	2981906	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	48896	272	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);;