metadata: contig_metadata: 10 rows where bioproject = "PRJNA400391" and tax

10 rows where bioproject = "PRJNA400391" 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
1688867	1688867	PRJNA400391_S_NODE_2202_length_269_cov_3.286325_g2141_i0	PRJNA400391	2202	269	3.286325	8.84021425	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	359	1.3e-94	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g2141	i0	91.078	181.468401486989	269	18	99	5	3	269	2061026	2060762	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	48815	359	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
4241099	4241099	PRJNA400391_S_NODE_1444_length_315_cov_24.667857_g1383_i0	PRJNA400391	1444	315	24.667857	77.70374955	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	427	4.1899999999999985e-115	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g1383	i0	91.167	271.955555555556	317	24	100	2	1	315	2981428	2981742	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	85666	427	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
8067439	8067439	PRJNA400391_S_NODE_5787_length_163_cov_2.445312_g5726_i0	PRJNA400391	5787	163	2.445312	3.98585856	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	213	5.89e-51	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g5726	i0	90.361	143.374233128834	166	10	100	5	1	163	2981099	2980937	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	23370	213	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
11892820	11892820	PRJNA400391_S_NODE_1050_length_353_cov_10.622642_g989_i0	PRJNA400391	1050	353	10.622642	37.49792626	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	387	8.06e-103	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g989	i0	86.782	194.133144475921	348	44	98	2	1	346	1595518	1595865	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	68529	387	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
11892860	11892860	PRJNA400391_S_NODE_2690_length_244_cov_6.244019_g2629_i0	PRJNA400391	2690	244	6.244019	15.23540636	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	226	1.23e-54	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g2629	i0	89.56	96.4631147540984	182	14	73	5	66	244	1594270	1594449	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	23537	226	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
15716836	15716836	PRJNA400391_S_NODE_593_length_426_cov_9.951407_g533_i0	PRJNA400391	593	426	9.951407	42.39299382	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	444	5.799999999999998e-120	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g533	i0	86.7	190.023474178404	406	47	94	7	25	426	1595465	1595063	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	80950	444	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
15716850	15716850	PRJNA400391_S_NODE_673_length_405_cov_2.910811_g613_i0	PRJNA400391	673	405	2.910811	11.78878455	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	531	4.09e-146	NTclustered	gi\|1958056460\|gb\|CP064986.1\|	2052160	g613	i0	91.206	133.03950617284	398	24	97	11	13	405	2061351	2061742	Fibrobacteres bacterium isolate Fred_18-Q3-R57-64_MAXAC.109_cln chromosome, complete genome	blastn	53881	531	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
16383460	16383460	PRJNA400391_S_NODE_4933_length_179_cov_1.736111_g4872_i0	PRJNA400391	4933	179	1.736111	3.10763869	Fibrobacter	832	Bacteria	Bacteria	198	1.84e-46	NTclustered	gi\|470485271\|ref\|NR_076693.1\|	834	g4872	i0	87.429	363.664804469274	175	18	96	4	1	172	521	694	Fibrobacter succinogenes subsp. succinogenes strain S85 23S ribosomal RNA gene, complete sequence	blastn	65096	198	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter succinogenes
20815670	20815670	PRJNA400391_S_NODE_1277_length_330_cov_4.311864_g1216_i0	PRJNA400391	1277	330	4.311864	14.2291512	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	248	3.69e-61	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g1216	i0	83.456	209.969696969697	272	39	82	6	60	328	1594219	1593951	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	69290	248	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria bacterium
22090602	22090602	PRJNA400391_S_NODE_778_length_385_cov_292.114286_g717_i0	PRJNA400391	778	385	292.114286	1124.6400011	uncultured Fibrobacteria bacterium	1758207	Bacteria	Bacteria	536	8.319999999999999e-148	NTclustered	gi\|2874253984\|emb\|OY970309.1\|	1758207	g717	i0	91.731	521.433766233766	387	30	100	2	1	385	1596574	1596188	MAG: uncultured Fibrobacteria bacterium isolate MFD05502.bin.1.3 genome assembly, chromosome: 1	blastn	200752	536	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				uncultured Fibrobacteria 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);;