metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA897077" and tax_clade = "FCB group"

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
2148832	2148832	PRJNA897077_P_NODE_12402_length_282_cov_1.119617_g12275_i0	PRJNA897077	12402	282	1.119617	3.15731994	Hymenobacter sediminicola	2761579	Bacteria	Bacteria	60.2	1.55e-4	NTclustered	gi\|1893848427\|gb\|CP060202.1\|	2761579	g12275	i0	84.746	0.209219858156028	59	9	21	0	190	248	1068853	1068795	Hymenobacter sediminicola strain S2-20-2 chromosome, complete genome	blastn	59	60.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sediminicola
2519783	2519783	PRJNA897077_P_NODE_16562_length_250_cov_0.881356_g16435_i0	PRJNA897077	16562	250	0.881356	2.20339	Flavobacterium	237	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|2892685955\|gb\|CP174374.1\|	3379707	g16435	i0	100	7.832	250	0	100	0	1	250	1284517	1284766	Flavobacterium sp. TBRC 19031 chromosome, complete genome	blastn	1958	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium mekongense
6348191	6348191	PRJNA897077_P_NODE_7705_length_352_cov_1.397849_g7578_i0	PRJNA897077	7705	352	1.397849	4.92042848	Rhodothermales	1853224	Bacteria	Bacteria	468	2.79e-127	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g7578	i0	90.704	299.181818181818	355	28	100	5	1	352	2906110	2906462	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	105312	468	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
8526427	8526427	PRJNA897077_P_NODE_17447_length_248_cov_0.891429_g17320_i0	PRJNA897077	17447	248	0.891429	2.21074392	Flavisolibacter ginsenosidimutans	661481	Bacteria	Bacteria	381	2.519999999999999e-101	NTclustered	gi\|1721662073\|gb\|CP042433.1\|	661481	g17320	i0	94.715	270.838709677419	246	12	99	1	2	247	4832741	4832985	Flavisolibacter ginsenosidimutans strain Gsoil 636 chromosome, complete genome	blastn	67168	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter ginsenosidimutans
17451937	17451937	PRJNA897077_P_NODE_5794_length_403_cov_1.406061_g5667_i0	PRJNA897077	5794	403	1.406061	5.66642583	Sediminibacterium sp. KACHI17	1751071	Bacteria	Bacteria	660	0	NTclustered	gi\|2690291631\|dbj\|AP029612.1\|	1751071	g5667	i0	96.278	284.808933002481	403	13	100	2	1	403	2978093	2978493	Sediminibacterium sp. KACHI17 DNA, complete genome	blastn	114778	660	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Sediminibacterium	Sediminibacterium sp. KACHI17
18725006	18725006	PRJNA897077_P_NODE_13095_length_274_cov_1.552239_g12968_i0	PRJNA897077	13095	274	1.552239	4.25313486	Prevotella intermedia	28131	Bacteria	Bacteria	473	4.53e-129	NTclustered	gi\|1276670087\|gb\|CP024728.1\|	28131	g12968	i0	97.818	248.660583941606	275	5	100	1	1	274	273969	274243	Prevotella intermedia strain KCOM 1949 chromosome 2, complete sequence	blastn	68133	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella intermedia
20000417	20000417	PRJNA897077_P_NODE_9896_length_313_cov_2.250000_g9769_i0	PRJNA897077	9896	313	2.25	7.0425	Coprobacter fastidiosus	1099853	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|2487365010\|dbj\|AP028032.1\|	1099853	g9769	i0	100	0.0894568690095847	28	0	9	0	237	264	459666	459693	Coprobacter fastidiosus JCM 33896 DNA, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Coprobacter	Coprobacter fastidiosus

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