metadata: contig_metadata: 13 rows where bioproject = "PRJNA495917" and tax

13 rows where bioproject = "PRJNA495917" 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
3659089	3659089	PRJNA495917_S_NODE_3403_length_265_cov_15.665217_g3209_i0	PRJNA495917	3403	265	15.665217	41.512825049999996	Bacteria	2	Bacteria	Bacteria	457	4.39e-124	NTclustered	gi\|218533824\|gb\|FJ490338.1\|	171953	g3209	i0	97.736	99.3849056603774	265	6	100	0	1	265	269	5	Uncultured Acidobacteria bacterium clone H_18 16S ribosomal RNA gene, partial sequence	blastn	26337	457	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4304291	4304291	PRJNA495917_S_NODE_1084_length_454_cov_96.167064_g892_i0	PRJNA495917	1084	454	96.167064	436.59847056	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	542	2.14e-149	NTclustered	gi\|105990458\|gb\|DQ514189.1\|	171953	g892	i0	96.914	73.9030837004405	324	9	71	1	131	454	893	571	Uncultured Acidobacteria bacterium clone 500M2_F6 16S ribosomal RNA gene, partial sequence	blastn	33552	542	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6855036	6855036	PRJNA495917_S_NODE_1046_length_463_cov_24.282710_g854_i0	PRJNA495917	1046	463	24.28271	112.4289473	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	510	6.17e-140	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g854	i0	94.562	303.980561555076	331	17	71	1	1	330	332	2	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	140743	510	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
6855097	6855097	PRJNA495917_S_NODE_14406_length_156_cov_2.793388_g14212_i0	PRJNA495917	14406	156	2.793388	4.35768528	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	93.5	7.57e-15	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g14212	i0	83.654	27.3397435897436	104	11	64	5	43	142	1523757	1523656	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	4265	93.5	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
9405451	9405451	PRJNA495917_S_NODE_1768_length_361_cov_136.496933_g1574_i0	PRJNA495917	1768	361	136.496933	492.75392813	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	569	7.639999999999997e-158	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g1574	i0	96	137.537396121884	350	14	97	0	12	361	3301046	3300697	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	49651	569	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
11310966	11310966	PRJNA495917_S_NODE_10209_length_173_cov_5.797101_g10015_i0	PRJNA495917	10209	173	5.797101	10.02898473	Bacteria	2	Bacteria	Bacteria	143	8.38e-30	NTclustered	gi\|2874253885\|emb\|OY970060.1\|	171953	g10015	i0	95.506	8.67630057803468	89	4	51	0	1	89	4841884	4841796	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1	blastn	1501	143	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
22153996	22153996	PRJNA495917_S_NODE_1078_length_456_cov_33.163895_g886_i0	PRJNA495917	1078	456	33.163895	151.2273612	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	577	5.899999999999998e-160	NTclustered	gi\|217038907\|gb\|EU810998.1\|	171953	g886	i0	97.898	365.75	333	7	73	0	1	333	333	1	Uncultured Acidobacteria bacterium clone 01QCK 23S ribosomal RNA gene, partial sequence	blastn	166782	577	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24703547	24703547	PRJNA495917_S_NODE_760_length_534_cov_20.775551_g583_i0	PRJNA495917	760	534	20.775551	110.94144234	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	797	0	NTclustered	gi\|2874253710\|emb\|OY969475.1\|	2283092	g583	i0	93.645	105.715355805243	535	31	100	3	1	534	1821532	1822064	MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1	blastn	56452	797	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
28151038	28151038	PRJNA495917_S_NODE_12265_length_164_cov_1.240310_g12071_i0	PRJNA495917	12265	164	1.24031	2.0341084	Terriglobales bacterium	2282142	Bacteria	Bacteria	78.6	1.9e-15	NR	HMB82632.1	2282142	g12071	i0	79.6	0.98780487804878	54	10	98.8	1	163	2	280	332	HMB82632.1 IS110 family transposase [Terriglobales bacterium]	diamond	162	78.6	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales			Terriglobales bacterium
28403457	28403457	PRJNA495917_S_NODE_5926_length_210_cov_1.828571_g5732_i0	PRJNA495917	5926	210	1.828571	3.8399991	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	77.4	2.25e-16	NR	MEJ7849682.1	2283092	g5732	i0	58	1.94285714285714	69	29	98.6	0	207	1	29	97	MEJ7849682.1 hypothetical protein [Pyrinomonadaceae bacterium]	diamond	408	77.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
29287402	29287402	PRJNA495917_S_NODE_12469_length_163_cov_1.343750_g12275_i0	PRJNA495917	12469	163	1.34375	2.1903125	Geothrix sp.	1962974	Bacteria	Bacteria	43.1	0.00226	NR	WP_291272256.1	1962974	g12275	i0	46.7	1.67484662576687	45	24	82.8	0	161	27	55	99	WP_291272256.1 hypothetical protein [Geothrix sp.]	diamond	273	43.1	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp.
29602904	29602904	PRJNA495917_S_NODE_11510_length_167_cov_1.765152_g11316_i0	PRJNA495917	11510	167	1.765152	2.94780384	Bryobacterales bacterium	2026791	Bacteria	Bacteria	105	2.29e-26	NR	MCU1262999.1	2026791	g11316	i0	94.5	0.988023952095808	55	3	98.8	0	1	165	164	218	MCU1262999.1 hypothetical protein [Bryobacterales bacterium]	diamond	165	105	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
31404350	31404350	PRJNA495917_S_NODE_9436_length_178_cov_1.398601_g9242_i0	PRJNA495917	9436	178	1.398601	2.48950978	Vicinamibacterales bacterium	2910147	Bacteria	Bacteria	47.4	3.35e-4	NR	HVQ12125.1	2910147	g9242	i0	56.8	0.623595505617977	37	16	62.4	0	112	2	2	38	HVQ12125.1 helix-turn-helix transcriptional regulator [Vicinamibacterales bacterium]	diamond	111	47.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales			Vicinamibacterales 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);;