metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA608660" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA608660" 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
584586	584586	PRJNA608660_P_NODE_24421_length_274_cov_2.084444_g24065_i0	PRJNA608660	24421	274	2.084444	5.71137656	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	2.15e-112	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g24065	i0	96.813	375.284671532847	251	6	91	2	11	260	4356940	4357189	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	102828	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3135740	3135740	PRJNA608660_P_NODE_49503_length_162_cov_1.867257_g49146_i0	PRJNA608660	49503	162	1.867257	3.02495634	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	198	1.64e-46	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g49146	i0	91.667	33.2716049382716	144	11	89	1	13	156	3298617	3298475	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	5390	198	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9513024	9513024	PRJNA608660_P_NODE_22548_length_291_cov_1.413223_g22192_i0	PRJNA608660	22548	291	1.413223	4.11247893	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	206	1.96e-48	NTclustered	gi\|112980871\|gb\|DQ829675.1\|	171953	g22192	i0	80.882	102.72852233677	272	42	91	10	17	281	326	58	Uncultured Acidobacteria bacterium clone DON27 23S ribosomal RNA gene, partial sequence	blastn	29894	206	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9513211	9513211	PRJNA608660_P_NODE_43908_length_174_cov_1.664000_g43551_i0	PRJNA608660	43908	174	1.664	2.89536	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	237	3.77e-58	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g43551	i0	93.711	92.3620689655172	159	9	91	1	1	159	3558328	3558171	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	16071	237	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
10788789	10788789	PRJNA608660_P_NODE_14109_length_391_cov_2.859649_g13757_i0	PRJNA608660	14109	391	2.859649	11.18122759	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	182	4.57e-41	NTclustered	gi\|112980878\|gb\|DQ829682.1\|	171953	g13757	i0	81.938	83.4526854219949	227	30	57	10	16	237	239	19	Uncultured Acidobacteria bacterium clone DON15 23S ribosomal RNA gene, partial sequence	blastn	32630	182	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12064304	12064304	PRJNA608660_P_NODE_9010_length_497_cov_19.915179_g8671_i0	PRJNA608660	9010	497	19.915179	98.97843963	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	695	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8671	i0	92.418	192.56338028169	488	35	98	2	12	497	3299702	3299215	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	95704	695	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
14613778	14613778	PRJNA608660_P_NODE_44252_length_173_cov_1.677419_g43895_i0	PRJNA608660	44252	173	1.677419	2.90193487	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	281	1.7e-71	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g43895	i0	98.137	312.832369942197	161	3	93	0	3	163	3919868	3920028	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	54120	281	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
15175249	15175249	PRJNA608660_P_NODE_45092_length_170_cov_1.719008_g44735_i0	PRJNA608660	45092	170	1.719008	2.9223136	Bacteria	2	Bacteria	Bacteria	279	5.99e-71	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g44735	i0	96.988	72.8705882352941	166	5	98	0	5	170	11518	11353	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	12388	279	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19711180	19711180	PRJNA608660_P_NODE_20956_length_305_cov_20.332031_g20600_i0	PRJNA608660	20956	305	20.332031	62.01269455	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	261	4.340000000000001e-65	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g20600	i0	94.22	187.222950819672	173	7	56	2	125	294	3175609	3175437	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	57103	261	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
19711227	19711227	PRJNA608660_P_NODE_26516_length_258_cov_1.043062_g26160_i0	PRJNA608660	26516	258	1.043062	2.69109996	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	255	1.6700000000000001e-63	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g26160	i0	87.124	93.4651162790698	233	20	90	5	19	249	3557715	3557491	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	24114	255	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
20986839	20986839	PRJNA608660_P_NODE_11537_length_438_cov_2.781491_g11190_i0	PRJNA608660	11537	438	2.781491	12.18293058	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	621	2.5699999999999994e-173	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g11190	i0	93.541	140.184931506849	418	26	95	1	16	433	634404	634820	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	61401	621	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
23537120	23537120	PRJNA608660_P_NODE_23919_length_278_cov_3.353712_g23563_i0	PRJNA608660	23919	278	3.353712	9.32331936	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	279	1.08e-70	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g23563	i0	93.194	24.6834532374101	191	12	92	1	23	212	715214	715404	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	6862	279	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24811170	24811170	PRJNA608660_P_NODE_5000_length_648_cov_15.966611_g4704_i0	PRJNA608660	5000	648	15.966611	103.46363928	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	824	0	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g4704	i0	89.893	156.91512345679	653	48	100	12	1	648	4840762	4840123	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	101681	824	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
25373164	25373164	PRJNA608660_P_NODE_16300_length_359_cov_7.170968_g15946_i0	PRJNA608660	16300	359	7.170968	25.74377512	Luteitalea	2004797	Bacteria	Bacteria	640	5.709999999999999e-179	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g15946	i0	99.713	102.066852367688	349	1	97	0	1	349	654394	654046	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	36642	640	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis

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