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

11 rows where analysis = "blastn", bioproject = "PRJNA526367" 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
496316	496316	PRJNA526367_P_NODE_57581_length_161_cov_2.375000_g57371_i0	PRJNA526367	57581	161	2.375	3.82375	uncultured Acidobacteriaceae bacterium	194844	Bacteria	Bacteria	132	1.6700000000000002e-26	NTclustered	gi\|2874254114\|emb\|OY970199.1\|	194844	g57371	i0	83.217	0.88819875776397506	143	24	89	0	15	157	3310862	3311004	MAG: uncultured Acidobacteriaceae bacterium isolate MFD04463.bin.1.15 genome assembly, chromosome: 1	blastn	143	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
3047068	3047068	PRJNA526367_P_NODE_44943_length_174_cov_7.760000_g44733_i0	PRJNA526367	44943	174	7.76	13.5024	Terriglobus roseus	392734	Bacteria	Bacteria	259	8.04e-65	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g44733	i0	93.642	26.235632183908	173	11	99	0	2	174	927073	926901	Terriglobus roseus DSM 18391, complete genome	blastn	4565	259	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
6873889	6873889	PRJNA526367_P_NODE_51306_length_166_cov_3.179487_g51096_i0	PRJNA526367	51306	166	3.179487	5.27794842	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	78.7	2.29e-10	NTclustered	gi\|112980875\|gb\|DQ829679.1\|	171953	g51096	i0	94.118	8.06024096385542	51	3	31	0	42	92	439	389	Uncultured Acidobacteria bacterium clone DON5 23S ribosomal RNA gene, partial sequence	blastn	1338	78.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9424253	9424253	PRJNA526367_P_NODE_41548_length_180_cov_4.343511_g41338_i0	PRJNA526367	41548	180	4.343511	7.8183198	Geothrix oryzae	2927975	Bacteria	Bacteria	259	8.38e-65	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g41338	i0	93.678	0.966666666666667	174	10	96	1	5	177	1798700	1798873	Geothrix oryzae Red222 DNA, complete genome	blastn	174	259	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
9424549	9424549	PRJNA526367_P_NODE_61688_length_156_cov_3.121495_g61478_i0	PRJNA526367	61688	156	3.121495	4.8695322	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	104	3.5e-18	NTclustered	gi\|76574293\|gb\|DQ139441.1\|	171953	g61478	i0	83.929	8.8525641025641	112	15	71	3	25	135	1393	1502	Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence	blastn	1381	104	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10700195	10700195	PRJNA526367_P_NODE_54809_length_163_cov_4.938596_g54599_i0	PRJNA526367	54809	163	4.938596	8.04991148	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	126	7.89e-25	NTclustered	gi\|2874253744\|emb\|OY969603.1\|	171953	g54599	i0	82.192	21.0552147239264	146	26	90	0	13	158	481805	481660	MAG: uncultured Acidobacteriota bacterium isolate MFD01476.bin.c.1 genome assembly, chromosome: 1	blastn	3432	126	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
13249743	13249743	PRJNA526367_P_NODE_29451_length_324_cov_1.614545_g29242_i0	PRJNA526367	29451	324	1.614545	5.2311258	Tunturiibacter empetritectus	3069691	Bacteria	Bacteria	75	6.5e-9	NTclustered	gi\|2750692779\|gb\|CP132932.1\|	3069691	g29242	i0	86.567	0.608024691358025	67	9	21	0	19	85	2043125	2043059	Tunturiibacter empetritectus strain M8UP23 chromosome	blastn	197	75	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Tunturiibacter	Tunturiibacter empetritectus
19621898	19621898	PRJNA526367_P_NODE_28396_length_324_cov_1.727273_g28187_i0	PRJNA526367	28396	324	1.727273	5.59636452	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	130	1.37e-25	NTclustered	gi\|112980863\|gb\|DQ829667.1\|	171953	g28187	i0	91.489	26.5895061728395	94	8	29	0	7	100	36	129	Uncultured Acidobacteria bacterium clone DON17 23S ribosomal RNA gene, partial sequence	blastn	8615	130	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23448803	23448803	PRJNA526367_P_NODE_8819_length_324_cov_3.905455_g8610_i0	PRJNA526367	8819	324	3.905455	12.6536742	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	167	1.0400000000000001e-36	NTclustered	gi\|217038899\|gb\|EU810989.1\|	171953	g8610	i0	96.97	26.6913580246914	99	3	31	0	226	324	118	20	Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence	blastn	8648	167	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
24721870	24721870	PRJNA526367_P_NODE_23100_length_324_cov_2.170909_g22891_i0	PRJNA526367	23100	324	2.170909	7.03374516	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	143	1.76e-29	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g22891	i0	94.565	4.09876543209877	92	5	28	0	9	100	634888	634797	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	1328	143	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
24722373	24722373	PRJNA526367_P_NODE_58560_length_160_cov_4.918919_g58350_i0	PRJNA526367	58560	160	4.918919	7.8702704	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	235	1.23e-57	NTclustered	gi\|117557517\|emb\|AM180906.2\|	171953	g58350	i0	94.737	195.85625	152	7	95	1	8	159	709	859	Uncultured Acidobacteria bacterium partial 23S rRNA gene, clone UD6 LS_LKC22_kan3	blastn	31337	235	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);;