metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA773247" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
748771	748771	PRJNA773247_P_NODE_16461_length_361_cov_5.597222_g16377_i0	PRJNA773247	16461	361	5.597222	20.20597142	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	143	1.97e-29	NTclustered	gi\|2621706021\|emb\|OY764083.1\|	1978231	g16377	i0	83.766	2.80886426592798	154	21	42	4	111	262	1851521	1851370	MAG: Acidobacteriota bacterium isolate 715e7d27-e149-44c2-9d7f-aa5f8d263fc4 genome assembly, chromosome: 1	blastn	1014	143	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
748778	748778	PRJNA773247_P_NODE_16801_length_357_cov_2.091549_g16717_i0	PRJNA773247	16801	357	2.091549	7.46682993	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	265	3.99e-66	NTclustered	gi\|2874254056\|emb\|OY970380.1\|	2651171	g16717	i0	81.734	91.96918767507	323	54	90	5	7	327	1179901	1180220	MAG: Thermoanaerobaculia bacterium isolate MFD05537.bin.c.2 genome assembly, chromosome: 1	blastn	32833	265	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
748952	748952	PRJNA773247_P_NODE_29341_length_255_cov_2.258242_g29257_i0	PRJNA773247	29341	255	2.258242	5.7585171	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	372	1.57e-98	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g29257	i0	93.574	2.09019607843137	249	16	98	0	7	255	3987443	3987195	Geothrix sp. PMB-07 chromosome, complete genome	blastn	533	372	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
2024644	2024644	PRJNA773247_P_NODE_14122_length_399_cov_1.898773_g14038_i0	PRJNA773247	14122	399	1.898773	7.57610427	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.011	NTclustered	gi\|2874254139\|emb\|OY970224.1\|	171953	g14038	i0	100	0.0726817042606516	29	0	7	0	328	356	491392	491420	MAG: uncultured Acidobacteriota bacterium isolate MFD04967.bin.c.6 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3300187	3300187	PRJNA773247_P_NODE_35563_length_235_cov_5.308642_g35479_i0	PRJNA773247	35563	235	5.308642	12.4753087	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	357	3.9899999999999996e-94	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g35479	i0	94.043	3.10212765957447	235	14	100	0	1	235	3144460	3144226	Geothrix sp. PMB-07 chromosome, complete genome	blastn	729	357	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
4576923	4576923	PRJNA773247_P_NODE_11924_length_444_cov_10.819407_g11841_i0	PRJNA773247	11924	444	10.819407	48.03816708	Geothrix sp. 21YS21S-4	3068889	Bacteria	Bacteria	287	1.08e-72	NTclustered	gi\|2565867660\|gb\|CP132719.1\|	3068889	g11841	i0	78.781	87.3490990990991	443	83	98	10	1	437	221831	221394	Geothrix sp. 21YS21S-4 chromosome, complete genome	blastn	38783	287	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. 21YS21S-4
7127695	7127695	PRJNA773247_P_NODE_3226_length_1074_cov_2.685315_g3165_i0	PRJNA773247	3226	1074	2.685315	28.8402831	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	355	7.43e-93	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g3165	i0	81.364	40.4981378026071	440	78	41	4	484	920	1653409	1652971	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	43495	355	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
7585010	7585010	PRJNA773247_P_NODE_11986_length_443_cov_3.127027_g11903_i0	PRJNA773247	11986	443	3.127027	13.85272961	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	1.98e-5	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g11903	i0	97.297	0.553047404063205	37	1	8	0	227	263	1870297	1870333	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	245	63.9	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium
8401976	8401976	PRJNA773247_P_NODE_18407_length_337_cov_17.719697_g18323_i0	PRJNA773247	18407	337	17.719697	59.71537889	Holophagales bacterium	2478486	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|1958024485\|gb\|CP064972.1\|	2478486	g18323	i0	100	0.086053412462908	29	0	9	0	101	129	4206351	4206323	Holophagales bacterium isolate EsbW_18-Q3-R4-48_BAT3C.4_cln chromosome, complete genome	blastn	29	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales			Holophagales bacterium
8402103	8402103	PRJNA773247_P_NODE_26587_length_270_cov_4.340102_g26503_i0	PRJNA773247	26587	270	4.340102	11.7182754	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	246	1.06e-60	NTclustered	gi\|2874254091\|emb\|OY970174.1\|	171953	g26503	i0	85.477	47.2296296296296	241	29	88	5	3	239	2969382	2969620	MAG: uncultured Acidobacteriota bacterium isolate MFD01275.bin.c.18 genome assembly, chromosome: 1	blastn	12752	246	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9677580	9677580	PRJNA773247_P_NODE_6388_length_676_cov_8.787728_g6306_i0	PRJNA773247	6388	676	8.787728	59.40504128	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	110	3.94e-19	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g6306	i0	85.577	1.12278106508876	104	15	15	0	364	467	4138867	4138970	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	759	110	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
10952816	10952816	PRJNA773247_P_NODE_14049_length_400_cov_4.391437_g13965_i0	PRJNA773247	14049	400	4.391437	17.565748	Pyrinomonadaceae bacterium	2283092	Bacteria	Bacteria	58.4	8.24e-4	NTclustered	gi\|2874254159\|emb\|OY970389.1\|	2283092	g13965	i0	97.059	0.245	34	1	9	0	240	273	3663263	3663296	MAG: Pyrinomonadaceae bacterium isolate MFD09206.bin.c.1 genome assembly, chromosome: 1	blastn	98	58.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Blastocatellia	Blastocatellales	Pyrinomonadaceae		Pyrinomonadaceae bacterium
12228529	12228529	PRJNA773247_P_NODE_21630_length_305_cov_9.737069_g21546_i0	PRJNA773247	21630	305	9.737069	29.69806045	Bryobacterales bacterium F-183	2802972	Bacteria	Bacteria	252	2.61e-62	NTclustered	gi\|2131941663\|dbj\|AP025252.1\|	2802972	g21546	i0	83.835	0.872131147540984	266	41	87	2	12	276	594024	594288	Bryobacterales bacterium F-183 DNA, nearly complete genome	blastn	266	252	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium F-183
17327271	17327271	PRJNA773247_P_NODE_28214_length_261_cov_3.308511_g28130_i0	PRJNA773247	28214	261	3.308511	8.63521371	Vicinamibacteria bacterium	2793154	Bacteria	Bacteria	171	6.3e-38	NTclustered	gi\|2575803519\|emb\|OY729431.1\|	2793154	g28130	i0	85.89	20.1954022988506	163	19	62	4	48	208	1920085	1919925	MAG: Vicinamibacteria bacterium isolate 6b1ebb23-bf14-4213-9fd5-2478dc99539b genome assembly, chromosome: 1	blastn	5271	171	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria				Vicinamibacteria bacterium
17327287	17327287	PRJNA773247_P_NODE_29294_length_255_cov_4.758242_g29210_i0	PRJNA773247	29294	255	4.758242	12.1335171	Geothrix sp. PMB-07	3068640	Bacteria	Bacteria	359	1.22e-94	NTclustered	gi\|2563347696\|gb\|CP132333.1\|	3068640	g29210	i0	94.421	0.913725490196078	233	13	91	0	11	243	2581802	2582034	Geothrix sp. PMB-07 chromosome, complete genome	blastn	233	359	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix sp. PMB-07
18600959	18600959	PRJNA773247_P_NODE_9555_length_513_cov_3.345455_g9472_i0	PRJNA773247	9555	513	3.345455	17.16218415	Bryobacterales bacterium	2026791	Bacteria	Bacteria	180	2.21e-40	NTclustered	gi\|2874254061\|emb\|OY970385.1\|	2026791	g9472	i0	79.771	27.8986354775828	262	41	50	12	259	513	634685	634429	MAG: Bryobacterales bacterium isolate MFD03726.bin.c.1 genome assembly, chromosome: 1	blastn	14312	180	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Bryobacterales			Bryobacterales bacterium
22426371	22426371	PRJNA773247_P_NODE_3898_length_950_cov_2.480046_g3829_i0	PRJNA773247	3898	950	2.480046	23.560437	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	715	0	NTclustered	gi\|2874253854\|emb\|OY969910.1\|	171953	g3829	i0	80.911	1.79052631578947	922	162	96	13	3	917	214518	213604	MAG: uncultured Acidobacteriota bacterium isolate MFD01213.bin.1.136 genome assembly, chromosome: 1	blastn	1701	715	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);;