metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1028258" 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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
163382	163382	PRJNA1028258_P_NODE_128121_length_237_cov_2.744048_g127558_i0	PRJNA1028258	128121	237	2.744048	6.50339376	Mesoterricola sediminis	2927980	Bacteria	Bacteria	63.9	9.83e-6	NTclustered	gi\|2490895851\|dbj\|AP027081.1\|	2927980	g127558	i0	100	3.80168776371308	34	0	14	0	96	129	4453972	4453939	Mesoterricola sediminis W786 DNA, complete genome	blastn	901	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Mesoterricola	Mesoterricola sediminis
1440223	1440223	PRJNA1028258_P_NODE_75302_length_297_cov_0.969298_g74739_i0	PRJNA1028258	75302	297	0.969298	2.87881506	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	494	3.81e-135	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g74739	i0	96.633	100.474747474747	297	10	100	0	1	297	3299179	3298883	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	29841	494	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
3989540	3989540	PRJNA1028258_P_NODE_104364_length_257_cov_1.404255_g103801_i0	PRJNA1028258	104364	257	1.404255	3.60893535	Luteitalea pratensis	1855912	Bacteria	Bacteria	62.1	3.88e-5	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g103801	i0	86.207	2.3307392996109	58	7	25	1	96	152	1769754	1769697	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	599	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
3990015	3990015	PRJNA1028258_P_NODE_128884_length_237_cov_1.327381_g128321_i0	PRJNA1028258	128884	237	1.327381	3.14589297	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	278	3.22e-70	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g128321	i0	87.815	136.675105485232	238	27	100	2	1	237	305	69	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	32392	278	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3992140	3992140	PRJNA1028258_P_NODE_82044_length_284_cov_3.311628_g81481_i0	PRJNA1028258	82044	284	3.311628	9.40502352	Candidatus Solibacter usitatus	332163	Bacteria	Bacteria	350	8.3e-92	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g81481	i0	89.399	576.588028169014	283	23	99	4	2	284	1648	1923	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	163751	350	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus
4832714	4832714	PRJNA1028258_P_NODE_142844_length_233_cov_0.865854_g142281_i0	PRJNA1028258	142844	233	0.865854	2.01743982	Pseudomonadati	3379134	Bacteria	Bacteria	128	3.37e-25	NTclustered	gi\|2893358444\|emb\|OZ220736.1\|	2910147	g142281	i0	78.404	20.0472103004292	213	34	89	10	25	231	5262949	5263155	MAG: Vicinamibacterales bacterium isolate e96e4bd8-36b5-4932-a7c8-d2011ef2eb69 genome assembly, chromosome: 1	blastn	4671	128	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
5265965	5265965	PRJNA1028258_P_NODE_112865_length_250_cov_1.397790_g112302_i0	PRJNA1028258	112865	250	1.39779	3.494475	Holophagales bacterium	2478486	Bacteria	Bacteria	279	9.54e-71	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g112302	i0	88.136	43.292	236	26	94	2	7	241	3720687	3720921	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	10823	279	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
5266340	5266340	PRJNA1028258_P_NODE_133745_length_235_cov_0.855422_g133182_i0	PRJNA1028258	133745	235	0.855422	2.0102417	Granulicella sp. WH15	2602070	Bacteria	Bacteria	167	7.21e-37	NTclustered	gi\|1799576755\|gb\|CP042596.1\|	2602070	g133182	i0	80.909	55.3872340425532	220	34	92	8	1	216	2892284	2892499	Granulicella sp. WH15 chromosome, complete genome	blastn	13016	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella sp. WH15
5266880	5266880	PRJNA1028258_P_NODE_166565_length_227_cov_0.898734_g166002_i0	PRJNA1028258	166565	227	0.898734	2.04012618	Holophagales bacterium	2478486	Bacteria	Bacteria	156	1.4999999999999999e-33	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g166002	i0	80.095	43.1321585903084	211	40	93	2	18	227	4008083	4008292	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	9791	156	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
6543862	6543862	PRJNA1028258_P_NODE_90706_length_270_cov_2.845771_g90143_i0	PRJNA1028258	90706	270	2.845771	7.6835817	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	438	1.6299999999999993e-118	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g90143	i0	95.926	114.885185185185	270	11	100	0	1	270	3558059	3558328	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	31019	438	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
9090803	9090803	PRJNA1028258_P_NODE_117188_length_246_cov_2.107345_g116625_i0	PRJNA1028258	117188	246	2.107345	5.1840687	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	121	6.01e-23	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g116625	i0	93.827	24.7357723577236	81	4	33	1	110	190	1034820	1034741	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	6085	121	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12917180	12917180	PRJNA1028258_P_NODE_130451_length_236_cov_1.017964_g129888_i0	PRJNA1028258	130451	236	1.017964	2.40239504	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	411	3.03e-110	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g129888	i0	98.291	133.512711864407	234	4	99	0	3	236	360228	360461	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	31509	411	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
14194417	14194417	PRJNA1028258_P_NODE_90072_length_271_cov_2.554455_g89509_i0	PRJNA1028258	90072	271	2.554455	6.92257305	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	416	7.649999999999999e-112	NTclustered	gi\|105990251\|gb\|DQ513982.1\|	171953	g89509	i0	94.465	94.9114391143911	271	13	100	2	1	271	960	692	Uncultured Acidobacteria bacterium clone 100M1_A10 16S ribosomal RNA gene, partial sequence	blastn	25721	416	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15468267	15468267	PRJNA1028258_P_NODE_74713_length_298_cov_1.240175_g74150_i0	PRJNA1028258	74713	298	1.240175	3.6957215	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	167	9.48e-37	NTclustered	gi\|2891481964\|emb\|OZ219745.1\|	2910147	g74150	i0	80.176	5.8758389261745	227	41	76	4	50	274	1443335	1443559	MAG: Vicinamibacterales bacterium isolate d5a9b4ee-eb88-4731-bb2c-80bf662b4d04 genome assembly, chromosome: 2	blastn	1751	167	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
15468387	15468387	PRJNA1028258_P_NODE_80433_length_288_cov_0.785388_g79870_i0	PRJNA1028258	80433	288	0.785388	2.26191744	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	409	1.3699999999999998e-109	NTclustered	gi\|2874253678\|emb\|OY969112.1\|	171953	g79870	i0	92.388	111.854166666667	289	19	100	3	1	288	4733618	4733332	MAG: uncultured Acidobacteriota bacterium isolate MFD04212.bin.1.16 genome assembly, chromosome: 1	blastn	32214	409	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19291057	19291057	PRJNA1028258_P_NODE_67376_length_312_cov_1.596708_g66813_i0	PRJNA1028258	67376	312	1.596708	4.98172896	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	9.98e-37	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g66813	i0	76.825	4.36217948717949	315	62	99	8	4	312	2248320	2248011	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	1361	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21840776	21840776	PRJNA1028258_P_NODE_157258_length_229_cov_1.612500_g156695_i0	PRJNA1028258	157258	229	1.6125	3.692625	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	60.2	1.22e-4	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g156695	i0	97.222	0.432314410480349	36	0	16	1	4	39	5651559	5651525	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	99	60.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22

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