metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA436017" 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
1705898	1705898	PRJNA436017_P_NODE_8482_length_301_cov_3.840909_g8184_i0	PRJNA436017	8482	301	3.840909	11.56113609	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	379	1.13e-100	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g8184	i0	89.369	268.046511627907	301	32	100	0	1	301	3559317	3559017	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	80682	379	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
2981551	2981551	PRJNA436017_P_NODE_26343_length_159_cov_1.237705_g26045_i0	PRJNA436017	26343	159	1.237705	1.96795095	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	278	2e-70	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g26045	i0	98.125	99.7232704402516	160	1	100	2	1	159	635379	635537	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	15856	278	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
5534428	5534428	PRJNA436017_P_NODE_17505_length_196_cov_1.685535_g17207_i0	PRJNA436017	17505	196	1.685535	3.3036486	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	95.3	2.78e-15	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g17207	i0	86.022	5.01020408163265	93	7	46	6	2	91	498722	498633	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	982	95.3	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10634463	10634463	PRJNA436017_P_NODE_10009_length_273_cov_1.665254_g9711_i0	PRJNA436017	10009	273	1.665254	4.54614342	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	483	7.5e-132	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g9711	i0	98.535	68.2564102564103	273	4	100	0	1	273	634685	634957	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	18634	483	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
10634923	10634923	PRJNA436017_P_NODE_8609_length_298_cov_6.015326_g8311_i0	PRJNA436017	8609	298	6.015326	17.92567148	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	285	2.51e-72	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g8311	i0	84.175	238.130872483221	297	43	99	4	4	298	3301039	3300745	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	70963	285	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11909575	11909575	PRJNA436017_P_NODE_21950_length_174_cov_2.270073_g21652_i0	PRJNA436017	21950	174	2.270073	3.94992702	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g21652	i0	100	8.52873563218391	174	0	100	0	1	174	635067	635240	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	1484	322	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
14459420	14459420	PRJNA436017_P_NODE_12212_length_242_cov_2.151220_g11914_i0	PRJNA436017	12212	242	2.15122	5.2059524	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g11914	i0	100	123.595041322314	242	0	100	0	1	242	3268130	3267889	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	29910	448	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
14459572	14459572	PRJNA436017_P_NODE_19952_length_183_cov_1.301370_g19654_i0	PRJNA436017	19952	183	1.30137	2.3815071	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g19654	i0	100	119.393442622951	183	0	100	0	1	183	3268630	3268812	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	21849	339	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus
15733583	15733583	PRJNA436017_P_NODE_5373_length_391_cov_1.858757_g5077_i0	PRJNA436017	5373	391	1.858757	7.26773987	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	163	1.66e-35	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g5077	i0	75.881	1.90281329923274	369	61	91	18	3	356	4746910	4746555	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	744	163	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22107455	22107455	PRJNA436017_P_NODE_26418_length_159_cov_0.918033_g26120_i0	PRJNA436017	26418	159	0.918033	1.4596724700000001	uncultured Holophaga sp.	188475	Bacteria	Bacteria	62.1	2.19e-5	NTclustered	gi\|2621702213\|emb\|OY760195.1\|	188475	g26120	i0	92.857	0.547169811320755	42	3	26	0	94	135	2189992	2189951	MAG: uncultured Holophaga sp. isolate 19663c38-e6f5-42a8-8268-146037a524bf genome assembly, chromosome: 1	blastn	87	62.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Holophaga	uncultured Holophaga sp.
22766068	22766068	PRJNA436017_P_NODE_7218_length_331_cov_2.428571_g6921_i0	PRJNA436017	7218	331	2.428571	8.03857001	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	374	5.859999999999998e-99	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g6921	i0	87.195	81.6435045317221	328	42	99	0	1	328	19	346	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	27024	374	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23383053	23383053	PRJNA436017_P_NODE_24799_length_164_cov_1.196850_g24501_i0	PRJNA436017	24799	164	1.19685	1.962834	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	122	1.03e-23	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g24501	i0	97.222	0.439024390243902	72	2	44	0	91	162	4108411	4108482	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	72	122	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
23383196	23383196	PRJNA436017_P_NODE_6039_length_365_cov_1.875000_g5743_i0	PRJNA436017	6039	365	1.875	6.84375	Edaphobacter flagellatus	1933044	Bacteria	Bacteria	527	4.719999999999998e-145	NTclustered	gi\|2304905232\|gb\|CP073697.1\|	1933044	g5743	i0	93.539	319.142465753425	356	20	97	2	11	365	3268185	3268538	Edaphobacter flagellatus strain HZ411 chromosome, complete genome	blastn	116487	527	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Edaphobacter	Edaphobacter flagellatus

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