metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA505329" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1110206	1110206	PRJNA505329_P_NODE_14241_length_233_cov_2.766304_g13770_i0	PRJNA505329	14241	233	2.766304	6.44548832	Candidatus Southlakia	3350975	Bacteria	Bacteria	187	5.48e-43	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g13770	i0	100	79.1330472103004	101	0	85	0	133	233	905092	904992	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	18438	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
3034321	3034321	PRJNA505329_P_NODE_17843_length_216_cov_3.413174_g17372_i0	PRJNA505329	17843	216	3.413174	7.37245584	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	390	3.559999999999999e-104	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g17372	i0	99.533	246.74537037037	214	1	99	0	1	214	110268	110055	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	53297	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
3034657	3034657	PRJNA505329_P_NODE_4583_length_369_cov_3.112500_g4117_i0	PRJNA505329	4583	369	3.1125	11.485125	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	606	5.969999999999997e-169	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g4117	i0	96.721	191.314363143631	366	9	99	3	2	366	151244	150881	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	70595	606	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
6861125	6861125	PRJNA505329_P_NODE_26446_length_192_cov_2.153846_g25975_i0	PRJNA505329	26446	192	2.153846	4.13538432	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	346	6.77e-91	NTclustered	gi\|220682311\|gb\|FJ542918.1\|	179883	g25975	i0	99.474	98.8645833333333	190	1	99	0	3	192	83	272	Uncultured candidate division TM7 bacterium clone A10-07D 16S ribosomal RNA gene, partial sequence	blastn	18982	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6861470	6861470	PRJNA505329_P_NODE_8106_length_255_cov_2.398058_g7635_i0	PRJNA505329	8106	255	2.398058	6.1150479	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	460	3.25e-125	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g7635	i0	99.603	92.9647058823529	252	1	99	0	1	252	152814	152563	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	23706	460	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
9411368	9411368	PRJNA505329_P_NODE_23108_length_199_cov_3.100000_g22637_i0	PRJNA505329	23108	199	3.1	6.169	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	89.8	1.32e-13	NTclustered	gi\|2874253778\|emb\|OY969762.1\|	2052149	g22637	i0	85.057	0.728643216080402	87	13	44	0	2	88	933393	933307	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.c.1 genome assembly, chromosome: 1	blastn	145	89.8	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
9411645	9411645	PRJNA505329_P_NODE_4628_length_366_cov_4.085174_g4162_i0	PRJNA505329	4628	366	4.085174	14.95173684	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	555	2.1699999999999998e-153	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g4162	i0	94.215	223.983606557377	363	21	99	0	1	363	139192	138830	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	81978	555	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
14512386	14512386	PRJNA505329_P_NODE_36312_length_177_cov_3.984375_g35841_i0	PRJNA505329	36312	177	3.984375	7.05234375	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	309	8.04e-80	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g35841	i0	100	62.1920903954802	167	0	94	0	1	167	693802	693968	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	11008	309	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
14512436	14512436	PRJNA505329_P_NODE_40832_length_170_cov_3.380165_g40361_i0	PRJNA505329	40832	170	3.380165	5.7462805	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	187	3.74e-43	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g40361	i0	86.982	201.470588235294	169	19	98	2	4	170	162567	162734	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	34250	187	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
24709497	24709497	PRJNA505329_P_NODE_45480_length_166_cov_0.888889_g45009_i0	PRJNA505329	45480	166	0.888889	1.47555574	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g45009	i0	100	58.0361445783133	163	0	98	0	1	163	111654	111492	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	9634	302	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae 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);;