metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA745553" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA745553" 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
724022	724022	PRJNA745553_S_NODE_13081_length_340_cov_3.936330_g12886_i0	PRJNA745553	13081	340	3.93633	13.383522	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	510	4.41e-140	NTclustered	gi\|2874253931\|emb\|OY970256.1\|	2283092	g12886	i0	94.578	311.444117647059	332	15	97	3	1	330	359718	360048	MAG: Pyrinomonadaceae bacterium isolate MFD09212.bin.c.2 genome assembly, chromosome: 1	blastn	105891	510	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
724268	724268	PRJNA745553_S_NODE_27321_length_237_cov_5.048780_g27126_i0	PRJNA745553	27321	237	5.04878	11.9656086	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	335	1.8899999999999996e-87	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g27126	i0	95.261	20.6751054852321	211	10	89	0	4	214	211	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	4900	335	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1198653	1198653	PRJNA745553_S_NODE_27961_length_233_cov_2.687500_g27766_i0	PRJNA745553	27961	233	2.6875	6.261875	Bacteria	2	Bacteria	Bacteria	278	3.16e-70	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g27766	i0	91.919	142.467811158798	198	16	85	0	14	211	2367458	2367655	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	33195	278	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3275345	3275345	PRJNA745553_S_NODE_11203_length_365_cov_5.037671_g11008_i0	PRJNA745553	11203	365	5.037671	18.38749915	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	521	2.2e-143	NTclustered	gi\|217038896\|gb\|EU810986.1\|	171953	g11008	i0	96.238	548.249315068493	319	11	87	1	8	325	319	1	Uncultured Acidobacteria bacterium clone 01QD6 23S ribosomal RNA gene, partial sequence	blastn	200111	521	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3275449	3275449	PRJNA745553_S_NODE_17023_length_299_cov_3.575221_g16828_i0	PRJNA745553	17023	299	3.575221	10.68991079	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	470	6.48e-128	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g16828	i0	96.491	86.505016722408	285	8	95	1	1	283	285	1	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	25865	470	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3750436	3750436	PRJNA745553_S_NODE_30383_length_202_cov_7.829457_g30188_i0	PRJNA745553	30383	202	7.829457	15.81550314	Cyanobacteriota/Melainabacteria group	1798711	Bacteria	Bacteria	217	5.89e-52	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g30188	i0	88.333	32.9158415841584	180	21	89	0	23	202	1	180	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	6649	217	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4552625	4552625	PRJNA745553_S_NODE_16004_length_308_cov_4.825532_g15809_i0	PRJNA745553	16004	308	4.825532	14.86263856	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	171	7.61e-38	NTclustered	gi\|112980870\|gb\|DQ829674.1\|	171953	g15809	i0	85.714	69.5227272727273	168	17	53	7	140	303	432	596	Uncultured Acidobacteria bacterium clone DON24 23S ribosomal RNA gene, partial sequence	blastn	21413	171	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4552820	4552820	PRJNA745553_S_NODE_28344_length_230_cov_4.464968_g28149_i0	PRJNA745553	28344	230	4.464968	10.2694264	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	274	4.03e-69	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g28149	i0	91.457	83.8695652173913	199	17	87	0	22	220	2367656	2367458	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	19290	274	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5026935	5026935	PRJNA745553_S_NODE_28444_length_229_cov_6.698718_g28249_i0	PRJNA745553	28444	229	6.698718	15.34006422	Bacteria	2	Bacteria	Bacteria	204	5.33e-48	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g28249	i0	85.222	125.938864628821	203	25	86	3	22	219	2368500	2368298	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	28840	204	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
5026941	5026941	PRJNA745553_S_NODE_29424_length_219_cov_5.938356_g29229_i0	PRJNA745553	29424	219	5.938356	13.00499964	Acidobacteriaceae	204434	Bacteria	Bacteria	348	2.21e-91	NTclustered	gi\|470487846\|ref\|NR_076839.1\|	940615	g29229	i0	98.477	123.424657534247	197	3	90	0	23	219	2638	2834	Granulicella tundricola strain MP5ACTX9 23S ribosomal RNA gene, complete sequence	blastn	27030	348	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Granulicella	Granulicella tundricola
5827790	5827790	PRJNA745553_S_NODE_20105_length_275_cov_61.143564_g19910_i0	PRJNA745553	20105	275	61.143564	168.144801	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	224	5.059999999999999e-54	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g19910	i0	84.483	44.3054545454545	232	31	84	5	23	253	4233745	4233972	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	12184	224	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7102814	7102814	PRJNA745553_S_NODE_16506_length_304_cov_1.640693_g16311_i0	PRJNA745553	16506	304	1.640693	4.98770672	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	104	7.71e-18	NTclustered	gi\|2893356059\|emb\|OZ220482.1\|	2651171	g16311	i0	86.957	5.20065789473684	92	12	30	0	189	280	131333	131242	MAG: Thermoanaerobaculia bacterium isolate 1ba308f5-42e2-4878-81ff-2dc7ade272f8 genome assembly, chromosome: 1	blastn	1581	104	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
8377512	8377512	PRJNA745553_S_NODE_19707_length_278_cov_17.419512_g19512_i0	PRJNA745553	19707	278	17.419512	48.42624336	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	265	3.02e-66	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g19512	i0	87.446	83.5575539568345	231	27	83	2	25	254	4233745	4233974	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	23229	265	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8377681	8377681	PRJNA745553_S_NODE_29427_length_219_cov_5.773973_g29232_i0	PRJNA745553	29427	219	5.773973	12.64500087	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	263	8.22e-66	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g29232	i0	88.341	119.831050228311	223	21	100	5	1	219	4233966	4233745	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	26243	263	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8851734	8851734	PRJNA745553_S_NODE_30007_length_209_cov_6.573529_g29812_i0	PRJNA745553	30007	209	6.573529	13.73867561	Pseudomonadati	3379134	Bacteria	Bacteria	119	1.78e-22	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g29812	i0	80	98.8133971291866	175	23	81	12	20	189	3917555	3917722	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	20652	119	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12203612	12203612	PRJNA745553_S_NODE_18590_length_286_cov_4.699531_g18395_i0	PRJNA745553	18590	286	4.699531	13.44065866	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	91.6	5.6e-14	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g18395	i0	84.946	0.832167832167832	93	10	31	4	16	105	2713674	2713765	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	238	91.6	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12203708	12203708	PRJNA745553_S_NODE_24190_length_251_cov_4.466292_g23995_i0	PRJNA745553	24190	251	4.466292	11.21039292	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	357	4.3e-94	NTclustered	gi\|2874254108\|emb\|OY970193.1\|	171953	g23995	i0	96.729	100.597609561753	214	7	85	0	15	228	1690611	1690824	MAG: uncultured Acidobacteriota bacterium isolate MFD09206.bin.1.42 genome assembly, chromosome: 1	blastn	25250	357	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
12203804	12203804	PRJNA745553_S_NODE_29690_length_214_cov_9.092199_g29495_i0	PRJNA745553	29690	214	9.092199	19.45730586	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	276	1.03e-69	NTclustered	gi\|112980874\|gb\|DQ829678.1\|	171953	g29495	i0	91.133	91.1728971962617	203	18	95	0	1	203	216	14	Uncultured Acidobacteria bacterium clone DON4 23S ribosomal RNA gene, partial sequence	blastn	19511	276	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
16027029	16027029	PRJNA745553_S_NODE_6973_length_447_cov_13.029412_g6779_i0	PRJNA745553	6973	447	13.029412	58.24147164	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	754	0	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g6779	i0	98.152	199.395973154362	433	6	96	1	1	431	3300606	3301038	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	89130	754	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17302218	17302218	PRJNA745553_S_NODE_17234_length_297_cov_7.107143_g17039_i0	PRJNA745553	17234	297	7.107143	21.10821471	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	274	5.41e-69	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g17039	i0	91.837	21.3703703703704	196	16	66	0	23	218	3298163	3298358	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	6347	274	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
17776451	17776451	PRJNA745553_S_NODE_514_length_926_cov_8.479484_g430_i0	PRJNA745553	514	926	8.479484	78.52002184	Bacteria	2	Bacteria	Bacteria	1081	0	NTclustered	gi\|2621707050\|emb\|OY764903.1\|	2212468	g430	i0	89.001	108.7343412527	891	74	94	14	50	917	3557930	3558819	MAG: Bryobacteraceae bacterium isolate d7944118-f527-4ba8-a886-cdd3ae4bc3f8 genome assembly, chromosome: 1	blastn	100688	1081	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales	Bryobacteraceae		Bryobacteraceae bacterium
18576027	18576027	PRJNA745553_S_NODE_30695_length_196_cov_8.967480_g30500_i0	PRJNA745553	30695	196	8.96748	17.5762608	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	267	5.5599999999999996e-67	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g30500	i0	96.296	246.918367346939	162	6	83	0	10	171	3299031	3299192	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	48396	267	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
19050468	19050468	PRJNA745553_S_NODE_3035_length_586_cov_21.124756_g2852_i0	PRJNA745553	3035	586	21.124756	123.79107016	Bacteria	2	Bacteria	Bacteria	704	0	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g2852	i0	91.154	727.761092150171	520	44	88	2	58	575	4233453	4233972	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	426468	704	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19851107	19851107	PRJNA745553_S_NODE_14916_length_319_cov_1.878049_g14721_i0	PRJNA745553	14916	319	1.878049	5.99097631	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	418	2.559999999999999e-112	NTclustered	gi\|31789464\|gb\|AY281356.1\|	171953	g14721	i0	91.946	174.100313479624	298	24	93	0	22	319	12163	11866	Uncultured Acidobacteria bacterium clone 41b15 genomic sequence	blastn	55538	418	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
23677333	23677333	PRJNA745553_S_NODE_29419_length_219_cov_6.541096_g29224_i0	PRJNA745553	29419	219	6.541096	14.32500024	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	246	8.28e-61	NTclustered	gi\|1958093598\|gb\|CP065003.1\|	1978231	g29224	i0	89.109	64.8036529680365	202	17	91	5	1	199	317451	317252	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.185_cln chromosome, complete genome	blastn	14192	246	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
24950828	24950828	PRJNA745553_S_NODE_28720_length_227_cov_7.500000_g28525_i0	PRJNA745553	28720	227	7.5	17.025	Holophagales bacterium	2478486	Bacteria	Bacteria	189	1.4799999999999996e-43	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g28525	i0	83.333	30.5594713656388	204	34	90	0	1	204	1452958	1452755	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	6937	189	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales 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);;