metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax_phylum = "Spirochaetota"

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
3687424	3687424	PRJNA572587_P_NODE_4963_length_570_cov_61.527831_g4649_i0	PRJNA572587	4963	570	61.527831	350.7086367	Treponema	157	Bacteria	Bacteria	556	9.77e-154	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g4649	i0	85.478	188.056140350877	544	68	95	10	24	564	1283793	1284328	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	107192	556	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
4964079	4964079	PRJNA572587_P_NODE_30684_length_200_cov_21.132450_g30356_i0	PRJNA572587	30684	200	21.13245	42.2649	Treponema	157	Bacteria	Bacteria	320	4.31e-83	NTclustered	gi\|2277017610\|gb\|CP038804.1\|	221027	g30356	i0	97.838	121.5	185	4	93	0	16	200	2088151	2087967	Treponema putidum strain OMZ 835 chromosome, complete genome	blastn	24300	320	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema putidum
6239507	6239507	PRJNA572587_P_NODE_24005_length_229_cov_81.088889_g23677_i0	PRJNA572587	24005	229	81.088889	185.69355581	Treponema	157	Bacteria	Bacteria	292	1.11e-74	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g23677	i0	93.069	189.270742358079	202	11	87	3	21	220	1012726	1012926	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	43343	292	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
6936858	6936858	PRJNA572587_P_NODE_18106_length_267_cov_19.701835_g17778_i0	PRJNA572587	18106	267	19.701835	52.60389945	Treponema medium	58231	Bacteria	Bacteria	416	7.519999999999998e-112	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g17778	i0	97.531	177.228464419476	243	6	91	0	3	245	1014394	1014152	Treponema medium strain T19 chromosome, complete genome	blastn	47320	416	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
9487166	9487166	PRJNA572587_P_NODE_19688_length_255_cov_135.966019_g19360_i0	PRJNA572587	19688	255	135.966019	346.71334845	Treponema medium	58231	Bacteria	Bacteria	237	5.96e-58	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g19360	i0	85.776	80.9803921568627	232	23	89	8	5	232	1012926	1012701	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	20650	237	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
12037954	12037954	PRJNA572587_P_NODE_26450_length_217_cov_20.672619_g26122_i0	PRJNA572587	26450	217	20.672619	44.85958323	Treponema medium	58231	Bacteria	Bacteria	206	1.3899999999999998e-48	NTclustered	gi\|1996296230\|gb\|CP031393.1\|	58231	g26122	i0	90.385	3.32258064516129	156	15	72	0	24	179	2636970	2636815	Treponema medium strain ATCC 700293 chromosome, complete genome	blastn	721	206	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
14587596	14587596	PRJNA572587_P_NODE_20712_length_248_cov_20.894472_g20384_i0	PRJNA572587	20712	248	20.894472	51.81829056	Treponema vincentii	69710	Bacteria	Bacteria	363	9.119999999999997e-96	NTclustered	gi\|1807378492\|gb\|CP048020.1\|	69710	g20384	i0	96.38	12.3548387096774	221	7	89	1	6	226	792517	792298	Treponema vincentii strain OMZ 804 chromosome, complete genome	blastn	3064	363	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
15861846	15861846	PRJNA572587_P_NODE_7053_length_461_cov_15.031553_g6729_i0	PRJNA572587	7053	461	15.031553	69.29545933	Treponema denticola	158	Bacteria	Bacteria	667	0	NTclustered	gi\|2265172126\|gb\|CP051522.1\|	158	g6729	i0	95.673	15.9132321041215	416	17	90	1	23	437	1148700	1148285	Treponema denticola strain OMZ 910 chromosome, complete genome	blastn	7336	667	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
16438571	16438571	PRJNA572587_P_NODE_18933_length_261_cov_20.150943_g18605_i0	PRJNA572587	18933	261	20.150943	52.59396123	Treponema	157	Bacteria	Bacteria	285	2.16e-72	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g18605	i0	88.793	129.210727969349	232	26	89	0	1	232	543	312	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	33724	285	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
18987292	18987292	PRJNA572587_P_NODE_23235_length_234_cov_3.145946_g22907_i0	PRJNA572587	23235	234	3.145946	7.36151364	Treponema	157	Bacteria	Bacteria	139	1.56e-28	NTclustered	gi\|470488561\|ref\|NR_076878.1\|	81028	g22907	i0	80.319	155.021367521368	188	34	79	3	2	187	219	33	Treponema brennaborense strain DD5/3 23S ribosomal RNA gene, complete sequence	blastn	36275	139	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema brennaborense
24785424	24785424	PRJNA572587_P_NODE_9140_length_397_cov_1.347701_g8813_i0	PRJNA572587	9140	397	1.347701	5.35037297	Treponema denticola	158	Bacteria	Bacteria	671	0	NTclustered	gi\|2277007739\|gb\|CP038800.1\|	158	g8813	i0	98.936	4.02770780856423	376	3	95	1	22	397	631249	630875	Treponema denticola strain ATCC 700768 chromosome, complete genome	blastn	1599	671	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
25362354	25362354	PRJNA572587_P_NODE_34120_length_189_cov_9.135714_g33792_i0	PRJNA572587	34120	189	9.135714	17.26649946	Treponema	157	Bacteria	Bacteria	281	1.9e-71	NTclustered	gi\|2265193197\|gb\|CP058347.1\|	158	g33792	i0	97.006	111.089947089947	167	5	88	0	1	167	2223047	2223213	Treponema denticola strain OKA3 chromosome, complete genome	blastn	20996	281	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola

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