metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB39269" 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
57111	57111	PRJEB39269_P_NODE_66981_length_170_cov_2.854962_g66576_i0	PRJEB39269	66981	170	2.854962	4.8534354	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	82.4	1.81e-11	NTclustered	gi\|2621701418\|emb\|OY760136.1\|	2910147	g66576	i0	88.235	0.4	68	8	40	0	91	158	2242234	2242301	MAG: Vicinamibacterales bacterium isolate f9e760c9-8bbe-4e76-9a0a-40d6f1fb97b8 genome assembly, chromosome: 1	blastn	68	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
4817158	4817158	PRJEB39269_P_NODE_76984_length_161_cov_1.303279_g76579_i0	PRJEB39269	76984	161	1.303279	2.09827919	Granulicella	940557	Bacteria	Bacteria	291	2.6e-74	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g76579	i0	99.375	87.8571428571429	160	1	99	0	1	160	899	1058	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	14145	291	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
6435304	6435304	PRJEB39269_P_NODE_80446_length_158_cov_3.201681_g80041_i0	PRJEB39269	80446	158	3.2016810000000002	5.05865598	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	75	2.79e-9	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g80041	i0	87.692	0.854430379746835	65	6	41	2	10	73	5882962	5883025	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	135	75	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8984144	8984144	PRJEB39269_P_NODE_61768_length_176_cov_1.197080_g61363_i0	PRJEB39269	61768	176	1.19708	2.1068608	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	220	3.85e-53	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g61363	i0	89.205	98.8977272727273	176	19	100	0	1	176	2019934	2020109	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	17406	220	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8984166	8984166	PRJEB39269_P_NODE_72208_length_166_cov_0.874016_g71803_i0	PRJEB39269	72208	166	0.874016	1.45086656	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	243	7.69e-60	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g71803	i0	92.857	97.4096385542169	168	10	100	2	1	166	3558572	3558739	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	16170	243	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
10259817	10259817	PRJEB39269_P_NODE_25969_length_274_cov_1.234043_g25564_i0	PRJEB39269	25969	274	1.234043	3.38127782	uncultured Granulicella sp.	1241325	Bacteria	Bacteria	412	9.999999999999999e-111	NTclustered	gi\|2626255659\|emb\|OY843766.1\|	1241325	g25564	i0	95.057	139.226277372263	263	11	96	2	1	262	3196208	3195947	MAG: uncultured Granulicella sp. isolate e6d70442-04f8-4699-a368-e2225de37168 genome assembly, chromosome: 1	blastn	38148	412	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	uncultured Granulicella sp.
19182570	19182570	PRJEB39269_P_NODE_68596_length_169_cov_3.453846_g68191_i0	PRJEB39269	68596	169	3.453846	5.83699974	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	89.8	1.08e-13	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g68191	i0	93.333	0.355029585798817	60	4	36	0	91	150	290798	290857	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	60	89.8	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
23009096	23009096	PRJEB39269_P_NODE_28839_length_259_cov_1.118182_g28434_i0	PRJEB39269	28839	259	1.118182	2.89609138	Candidatus Korobacter versatilis	658062	Bacteria	Bacteria	230	1.0199999999999998e-55	NTclustered	gi\|94549081\|gb\|CP000360.1\|	204669	g28434	i0	83.673	0.945945945945946	245	38	94	2	1	244	985991	986234	Candidatus Koribacter versatilis Ellin345, complete genome	blastn	245	230	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Candidatus Korobacteraceae	Candidatus Korobacter	Candidatus Korobacter versatilis
23941586	23941586	PRJEB39269_P_NODE_78359_length_160_cov_0.925620_g77954_i0	PRJEB39269	78359	160	0.92562	1.480992	Candidatus Solibacter	332162	Bacteria	Bacteria	252	1.22e-62	NTclustered	gi\|470468228\|ref\|NR_076103.1\|	332163	g77954	i0	95.031	48.275	161	7	100	1	1	160	1751	1591	Candidatus Solibacter usitatus strain Ellin6076 23S ribosomal RNA gene, complete sequence	blastn	7724	252	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Solibacteraceae	Candidatus Solibacter	Candidatus Solibacter usitatus

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