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

12 rows where analysis = "blastn", bioproject = "PRJNA1011844" 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
7379789	7379789	PRJNA1011844_P_NODE_46026_length_674_cov_3.564060_g37909_i0	PRJNA1011844	46026	674	3.56406	24.0217644	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	1212	0	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g37909	i0	99.698	319.476261127596	662	2	98	0	13	674	143168	143829	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	215327	1212	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9929921	9929921	PRJNA1011844_P_NODE_143468_length_253_cov_2.911111_g134890_i0	PRJNA1011844	143468	253	2.911111	7.36511083	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	440	4.189999999999998e-119	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g134890	i0	100	246.399209486166	238	0	94	0	4	241	142473	142236	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	62339	440	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
12909737	12909737	PRJNA1011844_P_NODE_139631_length_258_cov_1.302703_g131053_i0	PRJNA1011844	139631	258	1.302703	3.36097374	Candidatus Daviesbacteria bacterium	2053542	Bacteria	Bacteria	220	6.08e-53	NTclustered	gi\|1950811978\|gb\|CP066688.1\|	2053542	g131053	i0	83.197	95.7209302325581	244	37	94	4	14	256	496263	496503	MAG: Candidatus Daviesbacteria bacterium isolate NC_groundwater_497_Ag_S-0.1um_39_22 chromosome	blastn	24696	220	1	Bacteria	Bacteria candidate phyla	Candidatus Daviesiibacteriota					Candidatus Daviesbacteria bacterium
14184502	14184502	PRJNA1011844_P_NODE_121392_length_281_cov_3.937500_g112815_i0	PRJNA1011844	121392	281	3.9375	11.064375	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	233	8.62e-57	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g112815	i0	82.562	237.583629893238	281	34	96	13	8	278	161787	162062	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	66761	233	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
14184869	14184869	PRJNA1011844_P_NODE_150792_length_248_cov_0.880000_g142213_i0	PRJNA1011844	150792	248	0.88	2.1824	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	230	9.65e-56	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g142213	i0	88.144	153.528225806452	194	21	78	2	46	238	160575	160383	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	38075	230	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
18008072	18008072	PRJNA1011844_P_NODE_152175_length_247_cov_0.885057_g143596_i0	PRJNA1011844	152175	247	0.885057	2.18609079	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	357	4.22e-94	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g143596	i0	94.421	1.85425101214575	233	11	94	2	9	240	382308	382077	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	458	357	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
19281562	19281562	PRJNA1011844_P_NODE_131116_length_268_cov_2.128205_g122538_i0	PRJNA1011844	131116	268	2.128205	5.7035894	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.6000000000000002e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g122538	i0	99.206	114.891791044776	252	2	94	0	5	256	137031	136780	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	30791	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
19281990	19281990	PRJNA1011844_P_NODE_163176_length_239_cov_2.138554_g154595_i0	PRJNA1011844	163176	239	2.138554	5.11114406	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	322	1.48e-83	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g154595	i0	92.478	225.907949790795	226	16	95	1	14	239	162648	162872	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	53992	322	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
21404281	21404281	PRJNA1011844_P_NODE_54317_length_579_cov_3.081028_g45993_i0	PRJNA1011844	54317	579	3.081028	17.83915212	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	992	0	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g45993	i0	98.236	107.549222797927	567	10	98	0	13	579	151765	152331	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	62271	998	0.993987975951904	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
21832800	21832800	PRJNA1011844_P_NODE_129738_length_270_cov_1.385787_g121160_i0	PRJNA1011844	129738	270	1.385787	3.7416249	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	372	1.67e-98	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g121160	i0	93.902	231.488888888889	246	15	91	0	13	258	665874	665629	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	62502	372	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
23108614	23108614	PRJNA1011844_P_NODE_153799_length_246_cov_0.890173_g145219_i0	PRJNA1011844	153799	246	0.890173	2.18982558	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	405	1.48e-108	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g145219	i0	97.863	1.90243902439024	234	5	95	0	11	244	124664	124431	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	468	405	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
24382186	24382186	PRJNA1011844_P_NODE_137400_length_260_cov_3.016043_g128822_i0	PRJNA1011844	137400	260	3.016043	7.8417118	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	407	4.39e-109	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g128822	i0	96.356	89.3923076923077	247	9	95	0	14	260	800042	799796	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	23242	407	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;