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

11 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
2473586	2473586	PRJNA741997_P_NODE_90222_length_239_cov_2.240964_g89102_i0	PRJNA741997	90222	239	2.240964	5.35590396	Terriglobia	204432	Bacteria	Bacteria	355	1.46e-93	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g89102	i0	93.671	103.518828451883	237	15	99	0	3	239	286269	286505	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	24741	355	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
4550223	4550223	PRJNA741997_P_NODE_85824_length_243_cov_0.905882_g84704_i0	PRJNA741997	85824	243	0.905882	2.20129326	Bryobacterales bacterium	2026791	Bacteria	Bacteria	159	1.2499999999999999e-34	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g84704	i0	79.638	4.87654320987654	221	45	91	0	9	229	4783187	4782967	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	1185	159	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
7100217	7100217	PRJNA741997_P_NODE_52106_length_298_cov_1.222222_g50986_i0	PRJNA741997	52106	298	1.222222	3.64222156	Bryobacterales bacterium	2026791	Bacteria	Bacteria	370	6.73e-98	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g50986	i0	89.369	148.053691275168	301	22	99	9	1	295	2775483	2775779	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	44120	370	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
7100387	7100387	PRJNA741997_P_NODE_79406_length_247_cov_0.885057_g78286_i0	PRJNA741997	79406	247	0.885057	2.18609079	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	134	7.750000000000001e-27	NTclustered	gi\|2874253796\|emb\|OY969780.1\|	194844	g78286	i0	79.07	2.95546558704453	215	29	84	13	12	219	706783	706988	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09603.bin.c.4 genome assembly, chromosome: 1	blastn	730	134	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
9649812	9649812	PRJNA741997_P_NODE_22188_length_480_cov_1.461916_g21070_i0	PRJNA741997	22188	480	1.461916	7.0171968	Geothrix sp. 21YS21S-2	3068893	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|2566094019\|gb\|CP132910.1\|	3068893	g21070	i0	100	0.0583333333333333	28	0	6	0	299	326	3145768	3145741	Geothrix sp. 21YS21S-2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-2
12201048	12201048	PRJNA741997_P_NODE_75590_length_249_cov_0.875000_g74470_i0	PRJNA741997	75590	249	0.875	2.17875	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	303	5.63e-78	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g74470	i0	88.755	7.6425702811245	249	26	99	2	1	248	2720968	2721215	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	1903	303	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12201077	12201077	PRJNA741997_P_NODE_80910_length_246_cov_0.890173_g79790_i0	PRJNA741997	80910	246	0.890173	2.18982558	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2626216371\|emb\|OY821641.1\|	2793154	g79790	i0	94.444	0.146341463414634	36	0	15	2	74	109	1740509	1740476	MAG: Vicinamibacteria bacterium isolate 8cd05730-cbc4-4aa5-8344-af9f7d824ee9 genome assembly, chromosome: 1	blastn	36	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
13475448	13475448	PRJNA741997_P_NODE_68031_length_259_cov_1.655914_g66911_i0	PRJNA741997	68031	259	1.655914	4.28881726	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	84.2	8.36e-12	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g66911	i0	86.076	0.305019305019305	79	9	30	2	178	255	1104990	1104913	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	79	84.2	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
14750614	14750614	PRJNA741997_P_NODE_79272_length_247_cov_0.885057_g78152_i0	PRJNA741997	79272	247	0.885057	2.18609079	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	377	3.24e-100	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g78152	i0	94.378	1.0080971659919	249	9	100	2	1	247	923365	923610	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	249	377	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
24947729	24947729	PRJNA741997_P_NODE_12640_length_692_cov_2.279483_g11573_i0	PRJNA741997	12640	692	2.279483	15.77402236	Paludibaculum fermentans	1473598	Bacteria	Bacteria	665	0	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g11573	i0	84.539	87.1893063583815	705	74	99	27	2	692	4785599	4786282	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	60335	665	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
24947851	24947851	PRJNA741997_P_NODE_28980_length_408_cov_1.220896_g27860_i0	PRJNA741997	28980	408	1.220896	4.98125568	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	647	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g27860	i0	95.545	68.8921568627451	404	18	99	0	1	404	3299797	3299394	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	28108	647	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota 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);;