metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
3160757	3160757	PRJNA640143_S_NODE_18663_length_203_cov_1.722892_g18453_i0	PRJNA640143	18663	203	1.722892	3.49747076	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	211	2.76e-50	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g18453	i0	87.778	180.576354679803	180	22	89	0	22	201	2853037	2852858	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	36657	211	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
4437390	4437390	PRJNA640143_S_NODE_13084_length_240_cov_2.113300_g12874_i0	PRJNA640143	13084	240	2.1133	5.07192	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	231	2.58e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12874	i0	84.914	0.966666666666667	232	31	96	3	1	230	6363892	6363663	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	232	231	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
4437633	4437633	PRJNA640143_S_NODE_22764_length_184_cov_76.551020_g22554_i0	PRJNA640143	22764	184	76.55102	140.8538768	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	154	4.18e-33	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g22554	i0	85.714	73.2282608695652	147	19	80	2	37	183	2851182	2851326	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	13474	154	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
14639051	14639051	PRJNA640143_S_NODE_4592_length_382_cov_1.808696_g4385_i0	PRJNA640143	4592	382	1.808696	6.90921872	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	130	1.64e-25	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4385	i0	80.682	28.7670157068063	176	27	45	5	179	351	2851016	2851187	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	10989	130	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
15913038	15913038	PRJNA640143_S_NODE_4433_length_388_cov_3.658120_g4229_i0	PRJNA640143	4433	388	3.65812	14.1935056	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	457	6.719999999999999e-124	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4229	i0	94.881	230.855670103093	293	14	76	1	34	326	2853304	2853595	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	89572	457	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
17188067	17188067	PRJNA640143_S_NODE_3614_length_423_cov_13.129534_g3416_i0	PRJNA640143	3614	423	13.129534	55.53792882	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	243	2.25e-59	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3416	i0	82.624	507.550827423168	282	42	66	6	108	387	2850969	2850693	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	214694	243	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
17188174	17188174	PRJNA640143_S_NODE_7434_length_309_cov_3.415441_g7224_i0	PRJNA640143	7434	309	3.415441	10.55371269	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	396	1.16e-105	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g7224	i0	92.419	77.4498381877023	277	21	90	0	33	309	2850693	2850969	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	23932	396	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
19736866	19736866	PRJNA640143_S_NODE_3316_length_438_cov_150.698254_g3120_i0	PRJNA640143	3316	438	150.698254	660.05835252	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	254	1.08e-62	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3120	i0	83.824	288.351598173516	272	38	61	6	1	269	2850962	2850694	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	126298	254	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
19736976	19736976	PRJNA640143_S_NODE_696_length_802_cov_5.325490_g629_i0	PRJNA640143	696	802	5.32549	42.7104298	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	802	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g629	i0	89.144	209.711970074813	654	57	80	9	1	643	2852013	2851363	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	168189	802	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
23562738	23562738	PRJNA640143_S_NODE_3499_length_429_cov_3.168367_g3302_i0	PRJNA640143	3499	429	3.168367	13.59229443	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	350	1.31e-91	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3302	i0	81.693	550.519813519814	437	64	100	12	1	429	2851830	2852258	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	236173	350	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);;