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

12 rows where analysis = "blastn", bioproject = "PRJNA488043" and tax_phylum = "Nitrospirota"

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
450057	450057	PRJNA488043_P_NODE_6781_length_479_cov_2.435556_g4688_i0	PRJNA488043	6781	479	2.435556	11.66631324	Nitrospira sp. KM1	1936990	Bacteria	Bacteria	298	5.4299999999999997e-76	NTclustered	gi\|1808878785\|dbj\|AP022671.1\|	1936990	g4688	i0	86.121	17.1711899791232	281	33	86	5	202	479	3399332	3399055	Nitrospira sp. KM1 DNA, complete genome	blastn	8225	298	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. KM1
7475927	7475927	PRJNA488043_P_NODE_20626_length_165_cov_4.529412_g18384_i0	PRJNA488043	20626	165	4.529412	7.4735298	Nitrospira	1234	Bacteria	Bacteria	231	1.65e-56	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g18384	i0	93.038	82.9757575757576	158	11	96	0	6	163	2684490	2684647	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	13691	231	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9377836	9377836	PRJNA488043_P_NODE_9408_length_359_cov_12.272727_g7178_i0	PRJNA488043	9408	359	12.272727	44.05908993	Nitrospira moscoviensis	42253	Bacteria	Bacteria	514	3.61e-141	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g7178	i0	92.5	162.16991643454	360	25	100	2	1	359	1277242	1277600	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	58219	514	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
14478534	14478534	PRJNA488043_P_NODE_5352_length_568_cov_8.155844_g3405_i0	PRJNA488043	5352	568	8.155844	46.32519392	Nitrospira sp.	70125	Bacteria	Bacteria	948	0	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g3405	i0	96.147	131.140845070423	571	19	100	1	1	568	2094551	2093981	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	74488	948	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
15752660	15752660	PRJNA488043_P_NODE_6873_length_473_cov_9.315315_g4771_i0	PRJNA488043	6873	473	9.315315	44.06143995	Nitrospira moscoviensis	42253	Bacteria	Bacteria	488	2.9599999999999996e-133	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g4771	i0	89.086	142.042283298097	394	41	83	2	81	473	1277634	1277242	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	67186	488	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
16400432	16400432	PRJNA488043_P_NODE_13473_length_252_cov_2.636771_g11231_i0	PRJNA488043	13473	252	2.636771	6.64466292	Nitrospira	1234	Bacteria	Bacteria	294	3.44e-75	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g11231	i0	98.788	182.031746031746	165	2	65	0	1	165	3066337	3066501	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	45872	294	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17675569	17675569	PRJNA488043_P_NODE_18734_length_184_cov_39.070968_g16492_i0	PRJNA488043	18734	184	39.070968	71.89058112	Nitrospira	1234	Bacteria	Bacteria	316	5.04e-82	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g16492	i0	100	92.6684782608696	171	0	93	0	14	184	2686944	2687114	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	17051	316	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17675575	17675575	PRJNA488043_P_NODE_19454_length_177_cov_3.675676_g17212_i0	PRJNA488043	19454	177	3.675676	6.50594652	Nitrospira	1234	Bacteria	Bacteria	230	6.439999999999999e-56	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g17212	i0	90.395	24.045197740113	177	14	99	3	1	175	883572	883747	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	4256	230	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18949528	18949528	PRJNA488043_P_NODE_7475_length_441_cov_11.781553_g5325_i0	PRJNA488043	7475	441	11.781553	51.95664873	Nitrospira	1234	Bacteria	Bacteria	671	0	NTclustered	gi\|2863129529\|dbj\|AP038806.1\|	70125	g5325	i0	94.104	128.360544217687	441	26	100	0	1	441	3063201	3062761	MAG: Nitrospira sp. NFB02 DNA, complete genome	blastn	56607	671	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19575552	19575552	PRJNA488043_P_NODE_11996_length_283_cov_1.535433_g9755_i0	PRJNA488043	11996	283	1.535433	4.34527539	Nitrospira sp.	70125	Bacteria	Bacteria	204	6.809999999999998e-48	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g9755	i0	90.909	5.46643109540636	154	11	54	3	131	283	732626	732475	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	1547	204	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22126223	22126223	PRJNA488043_P_NODE_10838_length_313_cov_4.232394_g8597_i0	PRJNA488043	10838	313	4.232394	13.24739322	Nitrospira sp.	70125	Bacteria	Bacteria	538	1.8399999999999993e-148	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g8597	i0	97.756	17.7635782747604	312	7	99	0	2	313	2738163	2737852	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	5560	538	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23402264	23402264	PRJNA488043_P_NODE_5099_length_589_cov_5.680357_g3186_i0	PRJNA488043	5099	589	5.680357	33.45730273	Nitrospira sp.	70125	Bacteria	Bacteria	710	0	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g3186	i0	96.092	382.449915110357	435	17	98	0	1	435	2683847	2683413	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	225263	710	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.

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