metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA946307" and tax_phylum = "Abditibacteriota"

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
2202287	2202287	PRJNA946307_P_NODE_27742_length_245_cov_3.923469_g26868_i0	PRJNA946307	27742	245	3.923469	9.61249905	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	320	5.49e-83	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g26868	i0	91.88	399.70612244898	234	12	96	4	1	234	2853534	2853308	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	97928	320	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
2203311	2203311	PRJNA946307_P_NODE_85782_length_190_cov_3.319149_g84908_i0	PRJNA946307	85782	190	3.319149	6.3063831	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	244	2.5099999999999997e-60	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g84908	i0	93.373	148.194736842105	166	10	87	1	3	167	2851741	2851906	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28157	244	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
3478064	3478064	PRJNA946307_P_NODE_4623_length_677_cov_4.472930_g2735_i2	PRJNA946307	4623	677	4.47293	30.2817361	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	880	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i2	95.479	359.985228951256	553	21	81	4	125	675	2851065	2851615	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	243710	880	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
4753920	4753920	PRJNA946307_P_NODE_101264_length_183_cov_4.194030_g100390_i0	PRJNA946307	101264	183	4.19403	7.6750749	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	230	6.71e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g100390	i0	98.462	118.874316939891	130	2	71	0	1	130	2853062	2852933	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	21754	230	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
7304091	7304091	PRJNA946307_P_NODE_130146_length_170_cov_6.181818_g129272_i0	PRJNA946307	130146	170	6.181818	10.5090906	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	224	2.8499999999999996e-54	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g129272	i0	96.35	143.970588235294	137	3	80	2	20	155	2853201	2853066	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24475	224	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
8579968	8579968	PRJNA946307_P_NODE_30347_length_236_cov_3.342246_g29473_i0	PRJNA946307	30347	236	3.342246	7.88770056	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	189	1.5499999999999996e-43	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g29473	i0	94.309	442.076271186441	123	7	94	0	114	236	2852574	2852452	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	104330	189	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
13680961	13680961	PRJNA946307_P_NODE_41491_length_212_cov_2.588957_g40617_i0	PRJNA946307	41491	212	2.588957	5.48858884	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	122	1.4000000000000002e-23	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g40617	i0	91.111	1.80188679245283	90	8	88	0	112	201	2852043	2851954	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	382	122	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
17505176	17505176	PRJNA946307_P_NODE_24154_length_261_cov_4.235849_g23280_i0	PRJNA946307	24154	261	4.235849	11.05556589	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	278	3.61e-70	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g23280	i0	89.035	216.532567049808	228	20	87	4	1	226	2852400	2852176	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	56515	278	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
18778868	18778868	PRJNA946307_P_NODE_3275_length_810_cov_4.394218_g2735_i0	PRJNA946307	3275	810	4.394218	35.5931658	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	880	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i0	95.479	302.549382716049	553	21	96	4	258	808	2851065	2851615	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	245065	880	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
20053818	20053818	PRJNA946307_P_NODE_3756_length_756_cov_3.848656_g2735_i1	PRJNA946307	3756	756	3.848656	29.09583936	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	723	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2735	i1	95.395	272.047619047619	456	17	93	4	3	456	2851615	2851162	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	205668	723	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
21329193	21329193	PRJNA946307_P_NODE_32637_length_229_cov_2.488889_g31763_i0	PRJNA946307	32637	229	2.488889	5.69955581	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	172	1.5e-38	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g31763	i0	81.25	229.576419213974	224	32	96	8	3	221	2850933	2850715	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	52573	172	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
23879785	23879785	PRJNA946307_P_NODE_37619_length_216_cov_2.982036_g36745_i0	PRJNA946307	37619	216	2.982036	6.44119776	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	311	2.85e-80	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g36745	i0	94.527	458.402777777778	201	11	93	0	3	203	2852130	2851930	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	99015	311	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota 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);;