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

11 rows where analysis = "blastn", bioproject = "PRJNA879314" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3408712	3408712	PRJNA879314_P_NODE_9943_length_244_cov_0.912281_g9893_i0	PRJNA879314	9943	244	0.912281	2.22596564	Geothrix oryzae	2927975	Bacteria	Bacteria	396	8.829999999999997e-106	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g9893	i0	95.902	19.1311475409836	244	10	100	0	1	244	2836202	2835959	Geothrix oryzae Red222 DNA, complete genome	blastn	4668	396	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
5961109	5961109	PRJNA879314_P_NODE_5305_length_252_cov_0.871508_g5255_i0	PRJNA879314	5305	252	0.871508	2.19620016	uncultured Holophaga sp.	188475	Bacteria	Bacteria	222	1.65e-53	NTclustered	gi\|2621702213\|emb\|OY760195.1\|	188475	g5255	i0	85.648	4.19444444444444	216	25	85	5	37	249	1778151	1778363	MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1	blastn	1057	222	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
7236070	7236070	PRJNA879314_P_NODE_9146_length_245_cov_0.906977_g9096_i0	PRJNA879314	9146	245	0.906977	2.22209365	Acidobacteria bacterium Mor1	1660251	Bacteria	Bacteria	69.4	2.2e-7	NTclustered	gi\|1037405666\|gb\|CP011806.1\|	1660251	g9096	i0	84.211	1.73061224489796	76	6	30	3	161	233	4510523	4510595	Acidobacteria bacterium Mor1 chromosome	blastn	424	69.4	1	Bacteria	Acidobacteriota subdivision 22	Pseudomonadati	Acidobacteriota					Acidobacteria bacterium Mor1
13611500	13611500	PRJNA879314_P_NODE_4171_length_257_cov_0.853261_g4121_i0	PRJNA879314	4171	257	0.853261	2.19288077	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	102	2.29e-17	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g4121	i0	84.112	3.80155642023346	107	15	41	2	146	251	2396059	2396164	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	977	102	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
17436000	17436000	PRJNA879314_P_NODE_1114_length_405_cov_0.894578_g1064_i0	PRJNA879314	1114	405	0.894578	3.6230409	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	279	1.64e-70	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g1064	i0	83.607	14.1530864197531	305	42	74	7	30	330	3303566	3303266	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	5732	279	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
17436059	17436059	PRJNA879314_P_NODE_5974_length_251_cov_0.876404_g5924_i0	PRJNA879314	5974	251	0.876404	2.19977404	Holophagales bacterium	2478486	Bacteria	Bacteria	156	1.69e-33	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g5924	i0	89.431	1.63346613545817	123	13	49	0	4	126	136366	136488	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	410	156	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
17436112	17436112	PRJNA879314_P_NODE_9394_length_245_cov_0.906977_g9344_i0	PRJNA879314	9394	245	0.906977	2.22209365	Geothrix sp.	1962974	Bacteria	Bacteria	285	2.0000000000000002e-72	NTclustered	gi\|2515262989\|gb\|CP126625.1\|	1962974	g9344	i0	87.805	3.01224489795918	246	27	99	2	1	243	1713442	1713197	MAG: Geothrix sp. isolate L227-G1 chromosome, complete genome	blastn	738	285	1	Bacteria		Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
18709250	18709250	PRJNA879314_P_NODE_5115_length_252_cov_0.871508_g5065_i0	PRJNA879314	5115	252	0.871508	2.19620016	Bryobacterales bacterium	2026791	Bacteria	Bacteria	272	1.6099999999999999e-68	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g5065	i0	86.4	2.52380952380952	250	32	99	2	4	252	1274015	1274263	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	636	272	1	Bacteria		Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
19984614	19984614	PRJNA879314_P_NODE_9216_length_245_cov_0.906977_g9166_i0	PRJNA879314	9216	245	0.906977	2.22209365	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	134	7.68e-27	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g9166	i0	80	6	185	34	75	3	40	222	5947595	5947778	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	1470	134	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
21259896	21259896	PRJNA879314_P_NODE_3777_length_267_cov_1.206186_g3727_i0	PRJNA879314	3777	267	1.206186	3.22051662	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	145	3.9199999999999995e-30	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g3727	i0	78.696	0.861423220973783	230	39	84	10	42	266	418621	418845	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	230	145	1	Bacteria		Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23810029	23810029	PRJNA879314_P_NODE_4439_length_253_cov_0.866667_g4389_i0	PRJNA879314	4439	253	0.866667	2.19266751	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	171	6.07e-38	NTclustered	gi\|2621704939\|emb\|OY762226.1\|	2910147	g4389	i0	88.194	55.1857707509881	144	15	57	2	35	177	1530438	1530296	MAG: Vicinamibacterales bacterium isolate 0d5134ca-f8ab-4963-ab29-a032ed897002 genome assembly, chromosome: 1	blastn	13962	171	1	Bacteria		Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;