metadata: contig_metadata: 12 rows where bioproject = "PRJNA879221" and tax

12 rows where bioproject = "PRJNA879221" and tax_phylum = "Aquificota"

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_species
857192	857192	PRJNA879221_P_NODE_50061_length_249_cov_0.875000_g49921_i0	PRJNA879221	50061	249	0.875	2.17875	Aquificota bacterium	2202151	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g49921	i0	98.4	1.00401606425703	250	3	100	1	1	249	1653815	1653566	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	250	438	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
4685220	4685220	PRJNA879221_P_NODE_26224_length_344_cov_3.549815_g26084_i0	PRJNA879221	26224	344	3.549815	12.2113636	Aquificota bacterium	2202151	Bacteria	Bacteria	560	4.3700000000000005e-155	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g26084	i0	97.846	0.944767441860465	325	6	94	1	1	324	1170447	1170123	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	325	560	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
4685268	4685268	PRJNA879221_P_NODE_29924_length_322_cov_1.855422_g29784_i0	PRJNA879221	29924	322	1.855422	5.97445884	Aquificota bacterium	2202151	Bacteria	Bacteria	351	2.66e-92	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g29784	i0	90.566	1.17391304347826	265	25	82	0	26	290	1711126	1710862	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	378	351	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
5960336	5960336	PRJNA879221_P_NODE_44445_length_256_cov_1.683060_g44305_i0	PRJNA879221	44445	256	1.68306	4.3086336	Aquificota bacterium	2202151	Bacteria	Bacteria	372	1.57e-98	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g44305	i0	94.286	0.95703125	245	11	95	3	1	243	1082224	1081981	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	245	372	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
7235016	7235016	PRJNA879221_P_NODE_25326_length_350_cov_4.628159_g25186_i0	PRJNA879221	25326	350	4.628159	16.1985565	Aquificota bacterium	2202151	Bacteria	Bacteria	547	3.46e-151	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g25186	i0	97.792	0.905714285714286	317	7	91	0	32	348	480434	480750	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	317	547	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
8509825	8509825	PRJNA879221_P_NODE_31647_length_313_cov_1.925000_g31507_i0	PRJNA879221	31647	313	1.925	6.02525	Aquificota bacterium	2202151	Bacteria	Bacteria	484	2.4399999999999998e-132	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g31507	i0	97.535	0.907348242811502	284	5	90	2	1	282	1296937	1297220	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	284	484	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
9784478	9784478	PRJNA879221_P_NODE_10928_length_552_cov_6.941545_g10790_i0	PRJNA879221	10928	552	6.941545	38.3173284	Aquificota bacterium	2202151	Bacteria	Bacteria	488	3.4899999999999995e-133	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g10790	i0	84.171	9.53260869565217	537	50	94	26	1	521	1448909	1449426	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	5262	488	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
11060557	11060557	PRJNA879221_P_NODE_31129_length_316_cov_1.267490_g30989_i0	PRJNA879221	31129	316	1.26749	4.0052684	Aquificota bacterium	2202151	Bacteria	Bacteria	484	2.4599999999999994e-132	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g30989	i0	96.575	1.62658227848101	292	10	92	0	25	316	1097118	1097409	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	514	484	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
16159538	16159538	PRJNA879221_P_NODE_26633_length_342_cov_1.133829_g26493_i0	PRJNA879221	26633	342	1.133829	3.87769518	Aquificota bacterium	2202151	Bacteria	Bacteria	542	1.57e-149	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g26493	i0	98.077	0.912280701754386	312	5	91	1	32	342	1713973	1714284	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	312	542	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
17434926	17434926	PRJNA879221_P_NODE_18114_length_418_cov_1.228986_g17975_i0	PRJNA879221	18114	418	1.228986	5.13716148	Aquificota bacterium	2202151	Bacteria	Bacteria	617	3.16e-172	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g17975	i0	96.524	21.444976076555	374	11	89	2	15	387	360399	360771	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	8964	617	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
23809371	23809371	PRJNA879221_P_NODE_53559_length_247_cov_0.885057_g53419_i0	PRJNA879221	53559	247	0.885057	2.18609079	Aquificota bacterium	2202151	Bacteria	Bacteria	446	8.759999999999998e-121	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g53419	i0	99.194	1.00404858299595	248	1	100	1	1	247	1270322	1270075	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	248	446	1	Bacteria	Pseudomonadati	Aquificota	Aquificota bacterium
25082867	25082867	PRJNA879221_P_NODE_23260_length_365_cov_4.982877_g23120_i0	PRJNA879221	23260	365	4.982877	18.18750105	Aquificota bacterium	2202151	Bacteria	Bacteria	586	7.68e-163	NTclustered	gi\|2049899551\|gb\|CP076324.1\|	2202151	g23120	i0	97.654	1.12328767123288	341	8	93	0	1	341	1308607	1308947	MAG: Aquificota bacterium isolate RBS10-58 chromosome, complete genome	blastn	410	586	1	Bacteria	Pseudomonadati	Aquificota	Aquificota 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);;