metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJEB30004" and tax

15 rows where analysis = "blastn", bioproject = "PRJEB30004" 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
2588116	2588116	PRJEB30004_P_NODE_347963_length_252_cov_2.192488_g332336_i0	PRJEB30004	347963	252	2.192488	5.52506976	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	252	2.1e-62	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g332336	i0	86.522	86.2579365079365	230	29	91	2	24	252	308481	308709	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	21737	252	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2604335	2604335	PRJEB30004_P_NODE_686603_length_150_cov_2.297297_g670976_i0	PRJEB30004	686603	150	2.297297	3.4459455	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	141	2.53e-29	NTclustered	gi\|2874254120\|emb\|OY970205.1\|	194844	g670976	i0	85.714	0.886666666666667	133	19	89	0	16	148	3606857	3606989	MAG: uncultured Acidobacteriaceae bacterium isolate MFD02248.bin.1.24 genome assembly, chromosome: 1	blastn	133	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
11519451	11519451	PRJEB30004_P_NODE_413890_length_221_cov_1.593407_g398263_i0	PRJEB30004	413890	221	1.593407	3.52142947	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	353	4.789999999999999e-93	NTclustered	gi\|2874254057\|emb\|OY970381.1\|	194844	g398263	i0	95.495	235.619909502262	222	9	100	1	1	221	1655552	1655773	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04580.bin.1.19 genome assembly, chromosome: 1	blastn	52072	353	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
11525574	11525574	PRJEB30004_P_NODE_540810_length_180_cov_2.269504_g525183_i0	PRJEB30004	540810	180	2.269504	4.0851072	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	244	2.35e-60	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g525183	i0	91.111	133.911111111111	180	16	100	0	1	180	4233771	4233950	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	24104	244	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12784338	12784338	PRJEB30004_P_NODE_189551_length_393_cov_10.079096_g173935_i0	PRJEB30004	189551	393	10.079096	39.61084728	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	532	1.0999999999999996e-146	NTclustered	gi\|2874253760\|emb\|OY969701.1\|	2283092	g173935	i0	91.184	116.521628498728	397	28	100	7	1	393	3176257	3176650	MAG: Pyrinomonadaceae bacterium isolate MFD04212.bin.c.1 genome assembly, chromosome: 1	blastn	45793	532	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
12797457	12797457	PRJEB30004_P_NODE_468591_length_201_cov_1.691358_g452964_i0	PRJEB30004	468591	201	1.691358	3.39962958	Candidatus Korobacter versatilis	658062	Bacteria	Bacteria	145	2.8e-30	NTclustered	gi\|94549081\|gb\|CP000360.1\|	204669	g452964	i0	83.125	2.97014925373134	160	25	79	2	40	198	3651839	3651997	Candidatus Koribacter versatilis Ellin345, complete genome	blastn	597	145	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter versatilis
15350396	15350396	PRJEB30004_P_NODE_559493_length_176_cov_1.197080_g543866_i0	PRJEB30004	559493	176	1.19708	2.1068608	Paludibaculum fermentans	1473598	Bacteria	Bacteria	182	1.82e-41	NTclustered	gi\|1929489624\|gb\|CP063849.1\|	1473598	g543866	i0	86.585	72.4715909090909	164	22	93	0	12	175	2625018	2625181	Paludibaculum fermentans strain P105 chromosome, complete genome	blastn	12755	182	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae	Paludibaculum	Paludibaculum fermentans
16604034	16604034	PRJEB30004_P_NODE_107134_length_597_cov_24.971326_g92036_i0	PRJEB30004	107134	597	24.971326	149.07881622	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	760	0	NTclustered	gi\|389545836\|gb\|JQ400764.1\|	171953	g92036	i0	92.844	75.8860971524288	531	27	88	11	1	524	527	1	Uncultured Acidobacteria bacterium clone CNY_00655 16S ribosomal RNA gene, partial sequence	blastn	45304	760	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16629914	16629914	PRJEB30004_P_NODE_657694_length_155_cov_3.534483_g642067_i0	PRJEB30004	657694	155	3.534483	5.47844865	uncultured Candidatus Solibacter sp.	708629	Bacteria	Bacteria	139	9.51e-29	NTclustered	gi\|310755104\|gb\|HQ212994.1\|	708629	g642067	i0	84.783	1.74193548387097	138	21	89	0	1	138	1207	1070	Uncultured Candidatus Solibacter sp. clone 2_M07 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	270	139	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	uncultured Candidatus Solibacter sp.
19172221	19172221	PRJEB30004_P_NODE_527216_length_184_cov_1.413793_g511589_i0	PRJEB30004	527216	184	1.413793	2.60137912	Terriglobus roseus	392734	Bacteria	Bacteria	300	5.08e-77	NTclustered	gi\|1085637902\|emb\|LT629690.1\|	392734	g511589	i0	96.196	101.103260869565	184	5	100	2	1	184	4808202	4808383	Terriglobus roseus strain GAS232 genome assembly, chromosome: I	blastn	18603	300	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
20452414	20452414	PRJEB30004_P_NODE_628657_length_161_cov_1.344262_g613030_i0	PRJEB30004	628657	161	1.344262	2.16426182	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	137	3.59e-28	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g613030	i0	81.988	1	161	29	100	0	1	161	3629592	3629432	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	161	137	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
21390687	21390687	PRJEB30004_P_NODE_313777_length_272_cov_3.167382_g298150_i0	PRJEB30004	313777	272	3.167382	8.61527904	Bacteria	2	Bacteria	Bacteria	193	1.41e-44	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g298150	i0	87.425	63.7279411764706	167	21	61	0	39	205	30170	30336	Uncultured Acidobacteria bacterium clone 46h5 hypothetical protein, putative O-linked GlcNAc transferase, putative two-component response regulator, hypothetical protein, putative penicillin-resistance DD-carboxypeptidase, putative glycosyl transferase, hypothetical protein, conserved hypothetical protein, hypothetical protein, putative MaoC family dehydratase, putative D-3-phosphoglycerate dehydrogenase, putative magnesium and cobalt transport protein, putative phosphatidyl-glycerophosphatase, putative 2-methylthioadenine synthetase, hypothetical protein, putative glutamine cyclotransferase, and hypothetical protein genes, complete cds; 5S ribosomal RNA, 23S ribosomal RNA, tRNA-Ala, tRNA-Met, tRNA-Ile, and 16S ribosomal RNA genes, complete sequence; and hypothetical protein genes, complete cds	blastn	17334	193	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24255306	24255306	PRJEB30004_P_NODE_160820_length_444_cov_1.962963_g145231_i0	PRJEB30004	160820	444	1.962963	8.71555572	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	479	1.6599999999999993e-130	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g145231	i0	86.13	44.5968468468468	447	58	99	4	1	443	3557646	3558092	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	19801	479	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
24266247	24266247	PRJEB30004_P_NODE_396720_length_228_cov_2.142857_g381093_i0	PRJEB30004	396720	228	2.142857	4.88571396	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	228	3.1499999999999988e-55	NTclustered	gi\|1958098837\|gb\|CP065005.1\|	1978231	g381093	i0	85.153	280.504385964912	229	27	99	7	4	228	4649884	4650109	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome	blastn	63955	228	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
25214671	25214671	PRJEB30004_P_NODE_343860_length_254_cov_3.632558_g328233_i0	PRJEB30004	343860	254	3.632558	9.22669732	Bacteria	2	Bacteria	Bacteria	200	7.78e-47	NTclustered	gi\|2874253677\|emb\|OY969111.1\|	171953	g328233	i0	84.135	239.511811023622	208	32	82	1	1	208	712800	712594	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.3 genome assembly, chromosome: 1	blastn	60836	200	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured 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);;