metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA352850" and tax_clade = "Bacteria candidate phyla"

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_clade	tax_phylum	tax_class	tax_species
2946362	2946362	PRJNA352850_P_NODE_43903_length_374_cov_1.249231_g41070_i0	PRJNA352850	43903	374	1.249231	4.67212394	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	239	2.55e-58	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g41070	i0	79.251	0.927807486631016	347	68	92	4	8	352	825312	824968	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	347	239	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
5498752	5498752	PRJNA352850_P_NODE_25225_length_551_cov_2.013944_g22406_i0	PRJNA352850	25225	551	2.013944	11.09683144	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	307	1.05e-78	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g22406	i0	79.362	0.852994555353902	470	71	81	14	2	447	118125	118592	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	470	307	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
6773271	6773271	PRJNA352850_P_NODE_41926_length_387_cov_1.207101_g39094_i0	PRJNA352850	41926	387	1.207101	4.67148087	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	270	9.37e-68	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g39094	i0	83.803	1.88113695090439	284	46	73	0	69	352	712582	712299	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	728	270	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
8048183	8048183	PRJNA352850_P_NODE_18347_length_692_cov_2.522551_g15626_i0	PRJNA352850	18347	692	2.522551	17.45605292	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	344	1.02e-89	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g15626	i0	76.727	1.86849710982659	666	126	94	25	1	649	855794	855141	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	1293	344	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
8048196	8048196	PRJNA352850_P_NODE_18827_length_679_cov_4.295238_g16094_i0	PRJNA352850	18827	679	4.295238	29.16466602	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	564	7.029999999999997e-156	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g16094	i0	82.029	107.870397643594	690	99	100	19	1	679	429588	428913	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	73244	564	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
8048235	8048235	PRJNA352850_P_NODE_20147_length_646_cov_2.021776_g17383_i0	PRJNA352850	20147	646	2.021776	13.06067296	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	459	3.2399999999999993e-124	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g17383	i0	79.821	1.70897832817337	669	104	99	16	1	644	612152	612814	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	1104	459	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
8049043	8049043	PRJNA352850_P_NODE_46447_length_359_cov_6.638710_g43614_i0	PRJNA352850	46447	359	6.63871	23.8329689	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	224	6.81e-54	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g43614	i0	83.203	1.44846796657382	256	32	70	7	52	303	593998	593750	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	520	224	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
8049540	8049540	PRJNA352850_P_NODE_63207_length_289_cov_1.275000_g60374_i0	PRJNA352850	63207	289	1.275	3.68475	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	425	1.37e-114	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g60374	i0	93.403	26.2906574394464	288	18	99	1	3	289	1249876	1250163	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	7598	425	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
8050112	8050112	PRJNA352850_P_NODE_82127_length_246_cov_1.035533_g79294_i0	PRJNA352850	82127	246	1.035533	2.54741118	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	285	2.01e-72	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g79294	i0	87.705	0.991869918699187	244	30	99	0	3	246	64144	64387	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	244	285	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
14423617	14423617	PRJNA352850_P_NODE_15632_length_779_cov_1.361644_g12999_i0	PRJNA352850	15632	779	1.361644	10.60720676	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	429	3.09e-115	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g12999	i0	80.56	0.732991014120667	571	100	73	10	8	572	548102	548667	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	571	429	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
14424024	14424024	PRJNA352850_P_NODE_28452_length_507_cov_1.781659_g25626_i0	PRJNA352850	28452	507	1.781659	9.03301113	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	375	2.5899999999999995e-99	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g25626	i0	82.327	37.2485207100592	447	65	87	11	67	507	615794	615356	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	18885	375	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
14424788	14424788	PRJNA352850_P_NODE_54192_length_322_cov_3.080586_g51359_i0	PRJNA352850	54192	322	3.080586	9.91948692	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	412	1.1999999999999999e-110	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g51359	i0	89.783	93.2981366459627	323	31	100	2	1	322	465966	465645	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	30042	412	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
14425230	14425230	PRJNA352850_P_NODE_67652_length_275_cov_1.353982_g64819_i0	PRJNA352850	67652	275	1.353982	3.7234505	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	195	3.97e-45	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g64819	i0	81.897	0.843636363636364	232	40	84	2	5	235	912678	912908	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	232	195	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium HOT-871
15699530	15699530	PRJNA352850_P_NODE_82133_length_246_cov_1.035533_g79300_i0	PRJNA352850	82133	246	1.035533	2.54741118	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	224	4.45e-54	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g79300	i0	83.197	1.99593495934959	244	41	99	0	1	244	28971	28728	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	491	224	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
16972195	16972195	PRJNA352850_P_NODE_15434_length_786_cov_3.158752_g12804_i0	PRJNA352850	15434	786	3.158752	24.82779072	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	490	1.4099999999999999e-133	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g12804	i0	79.424	2.21628498727735	729	123	91	19	33	751	546327	547038	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	1742	490	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
19520986	19520986	PRJNA352850_P_NODE_26496_length_533_cov_1.679752_g23673_i0	PRJNA352850	26496	533	1.679752	8.95307816	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	427	7.44e-115	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g23673	i0	81.308	31.5478424015009	535	93	99	5	4	533	446100	445568	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	16815	427	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
23348797	23348797	PRJNA352850_P_NODE_82779_length_245_cov_1.040816_g79946_i0	PRJNA352850	82779	245	1.040816	2.5499992	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	67.6	7.9e-7	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g79946	i0	79	0.408163265306122	100	19	40	2	28	126	479620	479718	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	100	67.6	1	Bacteria	Bacteria candidate phyla			Patescibacteria group bacterium
24620856	24620856	PRJNA352850_P_NODE_10580_length_1038_cov_2.612740_g8249_i0	PRJNA352850	10580	1038	2.61274	27.1202412	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	556	1.8299999999999998e-153	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g8249	i0	77.154	11.7360308285164	1068	174	97	47	29	1038	88912	89967	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	12182	556	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota		Candidatus Gracilibacteria bacterium 28_42_T64
24621201	24621201	PRJNA352850_P_NODE_21900_length_608_cov_5.534884_g19113_i0	PRJNA352850	21900	608	5.534884	33.65209472	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	187	1.5799999999999994e-42	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g19113	i0	77.742	0.509868421052632	310	65	51	4	280	587	929121	928814	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	310	187	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria 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);;