metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA902848" and tax_phylum = "Armatimonadota"

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	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
3798970	3798970	PRJNA902848_P_NODE_15183_length_250_cov_0.881356_g15133_i0	PRJNA902848	15183	250	0.881356	2.20339	Armatimonadota	67819	Bacteria	Bacteria	451	1.91e-122	NTclustered	gi\|2556940000\|gb\|CP129494.1\|	2682144	g15133	i0	99.2	3	250	2	100	1	250	1702354	1702105	MAG: Fimbriimonadaceae bacterium isolate cMAG.2 chromosome, complete genome	blastn	750	451	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
3799002	3799002	PRJNA902848_P_NODE_18303_length_245_cov_0.906977_g18253_i0	PRJNA902848	18303	245	0.906977	2.22209365	Candidatus Nitrosymbiomonas	2819028	Bacteria	Bacteria	436	5.229999999999999e-118	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g18253	i0	98.776	3	245	3	100	1	245	1048	1292	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	735	436	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
4710517	4710517	PRJNA902848_P_NODE_15904_length_249_cov_0.886364_g15854_i0	PRJNA902848	15904	249	0.886364	2.20704636	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2556940000\|gb\|CP129494.1\|	2682144	g15854	i0	99.197	3	249	2	100	1	249	1534475	1534227	MAG: Fimbriimonadaceae bacterium isolate cMAG.2 chromosome, complete genome	blastn	747	449	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
4710574	4710574	PRJNA902848_P_NODE_18404_length_245_cov_0.906977_g18354_i0	PRJNA902848	18404	245	0.906977	2.22209365	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g18354	i0	99.592	3	245	1	100	1	245	2018118	2018362	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	735	448	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
5985171	5985171	PRJNA902848_P_NODE_13085_length_253_cov_0.866667_g13035_i0	PRJNA902848	13085	253	0.866667	2.19266751	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g13035	i0	100	2.9802371541502	253	0	100	1	253	85860	85608	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	754	468	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
5985196	5985196	PRJNA902848_P_NODE_14285_length_251_cov_0.876404_g14235_i0	PRJNA902848	14285	251	0.876404	2.19977404	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	453	5.34e-123	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g14235	i0	99.203	3	251	2	100	1	251	1283397	1283147	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	753	453	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
6351113	6351113	PRJNA902848_P_NODE_5005_length_371_cov_3.181208_g4955_i0	PRJNA902848	5005	371	3.181208	11.80228168	Armatimonadota	67819	Bacteria	Bacteria	684	0	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g4955	i0	100	2.99191374663073	370	0	99	1	370	1249942	1250311	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	1110	684	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
8534834	8534834	PRJNA902848_P_NODE_13667_length_252_cov_0.871508_g13617_i0	PRJNA902848	13667	252	0.871508	2.19620016	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g13617	i0	100	3	252	0	100	1	252	73575	73826	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	756	466	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
9809875	9809875	PRJNA902848_P_NODE_17668_length_246_cov_0.901734_g17618_i0	PRJNA902848	17668	246	0.901734	2.21826564	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g17618	i0	99.593	3	246	1	100	1	246	2278850	2278605	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	738	449	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
11085656	11085656	PRJNA902848_P_NODE_19409_length_243_cov_0.917647_g19359_i0	PRJNA902848	19409	243	0.917647	2.22988221	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g19359	i0	100	1	243	0	100	1	243	257011	256769	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	243	449	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
11450756	11450756	PRJNA902848_P_NODE_20349_length_242_cov_0.923077_g20299_i0	PRJNA902848	20349	242	0.923077	2.23384634	Armatimonadota	67819	Bacteria	Bacteria	431	2.4e-116	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g20299	i0	98.76	3.11570247933884	242	3	100	1	242	956677	956436	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	754	431	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
12360948	12360948	PRJNA902848_P_NODE_17050_length_247_cov_0.896552_g17000_i0	PRJNA902848	17050	247	0.896552	2.21448344	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	435	1.9e-117	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g17000	i0	98.381	3	247	4	100	1	247	2703858	2703612	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	741	435	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
14909882	14909882	PRJNA902848_P_NODE_17192_length_247_cov_0.896552_g17142_i0	PRJNA902848	17192	247	0.896552	2.21448344	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g17142	i0	99.19	3	247	2	100	1	247	120441	120687	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	741	446	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
17460126	17460126	PRJNA902848_P_NODE_15374_length_249_cov_1.329545_g15324_i0	PRJNA902848	15374	249	1.329545	3.31056705	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g15324	i0	100	3	249	0	100	1	249	1184563	1184811	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	747	460	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
18733455	18733455	PRJNA902848_P_NODE_17155_length_247_cov_0.896552_g17105_i0	PRJNA902848	17155	247	0.896552	2.21448344	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g17105	i0	100	2.9919028340081	247	0	100	1	247	737384	737630	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	739	457	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
20008564	20008564	PRJNA902848_P_NODE_16116_length_248_cov_0.891429_g16066_i0	PRJNA902848	16116	248	0.891429	2.21074392	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2556940000\|gb\|CP129494.1\|	2682144	g16066	i0	99.194	3	248	2	100	1	248	556670	556917	MAG: Fimbriimonadaceae bacterium isolate cMAG.2 chromosome, complete genome	blastn	744	448	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
20008661	20008661	PRJNA902848_P_NODE_20036_length_242_cov_0.923077_g19986_i0	PRJNA902848	20036	242	0.923077	2.23384634	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	126	1.2699999999999999e-24	NTclustered	gi\|2076449834\|gb\|CP075365.1\|	2682144	g19986	i0	96.104	0.62396694214876	77	3	32	39	115	2387800	2387724	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM2 chromosome	blastn	151	126	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
21283970	21283970	PRJNA902848_P_NODE_18877_length_244_cov_0.912281_g18827_i0	PRJNA902848	18877	244	0.912281	2.22596564	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g18827	i0	98.77	3	244	3	100	1	244	771995	771752	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	732	435	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
22558782	22558782	PRJNA902848_P_NODE_13818_length_252_cov_0.871508_g13768_i0	PRJNA902848	13818	252	0.871508	2.19620016	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g13768	i0	99.206	3	252	2	100	1	252	674656	674907	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	756	455	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
22558946	22558946	PRJNA902848_P_NODE_20278_length_242_cov_0.923077_g20228_i0	PRJNA902848	20278	242	0.923077	2.23384634	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g20228	i0	100	3	242	0	100	1	242	648964	648723	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	726	448	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus
23833956	23833956	PRJNA902848_P_NODE_10339_length_281_cov_1.105769_g10289_i0	PRJNA902848	10339	281	1.105769	3.10721089	Candidatus Nitrosymbiomonas proteolyticus	2608984	Bacteria	Bacteria	514	2.75e-141	NTclustered	gi\|1996217993\|dbj\|AP021858.1\|	2608984	g10289	i0	99.644	2.99644128113879	281	1	100	1	281	1351134	1351414	Candidatus Nitrosymbiomonas proteolyticus DNA, complete genome	blastn	842	514	1	Bacteria	Bacillati	Armatimonadota				Candidatus Nitrosymbiomonas	Candidatus Nitrosymbiomonas proteolyticus

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