metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

16 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
128122	128122	PRJEB64798_P_NODE_22221_length_420_cov_8.921833_g20481_i0	PRJEB64798	22221	420	8.921833	37.4716986	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	368	3.5300000000000003e-97	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g20481	i0	90.278	118.971428571429	288	19	66	3	136	414	2852002	2851715	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	49968	368	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
1401519	1401519	PRJEB64798_P_NODE_143602_length_191_cov_13.105634_g141836_i0	PRJEB64798	143602	191	13.105634	25.03176094	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	270	4.17e-68	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g141836	i0	92.188	120.418848167539	192	13	100	2	1	191	2851026	2851216	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	23000	270	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
1401553	1401553	PRJEB64798_P_NODE_14622_length_521_cov_7.260593_g12951_i0	PRJEB64798	14622	521	7.260593	37.82768953	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	318	4.56e-82	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12951	i0	82.353	209.404990403071	374	58	71	7	151	521	2851026	2851394	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	109100	318	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
3952567	3952567	PRJEB64798_P_NODE_10904_length_606_cov_6.016158_g9376_i0	PRJEB64798	10904	606	6.016158	36.45791748	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	750	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g9376	i0	94.286	195.178217821782	490	28	81	0	112	601	2851721	2851232	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	118278	750	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
5231059	5231059	PRJEB64798_P_NODE_245285_length_153_cov_6.076923_g243519_i0	PRJEB64798	245285	153	6.076923	9.29769219	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	207	2.53e-49	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g243519	i0	92	182.542483660131	150	9	96	1	7	153	2852977	2853126	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	27929	207	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
6506271	6506271	PRJEB64798_P_NODE_212206_length_164_cov_2.634783_g210440_i0	PRJEB64798	212206	164	2.634783	4.32104412	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	154	3.65e-33	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g210440	i0	85.535	147.823170731707	159	10	97	8	2	160	2851321	2851176	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24243	154	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
10330318	10330318	PRJEB64798_P_NODE_157549_length_184_cov_13.859259_g155783_i0	PRJEB64798	157549	184	13.859259	25.50103656	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	206	1.1399999999999999e-48	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g155783	i0	88.953	134.516304347826	172	12	93	5	10	181	2853581	2853417	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	24751	206	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
10331212	10331212	PRJEB64798_P_NODE_21989_length_423_cov_6.647059_g20249_i0	PRJEB64798	21989	423	6.647059	28.11705957	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	315	4.71e-81	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g20249	i0	80.751	2.01418439716312	426	63	99	16	1	419	2852252	2851839	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	852	315	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
12881389	12881389	PRJEB64798_P_NODE_193111_length_169_cov_3.558333_g191345_i0	PRJEB64798	193111	169	3.558333	6.01358277	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	219	1.3099999999999999e-52	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g191345	i0	90.909	2.77514792899408	165	11	96	4	6	168	2851386	2851548	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	469	219	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
14156077	14156077	PRJEB64798_P_NODE_187212_length_171_cov_6.385246_g185446_i0	PRJEB64798	187212	171	6.385246	10.91877066	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	180	6.3e-41	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g185446	i0	86.957	378.637426900585	161	20	94	1	6	166	2851441	2851282	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	64747	180	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
15431655	15431655	PRJEB64798_P_NODE_57933_length_256_cov_4.560386_g56168_i0	PRJEB64798	57933	256	4.560386	11.67458816	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	337	5.74e-88	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g56168	i0	90.551	111.65234375	254	24	99	0	1	254	2852333	2852080	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28583	337	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
17980316	17980316	PRJEB64798_P_NODE_34255_length_337_cov_7.482639_g32497_i0	PRJEB64798	34255	337	7.482639	25.21649343	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	161	5.06e-35	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g32497	i0	90.244	248.299703264095	123	12	57	0	1	123	2851001	2850879	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	83677	161	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
19253693	19253693	PRJEB64798_P_NODE_218316_length_162_cov_9.787611_g216550_i0	PRJEB64798	218316	162	9.787611	15.85592982	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	147	6.009999999999999e-31	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g216550	i0	83.544	669.981481481482	158	25	97	1	1	157	2852140	2851983	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	108537	147	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
19254420	19254420	PRJEB64798_P_NODE_37796_length_321_cov_11.136029_g36036_i0	PRJEB64798	37796	321	11.136029	35.74665309	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	453	7.070000000000001e-123	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g36036	i0	92.476	132.295950155763	319	20	99	4	5	321	2852639	2852955	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	42467	453	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
20528520	20528520	PRJEB64798_P_NODE_182117_length_173_cov_7.000000_g180351_i0	PRJEB64798	182117	173	7	12.11	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	174	2.97e-39	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g180351	i0	85.629	2.78612716763006	167	22	97	2	1	167	2851195	2851031	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	482	174	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriota bacterium
21805647	21805647	PRJEB64798_P_NODE_39978_length_312_cov_10.357414_g38214_i0	PRJEB64798	39978	312	10.357414	32.31513168	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	473	5.2499999999999996e-129	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g38214	i0	96.82	298.294871794872	283	9	91	0	26	308	2853589	2853307	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	93068	473	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);;