metadata: contig_metadata: 8 rows where bioproject = "PRJNA1098727", tax_kingdom = "Pseudomonadati" and tax

8 rows where bioproject = "PRJNA1098727", tax_kingdom = "Pseudomonadati" 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
4847905	4847905	PRJNA1098727_P_NODE_6244_length_251_cov_2.138614_g6003_i0	PRJNA1098727	6244	251	2.138614	5.36792114	Bacteria	2	Bacteria	Bacteria	315	2.6299999999999998e-81	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g6003	i0	92	158.521912350598	225	16	89	2	27	250	11855	12078	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	39789	315	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13773171	13773171	PRJNA1098727_P_NODE_11251_length_180_cov_1.641221_g11010_i0	PRJNA1098727	11251	180	1.641221	2.9541978	Acidobacterium	33973	Bacteria	Bacteria	326	8.15e-85	NTclustered	gi\|470484216\|ref\|NR_076636.1\|	33075	g11010	i0	99.441	83.9166666666667	179	1	99	0	1	179	2870	2692	Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence	blastn	15105	326	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
19336904	19336904	PRJNA1098727_P_NODE_4696_length_299_cov_1.712000_g4455_i0	PRJNA1098727	4696	299	1.712	5.11888	Acidobacteriaceae bacterium ZG23-2	2883246	Bacteria	Bacteria	422	1.84e-113	NTclustered	gi\|2221425918\|gb\|CP085323.1\|	2883246	g4455	i0	92.027	233.926421404682	301	22	100	2	1	299	1430524	1430224	Acidobacteriaceae bacterium ZG23-2 chromosome, complete genome	blastn	69944	422	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		Acidobacteriaceae bacterium ZG23-2
20612320	20612320	PRJNA1098727_P_NODE_8257_length_214_cov_1.703030_g8016_i0	PRJNA1098727	8257	214	1.70303	3.6444842	Terriglobus roseus	392734	Bacteria	Bacteria	387	4.55e-103	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g8016	i0	99.531	135.855140186916	213	0	99	1	2	213	927212	927000	Terriglobus roseus DSM 18391, complete genome	blastn	29073	387	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
25246176	25246176	PRJNA1098727_P_NODE_6640_length_242_cov_2.005181_g6399_i0	PRJNA1098727	6640	242	2.005181	4.85253802	Acidobacterium	33973	Bacteria	Bacteria	416	6.709999999999999e-112	NTclustered	gi\|470484216\|ref\|NR_076636.1\|	33075	g6399	i0	97.917	105.454545454545	240	5	99	0	3	242	738	499	Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence	blastn	25520	416	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
28046758	28046758	PRJNA1098727_P_NODE_12765_length_169_cov_0.866667_g12524_i0	PRJNA1098727	12765	169	0.866667	1.46466723	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	96.3	1.59e-21	NR	MCL4817668.1	2793154	g12524	i0	85.5	0.976331360946746	55	8	97.6	0	167	3	106	160	MCL4817668.1 AMP-binding protein [Vicinamibacteria bacterium]	diamond	165	96.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
28299306	28299306	PRJNA1098727_P_NODE_3506_length_357_cov_2.840909_g3265_i0	PRJNA1098727	3506	357	2.840909	10.14204513	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	44.3	0.0357	NR	HWW88845.1	2910147	g3265	i0	31.2	1.05042016806723	125	58	82.4	5	5	298	27	150	HWW88845.1 isoprenylcysteine carboxylmethyltransferase family protein [Vicinamibacterales bacterium]	diamond	375	44.3	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales bacterium
28899096	28899096	PRJNA1098727_P_NODE_15928_length_162_cov_0.876106_g15687_i0	PRJNA1098727	15928	162	0.876106	1.41929172	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	84.7	1.93e-17	NR	HEY6547531.1	2793154	g15687	i0	67.9	1.96296296296296	53	17	98.1	0	3	161	363	415	HEY6547531.1 TonB-dependent siderophore receptor [Vicinamibacteria bacterium]	diamond	318	84.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria 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);;