metadata: contig_metadata: 10 rows where bioproject = "PRJNA473824", tax_kingdom = "Pseudomonadati" and tax

10 rows where bioproject = "PRJNA473824", tax_kingdom = "Pseudomonadati" 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
13200862	13200862	PRJNA473824_P_NODE_72711_length_173_cov_3.750000_g72073_i0	PRJNA473824	72711	173	3.75	6.4875	Treponema vincentii	69710	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2265136109\|gb\|CP051197.1\|	69710	g72073	i0	100	2.63583815028902	76	0	88	0	1	76	1455296	1455371	Treponema vincentii strain OMZ 802 chromosome, complete genome	blastn	456	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
14475077	14475077	PRJNA473824_P_NODE_159912_length_151_cov_2.885965_g159274_i0	PRJNA473824	159912	151	2.885965	4.35780715	Treponema vincentii	69710	Bacteria	Bacteria	241	2.4500000000000008e-59	NTclustered	gi\|2265115921\|gb\|CP051153.1\|	69710	g159274	i0	95.395	13.9867549668874	152	5	99	1	2	151	1077799	1077648	Treponema vincentii strain OMZ 862 chromosome, complete genome	blastn	2112	241	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema vincentii
15749659	15749659	PRJNA473824_P_NODE_44293_length_184_cov_2.306122_g43655_i0	PRJNA473824	44293	184	2.306122	4.24326448	Treponema rectale	744512	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1919550644\|gb\|CP031517.1\|	744512	g43655	i0	100	0.342391304347826	30	0	16	0	25	54	2466253	2466224	Treponema rectale strain CHPA chromosome, complete genome	blastn	63	56.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema rectale
18297677	18297677	PRJNA473824_P_NODE_104495_length_173_cov_2.683824_g103857_i0	PRJNA473824	104495	173	2.683824	4.64301552	Treponema socranskii	53419	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2265187740\|gb\|CP054258.1\|	69713	g103857	i0	100	2.17919075144509	76	0	88	0	98	173	359219	359294	Treponema socranskii subsp. buccale strain ATCC 35534 chromosome, complete genome	blastn	377	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema socranskii
18947631	18947631	PRJNA473824_P_NODE_114675_length_173_cov_2.286765_g114037_i0	PRJNA473824	114675	173	2.286765	3.95610345	Bacteria	2	Bacteria	Bacteria	141	3.01e-29	NTclustered	gi\|2323013626\|gb\|CP109619.1\|	158	g114037	i0	100	56.7976878612717	76	0	88	0	1	76	319787	319862	Treponema denticola strain KCOM 3500 chromosome, complete genome	blastn	9826	141	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema denticola
18948239	18948239	PRJNA473824_P_NODE_90895_length_173_cov_3.036765_g90257_i0	PRJNA473824	90895	173	3.036765	5.25360345	Treponema	157	Bacteria	Bacteria	198	1.7599999999999998e-46	NTclustered	gi\|2265141765\|gb\|CP051199.1\|	2563664	g90257	i0	87.861	16.9884393063584	173	5	100	1	1	173	1100335	1100491	Treponema sp. OMZ 788 chromosome, complete genome	blastn	2939	198	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 788
25322690	25322690	PRJNA473824_P_NODE_36240_length_200_cov_4.018405_g35602_i0	PRJNA473824	36240	200	4.018405	8.03681	Treponema	157	Bacteria	Bacteria	200	5.86e-47	NTclustered	gi\|1996291085\|gb\|CP027017.1\|	58231	g35602	i0	96.667	137.28	120	4	100	0	81	200	1014678	1014797	Treponema medium strain T19 chromosome, complete genome	blastn	27456	200	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema medium
28671518	28671518	PRJNA473824_P_NODE_137067_length_151_cov_8.447368_g136429_i0	PRJNA473824	137067	151	8.447368	12.75552568	Turneriella	338321	Bacteria	Bacteria	66.2	5.45e-11	NR	MBL8032680.1	2026757	g136429	i0	52.3	5.22516556291391	88	4	99.3	1	151	2	227	314	MBL8032680.1 HAD-IC family P-type ATPase [Leptospiraceae bacterium]	diamond	789	66.6	0.993993993993994	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Leptospirales	Leptospiraceae		Leptospiraceae bacterium
31593424	31593424	PRJNA473824_P_NODE_150256_length_151_cov_3.736842_g149618_i0	PRJNA473824	150256	151	3.736842	5.64263142	Treponema sp. OMZ 799	2563668	Bacteria	Bacteria	68.6	2.86e-12	NR	WP_253710703.1	2563668	g149618	i0	46.2	4.64900662251656	78	14	99.3	1	151	2	33	110	WP_253710703.1 DNA alkylation repair protein [Treponema sp. OMZ 799]	diamond	702	68.6	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp. OMZ 799
31988902	31988902	PRJNA473824_P_NODE_96258_length_173_cov_2.838235_g95620_i0	PRJNA473824	96258	173	2.838235	4.91014655	Bacteria	2	Bacteria	Bacteria	55.5	4.68e-7	NR	MCL2318959.1	166	g95620	i0	100	73.2658959537572	25	0	43.4	0	98	172	96	120	MCL2318959.1 pyruvate:ferredoxin (flavodoxin) oxidoreductase [Treponema sp.]	diamond	12675	55.5	1	Bacteria	Pseudomonadati	Spirochaetota	Spirochaetia	Spirochaetales	Treponemataceae	Treponema	Treponema sp.

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