metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA703759" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA703759" 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
684552	684552	PRJNA703759_P_NODE_38361_length_250_cov_1.491525_g37885_i0	PRJNA703759	38361	250	1.491525	3.7288125	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	165	2.79e-36	NTclustered	gi\|2621703956\|emb\|OY762911.1\|	2651171	g37885	i0	78.884	42.94	251	48	99	5	4	250	216679	216430	MAG: Thermoanaerobaculia bacterium isolate 14c23368-4dca-4d55-9b94-f295180eceef genome assembly, chromosome: 1	blastn	10735	165	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
1959978	1959978	PRJNA703759_P_NODE_14262_length_357_cov_1.316901_g13786_i0	PRJNA703759	14262	357	1.316901	4.70133657	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	302	3.0400000000000007e-77	NTclustered	gi\|2874253709\|emb\|OY969474.1\|	171953	g13786	i0	82.022	94.4789915966387	356	62	99	2	1	355	2311719	2312073	MAG: uncultured Acidobacteriota bacterium isolate MFD05747.bin.1.131 genome assembly, chromosome: 1	blastn	33729	302	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
1960714	1960714	PRJNA703759_P_NODE_45022_length_246_cov_0.901734_g44546_i0	PRJNA703759	45022	246	0.901734	2.21826564	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	219	2.07e-52	NTclustered	gi\|2874254049\|emb\|OY970373.1\|	171953	g44546	i0	84.071	72.6747967479675	226	36	92	0	1	226	4232993	4233218	MAG: uncultured Acidobacteriota bacterium isolate MFD09368.bin.c.1 genome assembly, chromosome: 1	blastn	17878	219	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
3235929	3235929	PRJNA703759_P_NODE_5663_length_612_cov_1.621521_g5189_i0	PRJNA703759	5663	612	1.621521	9.92370852	Terriglobus roseus	392734	Bacteria	Bacteria	1127	0	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g5189	i0	100	96.1486928104575	610	0	99	0	2	611	2077061	2077670	Terriglobus roseus DSM 18391, complete genome	blastn	58843	1127	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
5013241	5013241	PRJNA703759_P_NODE_35724_length_252_cov_1.301676_g35248_i0	PRJNA703759	35724	252	1.301676	3.28022352	Acidobacterium	33973	Bacteria	Bacteria	399	7.079999999999999e-107	NTclustered	gi\|470484216\|ref\|NR_076636.1\|	33075	g35248	i0	95.238	118.940476190476	252	12	100	0	1	252	2061	2312	Acidobacterium capsulatum strain 161 23S ribosomal RNA gene, complete sequence	blastn	29973	399	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Acidobacterium	Acidobacterium capsulatum
5788254	5788254	PRJNA703759_P_NODE_46465_length_245_cov_0.906977_g45989_i0	PRJNA703759	46465	245	0.906977	2.22209365	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	291	4.3000000000000005e-74	NTclustered	gi\|2874253692\|emb\|OY969418.1\|	171953	g45989	i0	88.115	1.11836734693878	244	29	99	0	1	244	3632723	3632480	MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1	blastn	274	291	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
8337564	8337564	PRJNA703759_P_NODE_30427_length_265_cov_1.651042_g29951_i0	PRJNA703759	30427	265	1.651042	4.3752613	Geothrix oryzae	2927975	Bacteria	Bacteria	82.4	3.09e-11	NTclustered	gi\|2490888707\|dbj\|AP027079.1\|	2927975	g29951	i0	92.857	18.8830188679245	56	4	21	0	1	56	3121818	3121763	Geothrix oryzae Red222 DNA, complete genome	blastn	5004	82.4	1	Bacteria	Pseudomonadati	Acidobacteriota	Holophagae	Holophagales	Holophagaceae	Geothrix	Geothrix oryzae
8337707	8337707	PRJNA703759_P_NODE_36467_length_252_cov_0.871508_g35991_i0	PRJNA703759	36467	252	0.871508	2.19620016	Thermoanaerobaculaceae bacterium	2699758	Bacteria	Bacteria	132	2.85e-26	NTclustered	gi\|2874254005\|emb\|OY970330.1\|	2699758	g35991	i0	79	0.793650793650794	200	36	78	6	20	216	1119179	1119375	MAG: Thermoanaerobaculaceae bacterium isolate MFD05537.bin.c.1 genome assembly, chromosome: 1	blastn	200	132	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae		Thermoanaerobaculaceae bacterium
10888929	10888929	PRJNA703759_P_NODE_50869_length_242_cov_0.923077_g50393_i0	PRJNA703759	50869	242	0.923077	2.23384634	Luteitalea pratensis	1855912	Bacteria	Bacteria	204	5.69e-48	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g50393	i0	82.231	9.05371900826446	242	37	99	6	4	242	4950920	4950682	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	2191	204	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
12163638	12163638	PRJNA703759_P_NODE_30250_length_266_cov_1.290155_g29774_i0	PRJNA703759	30250	266	1.290155	3.4318123	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	243	1.34e-59	NTclustered	gi\|2874254027\|emb\|OY970352.1\|	171953	g29774	i0	83.146	2.40977443609023	267	43	100	2	1	266	3846376	3846641	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.5 genome assembly, chromosome: 1	blastn	641	243	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
14713258	14713258	PRJNA703759_P_NODE_24992_length_285_cov_1.330189_g24516_i0	PRJNA703759	24992	285	1.330189	3.79103865	Luteitalea sp. TBR-22	2802971	Bacteria	Bacteria	141	5.46e-29	NTclustered	gi\|2131947417\|dbj\|AP024452.2\|	2802971	g24516	i0	89.655	15.0842105263158	116	4	39	6	174	285	4503411	4503522	Vicinamibacteria bacterium TBR-22 DNA, complete genome	blastn	4299	141	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea sp. TBR-22
18536024	18536024	PRJNA703759_P_NODE_24375_length_287_cov_1.457944_g23899_i0	PRJNA703759	24375	287	1.457944	4.18429928	Thermoanaerobaculia bacterium	2651171	Bacteria	Bacteria	233	8.829999999999999e-57	NTclustered	gi\|2621701942\|emb\|OY761158.1\|	2651171	g23899	i0	84.337	129.867595818815	249	28	84	10	1	242	3583509	3583753	MAG: Thermoanaerobaculia bacterium isolate 1b26a83f-5f0d-4c2c-8de2-47f95369405e genome assembly, chromosome: 1	blastn	37272	233	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia				Thermoanaerobaculia bacterium
18536540	18536540	PRJNA703759_P_NODE_46955_length_244_cov_2.263158_g46479_i0	PRJNA703759	46955	244	2.263158	5.52210552	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	163	9.75e-36	NTclustered	gi\|2874254167\|emb\|OY970399.1\|	171953	g46479	i0	80.822	8.12295081967213	219	32	89	8	16	232	2814465	2814675	MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.6 genome assembly, chromosome: 1	blastn	1982	163	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
19036806	19036806	PRJNA703759_P_NODE_4995_length_665_cov_1.994932_g4522_i0	PRJNA703759	4995	665	1.994932	13.2662978	Acidobacteriaceae	204434	Bacteria	Bacteria	126	3.85e-24	NTclustered	gi\|319923767\|gb\|CP002467.1\|	401053	g4522	i0	95	12.7112781954887	80	4	12	0	106	185	357133	357054	Terriglobus saanensis SP1PR4, complete genome	blastn	8453	126	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus saanensis
22362020	22362020	PRJNA703759_P_NODE_49258_length_243_cov_0.917647_g48782_i0	PRJNA703759	49258	243	0.917647	2.22988221	Luteitalea pratensis	1855912	Bacteria	Bacteria	152	2.1e-32	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g48782	i0	79.464	1.75308641975309	224	38	91	6	1	220	6481684	6481465	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	426	152	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis

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);;