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

11 rows where analysis = "blastn", bioproject = "PRJEB81327" 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
3965698	3965698	PRJEB81327_P_NODE_14324_length_356_cov_1.628975_g13716_i0	PRJEB81327	14324	356	1.628975	5.799151	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	628	1.2199999999999999e-175	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g13716	i0	98.592	309.426966292135	355	5	99	0	1	355	641493	641847	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	110156	628	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
5242443	5242443	PRJEB81327_P_NODE_37925_length_264_cov_3.303665_g37317_i0	PRJEB81327	37925	264	3.303665	8.7216756	Luteitalea pratensis	1855912	Bacteria	Bacteria	311	3.6e-80	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g37317	i0	87.879	6.53030303030303	264	32	100	0	1	264	3470593	3470856	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	1724	311	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
6517896	6517896	PRJEB81327_P_NODE_27626_length_283_cov_0.971429_g27018_i0	PRJEB81327	27626	283	0.971429	2.74914407	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	394	3.77e-105	NTclustered	gi\|76574296\|gb\|DQ139444.1\|	171953	g27018	i0	92.446	37.1554770318021	278	17	98	4	8	283	1680	1405	Uncultured Acidobacteria bacterium clone CAL5 23S ribosomal RNA gene, partial sequence	blastn	10515	394	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6518244	6518244	PRJEB81327_P_NODE_55246_length_246_cov_1.335260_g54638_i0	PRJEB81327	55246	246	1.33526	3.2847396	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	383	6.94e-102	NTclustered	gi\|76574294\|gb\|DQ139442.1\|	171953	g54638	i0	95.062	156.117886178862	243	12	99	0	4	246	1687	1929	Uncultured Acidobacteria bacterium clone CAL3 23S ribosomal RNA gene, partial sequence	blastn	38405	383	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9066802	9066802	PRJEB81327_P_NODE_10248_length_427_cov_1.189266_g9640_i0	PRJEB81327	10248	427	1.189266	5.07816582	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	730	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g9640	i0	97.658	219.276346604215	427	6	100	3	1	427	3299479	3299057	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	93631	730	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
10343150	10343150	PRJEB81327_P_NODE_62129_length_242_cov_2.562130_g61521_i0	PRJEB81327	62129	242	2.56213	6.2003546	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	204	5.69e-48	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g61521	i0	81.893	83.0123966942149	243	42	100	2	1	242	3227901	3228142	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	20089	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
11618190	11618190	PRJEB81327_P_NODE_21250_length_301_cov_1.013158_g20642_i0	PRJEB81327	21250	301	1.013158	3.04960558	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	353	6.86e-93	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g20642	i0	87.829	109.813953488372	304	34	100	3	1	301	4231998	4231695	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	33054	353	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12475707	12475707	PRJEB81327_P_NODE_15630_length_341_cov_2.682836_g15022_i0	PRJEB81327	15630	341	2.682836	9.14847076	Bacteria	2	Bacteria	Bacteria	202	3.0199999999999996e-47	NTclustered	gi\|1015624362\|gb\|AH012920.2\|	171953	g15022	i0	88.554	57.8211143695015	166	19	49	0	97	262	30170	30335	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	19717	202	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12893537	12893537	PRJEB81327_P_NODE_51871_length_248_cov_0.880000_g51263_i0	PRJEB81327	51871	248	0.88	2.1824	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	241	4.46e-59	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g51263	i0	84.553	1.37903225806452	246	34	98	4	1	244	924092	924335	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	342	241	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
14167933	14167933	PRJEB81327_P_NODE_13412_length_369_cov_1.297297_g12804_i0	PRJEB81327	13412	369	1.297297	4.78702593	Bryobacteraceae bacterium	2212468	Bacteria	Bacteria	335	3.109999999999999e-87	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g12804	i0	85.455	156.314363143631	330	38	88	7	1	325	3557869	3557545	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	57680	335	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
20540553	20540553	PRJEB81327_P_NODE_17997_length_319_cov_1.012195_g17389_i0	PRJEB81327	17997	319	1.012195	3.22890205	Bryobacterales bacterium	2026791	Bacteria	Bacteria	433	9.139999999999998e-117	NTclustered	gi\|2874253826\|emb\|OY969810.1\|	2026791	g17389	i0	91.456	101.366771159875	316	26	99	1	1	316	6660342	6660028	MAG: Bryobacterales bacterium isolate MFD04967.bin.c.1 genome assembly, chromosome: 1	blastn	32336	433	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales 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);;