metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax_phylum = "Kiritimatiellota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3153373	3153373	PRJNA630162_P_NODE_58943_length_230_cov_1.027624_g57420_i0	PRJNA630162	58943	230	1.027624	2.3635352	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	161	3.27e-35	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g57420	i0	81.068	7.5	206	36	89	2	27	230	417449	417653	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	1725	161	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
4429678	4429678	PRJNA630162_P_NODE_17364_length_448_cov_46.385965_g15860_i0	PRJNA630162	17364	448	46.385965	207.8091232	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	268	3.96e-67	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g15860	i0	79.075	757.247767857143	411	70	90	15	1	404	320247	320648	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	339247	268	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
4979724	4979724	PRJNA630162_P_NODE_61164_length_226_cov_1.361582_g59641_i0	PRJNA630162	61164	226	1.361582	3.07717532	Kiritimatiellota	134625	Bacteria	Bacteria	206	1.4599999999999998e-48	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g59641	i0	83.562	51.5973451327434	219	36	97	0	7	225	588056	588274	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	11661	207	0.995169082125604	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
6980058	6980058	PRJNA630162_P_NODE_127506_length_170_cov_3.628099_g125983_i0	PRJNA630162	127506	170	3.628099	6.1677683	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	121	3.84e-23	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g125983	i0	84.677	293.429411764706	124	16	72	3	4	125	320949	321071	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	49883	121	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
6980424	6980424	PRJNA630162_P_NODE_165366_length_159_cov_2.036364_g163843_i0	PRJNA630162	165366	159	2.036364	3.23781876	uncultured Kiritimatiellota bacterium	543364	Bacteria	Bacteria	231	1.58e-56	NTclustered	gi\|192792224\|gb\|EU794173.1\|	543364	g163843	i0	93.59	96.3207547169811	156	9	97	1	5	159	62	217	Uncultured Verrucomicrobiales subdivision 5 bacterium clone EMP_D8 16S ribosomal RNA gene, partial sequence	blastn	15315	231	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					uncultured Kiritimatiellota bacterium
8254911	8254911	PRJNA630162_P_NODE_149587_length_164_cov_3.052174_g148064_i0	PRJNA630162	149587	164	3.052174	5.00556536	uncultured Kiritimatiellota bacterium	543364	Bacteria	Bacteria	272	9.65e-69	NTclustered	gi\|192792224\|gb\|EU794173.1\|	543364	g148064	i0	99.333	91.5	150	1	91	0	7	156	906	757	Uncultured Verrucomicrobiales subdivision 5 bacterium clone EMP_D8 16S ribosomal RNA gene, partial sequence	blastn	15006	272	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					uncultured Kiritimatiellota bacterium
8255353	8255353	PRJNA630162_P_NODE_3427_length_1011_cov_14.398129_g752_i2	PRJNA630162	3427	1011	14.398129	145.56508419	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	1022	0	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g752	i2	85.156	564.548961424332	1024	122	100	20	1	1011	320843	319837	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	570759	1022	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
8255963	8255963	PRJNA630162_P_NODE_9247_length_631_cov_44.998282_g7874_i0	PRJNA630162	9247	631	44.998282	283.93915942	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	363	2.5499999999999998e-95	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g7874	i0	77.692	155.849445324881	650	108	99	28	3	631	588996	588363	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	98341	363	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
9530633	9530633	PRJNA630162_P_NODE_28048_length_343_cov_2.897959_g26526_i0	PRJNA630162	28048	343	2.897959	9.93999937	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	219	3.02e-52	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g26526	i0	79.553	423.539358600583	313	59	91	5	4	315	321181	321489	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	145274	219	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
12080777	12080777	PRJNA630162_P_NODE_10510_length_590_cov_6.589649_g9087_i0	PRJNA630162	10510	590	6.589649	38.8789291	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	375	3.0499999999999998e-99	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g9087	i0	80.962	346.762711864407	478	87	81	4	60	535	588561	589036	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	204590	375	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
12081943	12081943	PRJNA630162_P_NODE_65210_length_219_cov_1.582353_g63687_i0	PRJNA630162	65210	219	1.582353	3.46535307	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	113	8.76e-21	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g63687	i0	76.724	4.21461187214612	232	37	100	9	1	219	588409	588636	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	923	113	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
13355829	13355829	PRJNA630162_P_NODE_13231_length_522_cov_16.505285_g11753_i0	PRJNA630162	13231	522	16.505285	86.1575877	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	580	5.279999999999999e-161	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g11753	i0	87.14	136.908045977011	521	55	99	11	1	516	321155	321668	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	71466	580	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
13355846	13355846	PRJNA630162_P_NODE_134671_length_168_cov_1.512605_g133148_i0	PRJNA630162	134671	168	1.512605	2.5411764	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	154	3.76e-33	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g133148	i0	88.462	5.44642857142857	130	12	76	3	28	154	588495	588624	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	915	154	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
13905480	13905480	PRJNA630162_P_NODE_64411_length_220_cov_2.362573_g62888_i0	PRJNA630162	64411	220	2.362573	5.1976606	Bacteria	2	Bacteria	Bacteria	71.3	5.38e-8	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g62888	i0	88.333	1.26818181818182	60	6	27	1	1	60	588663	588721	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	279	71.3	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
15905173	15905173	PRJNA630162_P_NODE_41273_length_276_cov_18.819383_g39750_i0	PRJNA630162	41273	276	18.819383	51.94149708	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	416	7.809999999999998e-112	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g39750	i0	94.444	130.960144927536	270	15	98	0	7	276	321668	321399	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	36145	416	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
15905225	15905225	PRJNA630162_P_NODE_4573_length_888_cov_9.233611_g3576_i0	PRJNA630162	4573	888	9.233611	81.99446568	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	800	0	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g3576	i0	83.147	248.469594594595	896	132	99	19	3	887	587748	588635	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	220641	800	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
17180434	17180434	PRJNA630162_P_NODE_55574_length_236_cov_3.844920_g54051_i0	PRJNA630162	55574	236	3.84492	9.0740112	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	128	3.42e-25	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g54051	i0	77.406	1.01271186440678	239	39	98	12	6	236	588401	588632	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	239	128	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
17180653	17180653	PRJNA630162_P_NODE_76654_length_205_cov_3.339744_g75131_i0	PRJNA630162	76654	205	3.339744	6.8464752	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	217	6e-52	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g75131	i0	86.07	395.463414634146	201	28	98	0	3	203	589818	589618	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	81070	217	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
17180817	17180817	PRJNA630162_P_NODE_91834_length_190_cov_4.347518_g90311_i0	PRJNA630162	91834	190	4.347518	8.2602842	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	248	1.94e-61	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g90311	i0	90.86	213.978947368421	186	15	97	2	1	185	321162	321346	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	40656	248	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
18454018	18454018	PRJNA630162_P_NODE_18115_length_437_cov_11.389175_g16607_i0	PRJNA630162	18115	437	11.389175	49.77069475	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	320	1.0499999999999999e-82	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g16607	i0	84.756	143.162471395881	328	40	74	10	114	437	321476	321155	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	62562	320	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
18454318	18454318	PRJNA630162_P_NODE_42095_length_273_cov_17.379464_g40572_i0	PRJNA630162	42095	273	17.379464	47.44593672	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	433	7.66e-117	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g40572	i0	95.572	333.084249084249	271	10	99	2	1	269	318744	319014	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	90932	433	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
18454583	18454583	PRJNA630162_P_NODE_65575_length_218_cov_2.733728_g64052_i0	PRJNA630162	65575	218	2.733728	5.95952704	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	148	2.3899999999999993e-31	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g64052	i0	79.535	1.97247706422018	215	39	97	5	2	213	417154	417366	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	430	148	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
19729010	19729010	PRJNA630162_P_NODE_55076_length_237_cov_5.101064_g53553_i0	PRJNA630162	55076	237	5.101064	12.08952168	Tichowtungia aerotolerans	2697043	Bacteria	Bacteria	292	1.15e-74	NTclustered	gi\|1798450978\|gb\|CP047593.1\|	2697043	g53553	i0	89.27	121.308016877637	233	25	98	0	5	237	319635	319403	Tichowtungia aerotolerans strain S-5007 chromosome, complete genome	blastn	28750	292	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Tichowtungiia	Tichowtungiales	Tichowtungiaceae	Tichowtungia	Tichowtungia aerotolerans
23554987	23554987	PRJNA630162_P_NODE_5259_length_833_cov_32.917092_g4189_i0	PRJNA630162	5259	833	32.917092	274.19937636	Kiritimatiellota bacterium B12222	3040511	Bacteria	Bacteria	721	0	NTclustered	gi\|2485208337\|gb\|CP120722.1\|	3040511	g4189	i0	82.536	334.567827130852	836	130	99	15	1	828	417075	417902	Kiritimatiellota bacterium B12222 chromosome, complete genome	blastn	278695	721	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium B12222
23555175	23555175	PRJNA630162_P_NODE_7139_length_716_cov_30.094453_g5903_i0	PRJNA630162	7139	716	30.094453	215.47628348	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	475	3.589999999999999e-129	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g5903	i0	79.854	144.40782122905	685	111	93	21	48	716	589036	588363	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	103396	475	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
24829006	24829006	PRJNA630162_P_NODE_87760_length_193_cov_3.041667_g86237_i0	PRJNA630162	87760	193	3.041667	5.87041731	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	178	2.63e-40	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g86237	i0	83.673	51.6943005181347	196	24	97	3	3	190	588815	588620	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	9977	178	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans

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