metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA1145997" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA1145997" 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
2840358	2840358	PRJNA1145997_P_NODE_40423_length_264_cov_1.225131_g37804_i0	PRJNA1145997	40423	264	1.225131	3.23434584	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	449	7.320000000000001e-122	NTclustered	gi\|1805654977\|gb\|CP047916.1\|	2572087	g37804	i0	97.348	6	264	7	100	0	1	264	711192	710929	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS17P chromosome, complete genome	blastn	1584	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
2840424	2840424	PRJNA1145997_P_NODE_44183_length_250_cov_0.881356_g41564_i0	PRJNA1145997	44183	250	0.881356	2.20339	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	379	9.139999999999998e-101	NTclustered	gi\|2218409810\|gb\|CP089289.1\|	2899133	g41564	i0	94	7.968	250	15	100	0	1	250	87062	87311	Candidatus Nanosynbacter sp. HMT-352 strain TM7-072 chromosome	blastn	1992	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
2840453	2840453	PRJNA1145997_P_NODE_46123_length_247_cov_0.896552_g43504_i0	PRJNA1145997	46123	247	0.896552	2.21448344	TM7 phylum sp. oral taxon 349	713051	Bacteria	Bacteria	390	4.1699999999999997e-104	NTclustered	gi\|2028829559\|gb\|CP072328.1\|	713051	g43504	i0	95.142	1.1336032388664	247	12	100	0	1	247	164844	164598	TM7 phylum sp. oral taxon 349 strain PM007 chromosome, complete genome	blastn	280	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					TM7 phylum sp. oral taxon 349
11236808	11236808	PRJNA1145997_P_NODE_43369_length_251_cov_0.876404_g40750_i0	PRJNA1145997	43369	251	0.876404	2.19977404	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	379	9.189999999999998e-101	NTclustered	gi\|734569044\|gb\|CP007496.1\|	2093824	g40750	i0	94.672	6.8605577689243	244	13	97	0	8	251	641079	640836	Candidatus Nanosynbacter lyticus strain TM7x chromosome, complete genome	blastn	1722	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
13043265	13043265	PRJNA1145997_P_NODE_42511_length_253_cov_0.866667_g39892_i0	PRJNA1145997	42511	253	0.866667	2.19266751	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	363	9.339999999999996e-96	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g39892	i0	92.49	2	253	19	100	0	1	253	525085	524833	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	506	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
14318408	14318408	PRJNA1145997_P_NODE_36892_length_290_cov_1.322581_g34273_i0	PRJNA1145997	36892	290	1.322581	3.8354849	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	523	4.7299999999999985e-144	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g34273	i0	99.308	0.996551724137931	289	2	99	0	1	289	518430	518142	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	289	523	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
16866752	16866752	PRJNA1145997_P_NODE_45094_length_248_cov_0.891429_g42475_i0	PRJNA1145997	45094	248	0.891429	2.21074392	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	436	5.3e-118	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g42475	i0	98.776	0.987903225806452	245	3	99	0	2	246	353898	353654	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	245	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
16866781	16866781	PRJNA1145997_P_NODE_46914_length_245_cov_1.709302_g44295_i0	PRJNA1145997	46914	245	1.709302	4.1877899	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	374	4.16e-99	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g44295	i0	94.262	18.5387755102041	244	14	99	0	2	245	778179	777936	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	4542	374	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
20691097	20691097	PRJNA1145997_P_NODE_42397_length_253_cov_0.866667_g39778_i0	PRJNA1145997	42397	253	0.866667	2.19266751	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	435	1.95e-117	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g39778	i0	97.628	2	253	6	100	0	1	253	640074	639822	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	506	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
23241980	23241980	PRJNA1145997_P_NODE_43639_length_251_cov_0.876404_g41020_i0	PRJNA1145997	43639	251	0.876404	2.19977404	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	403	5.45e-108	NTclustered	gi\|1805654977\|gb\|CP047916.1\|	2572087	g41020	i0	95.618	5.72908366533865	251	11	100	0	1	251	311302	311552	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS17P chromosome, complete genome	blastn	1438	403	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
24515604	24515604	PRJNA1145997_P_NODE_51500_length_207_cov_4.791045_g48881_i0	PRJNA1145997	51500	207	4.7910450000000004	9.91746315	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	198	2.2e-46	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g48881	i0	85.859	105.705314009662	198	15	92	9	1	190	664325	664133	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	21881	198	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor

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