metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA473799" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA473799" 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
2371049	2371049	PRJNA473799_P_NODE_2042_length_1003_cov_3.578495_g1837_i0	PRJNA473799	2042	1003	3.578495	35.89230485	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	1541	0	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g1837	i0	94.934	340.260219341974	987	45	98	5	19	1003	151568	152551	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	341281	1552	0.992912371134021	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
2996655	2996655	PRJNA473799_P_NODE_56163_length_233_cov_2.218750_g55889_i0	PRJNA473799	56163	233	2.21875	5.1696875	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	187	5.48e-43	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g55889	i0	84.375	14.5622317596567	192	29	82	1	26	217	126224	126414	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	3393	187	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
3646877	3646877	PRJNA473799_P_NODE_30683_length_257_cov_9.320652_g30409_i0	PRJNA473799	30683	257	9.320652	23.95407564	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	475	1.1699999999999999e-129	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g30409	i0	100	209.287937743191	257	0	100	0	1	257	142469	142213	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	53787	475	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
4272828	4272828	PRJNA473799_P_NODE_44224_length_246_cov_0.890173_g43950_i0	PRJNA473799	44224	246	0.890173	2.18982558	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g43950	i0	100	1	246	0	100	0	1	246	626010	625765	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	246	455	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
6823387	6823387	PRJNA473799_P_NODE_37266_length_250_cov_0.870056_g36992_i0	PRJNA473799	37266	250	0.870056	2.17514	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	342	1.1999999999999999e-89	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g36992	i0	91.532	2.992	248	21	99	0	3	250	141857	141610	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	748	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
6823572	6823572	PRJNA473799_P_NODE_48226_length_244_cov_0.900585_g47952_i0	PRJNA473799	48226	244	0.900585	2.1974274	Candidatus Nanosynbacter sp. BB002	3393757	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|2692798772\|gb\|CP146064.1\|	3393757	g47952	i0	98.77	14.9713114754098	244	3	100	0	1	244	543766	543523	Candidatus Nanosynbacter sp. BB002 chromosome, complete genome	blastn	3653	435	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. BB002
11924076	11924076	PRJNA473799_P_NODE_14590_length_290_cov_1.414747_g14316_i0	PRJNA473799	14590	290	1.414747	4.1027663	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	420	6.39e-113	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g14316	i0	93.031	0.989655172413793	287	20	99	0	1	287	364949	365235	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	287	420	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
11924446	11924446	PRJNA473799_P_NODE_42070_length_247_cov_0.885057_g41796_i0	PRJNA473799	42070	247	0.885057	2.18609079	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1805654977\|gb\|CP047916.1\|	2572087	g41796	i0	100	6	247	0	100	0	1	247	124876	124630	Candidatus Saccharibacteria bacterium oral taxon 955 strain FS17P chromosome, complete genome	blastn	1482	457	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
11924628	11924628	PRJNA473799_P_NODE_54430_length_241_cov_0.916667_g54156_i0	PRJNA473799	54430	241	0.916667	2.20916747	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	148	2.69e-31	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g54156	i0	94.737	39.356846473029	95	5	39	0	63	157	305117	305023	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	9485	148	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
11924690	11924690	PRJNA473799_P_NODE_9410_length_345_cov_1.698529_g9136_i0	PRJNA473799	9410	345	1.698529	5.85992505	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	368	2.85e-97	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g9136	i0	86.402	190.376811594203	353	29	98	13	7	345	161248	160901	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	65680	368	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
15748028	15748028	PRJNA473799_P_NODE_11893_length_310_cov_2.274262_g11619_i0	PRJNA473799	11893	310	2.274262	7.0502122	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	556	5.03e-154	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g11619	i0	99.032	237.632258064516	310	3	100	0	1	310	597435	597744	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	73666	556	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
17673649	17673649	PRJNA473799_P_NODE_8474_length_368_cov_3.627119_g8200_i0	PRJNA473799	8474	368	3.627119	13.34779792	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	680	0	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g8200	i0	100	180.364130434783	368	0	100	0	1	368	80490	80123	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	66374	680	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
20847042	20847042	PRJNA473799_P_NODE_16637_length_286_cov_0.985915_g16363_i0	PRJNA473799	16637	286	0.985915	2.8197169	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	405	1.76e-108	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g16363	i0	92.553	159.465034965035	282	21	99	0	1	282	138866	138585	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	45607	405	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
23397677	23397677	PRJNA473799_P_NODE_19099_length_280_cov_1.492754_g18825_i0	PRJNA473799	19099	280	1.492754	4.1797112	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	446	1.01e-120	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g18825	i0	95.357	63.75	280	13	100	0	1	280	111525	111246	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	17850	446	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
24671526	24671526	PRJNA473799_P_NODE_16160_length_287_cov_0.981308_g15886_i0	PRJNA473799	16160	287	0.981308	2.81635396	Candidatus Acetithermum autotrophicum	1446466	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|374856511\|dbj\|AP011803.1\|	1446466	g15886	i0	100	0.101045296167247	29	0	10	0	24	52	865524	865496	Candidatus Acetothermus autotrophicum DNA, large contig sequence, contig 4	blastn	29	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Bipolaricaulota				Candidatus Acetithermum	Candidatus Acetithermum autotrophicum
24671899	24671899	PRJNA473799_P_NODE_43040_length_247_cov_0.885057_g42766_i0	PRJNA473799	43040	247	0.885057	2.18609079	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	255	1.59e-63	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g42766	i0	85.484	231.210526315789	248	33	100	3	1	247	5574	5329	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	57109	255	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28

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