metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Absconditibacteriota"

22 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Candidatus Absconditibacteriota"

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_phylum	tax_species
364233	364233	PRJNA168635_P_NODE_12241_length_233_cov_1.967391_g11825_i0	PRJNA168635	12241	233	1.967391	4.58402103	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	178	3.3e-40	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g11825	i0	85.714	1.5450643776824	168	24	72	0	66	233	326971	327138	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	360	178	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
364265	364265	PRJNA168635_P_NODE_13921_length_216_cov_6.071856_g13505_i0	PRJNA168635	13921	216	6.071856	13.11520896	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	340	3.629999999999999e-89	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g13505	i0	95.349	288.805555555556	215	8	99	1	4	216	327784	327570	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	62382	340	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
1639314	1639314	PRJNA168635_P_NODE_2482_length_520_cov_30.301486_g2099_i0	PRJNA168635	2482	520	30.301486	157.5677272	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	678	0	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g2099	i0	90.211	3.34807692307692	521	49	100	2	1	520	327929	328448	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	1741	678	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
2914977	2914977	PRJNA168635_P_NODE_1303_length_690_cov_15.263651_g987_i0	PRJNA168635	1303	690	15.263651	105.3191919	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	941	0	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g987	i0	92.716	331.865217391304	659	37	94	9	29	679	326280	325625	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	228987	941	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
2915322	2915322	PRJNA168635_P_NODE_3423_length_451_cov_11.087065_g3024_i0	PRJNA168635	3423	451	11.087065	50.00266315	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	497	4.67e-136	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g3024	i0	91.877	43.1840354767184	357	28	79	1	1	357	326457	326812	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	19476	497	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
2915344	2915344	PRJNA168635_P_NODE_403_length_1074_cov_57.548293_g291_i0	PRJNA168635	403	1074	57.548293	618.06866682	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	1629	0	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g291	i0	95.331	89.415270018622	1028	44	100	3	50	1074	324760	323734	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	96032	1629	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
5467915	5467915	PRJNA168635_P_NODE_32845_length_160_cov_2.639640_g32429_i0	PRJNA168635	32845	160	2.63964	4.223424	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	274	2.5999999999999997e-69	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g32429	i0	97.5	2	160	4	100	0	1	160	125727	125568	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	320	274	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
6742191	6742191	PRJNA168635_P_NODE_23206_length_173_cov_2.483871_g22790_i0	PRJNA168635	23206	173	2.483871	4.29709683	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	82.4	1.85e-11	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g22790	i0	79.487	0.676300578034682	117	23	67	1	1	116	326716	326832	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	117	82.4	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
8017621	8017621	PRJNA168635_P_NODE_11807_length_238_cov_2.158730_g11391_i0	PRJNA168635	11807	238	2.15873	5.1377774	uncultured candidate division SR1 bacterium	221237	Bacteria	Bacteria	196	9.33e-46	NTclustered	gi\|132537818\|gb\|EF123563.1\|	221237	g11391	i0	83.028	58.3655462184874	218	35	91	2	1	217	1048	1264	Uncultured candidate division SR1 bacterium clone RB_31f 16S ribosomal RNA gene, partial sequence	blastn	13891	196	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	uncultured candidate division SR1 bacterium
8017865	8017865	PRJNA168635_P_NODE_2567_length_514_cov_14.582796_g2182_i0	PRJNA168635	2567	514	14.582796	74.95557144	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	399	1.5599999999999998e-106	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g2182	i0	81.274	208.673151750973	518	75	99	18	3	511	125386	125890	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	107258	399	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
9292597	9292597	PRJNA168635_P_NODE_2508_length_518_cov_13.277186_g2124_i0	PRJNA168635	2508	518	13.277186	68.77582348	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	516	1.5e-141	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g2124	i0	84.848	4.14285714285714	528	62	100	16	1	518	327929	328448	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	2146	516	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
11842984	11842984	PRJNA168635_P_NODE_15990_length_200_cov_3.033113_g15574_i0	PRJNA168635	15990	200	3.033113	6.066226	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	294	2.61e-75	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g15574	i0	93.069	2.02	202	12	100	2	1	200	126516	126717	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	404	294	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
13118230	13118230	PRJNA168635_P_NODE_1991_length_573_cov_37.139313_g1625_i0	PRJNA168635	1991	573	37.139313	212.80826349	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	641	2.6399999999999993e-179	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g1625	i0	87.086	3.71553228621291	573	66	99	6	1	567	327929	328499	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	2129	641	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
13807770	13807770	PRJNA168635_P_NODE_6411_length_334_cov_5.926316_g6000_i0	PRJNA168635	6411	334	5.926316	19.79389544	Bacteria	2	Bacteria	Bacteria	305	2.19e-78	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g6000	i0	85.294	150.338323353293	306	34	91	8	17	320	125636	125340	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	50213	305	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
16942011	16942011	PRJNA168635_P_NODE_7654_length_305_cov_5.417969_g7241_i0	PRJNA168635	7654	305	5.417969	16.52480545	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	431	3.13e-116	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g7241	i0	92.459	5.24262295081967	305	18	99	5	1	302	326844	327146	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	1599	431	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
18215983	18215983	PRJNA168635_P_NODE_11295_length_244_cov_1.517949_g10880_i0	PRJNA168635	11295	244	1.517949	3.70379556	SR1 bacterium oral taxon 875	1226342	Bacteria	Bacteria	394	3.17e-105	NTclustered	gi\|402243570\|gb\|JX294356.1\|	1226342	g10880	i0	98.222	80.483606557377	225	4	92	0	1	225	1177	1401	SR1 bacterium oral taxon 875 clone CN01 16S ribosomal RNA gene, partial sequence	blastn	19638	394	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	SR1 bacterium oral taxon 875
18216220	18216220	PRJNA168635_P_NODE_23935_length_171_cov_8.688525_g23519_i0	PRJNA168635	23935	171	8.688525	14.85737775	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	213	6.21e-51	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g23519	i0	91.083	0.91812865497076	157	14	92	0	15	171	326918	327074	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	157	213	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
18216404	18216404	PRJNA168635_P_NODE_455_length_1023_cov_61.694045_g291_i1	PRJNA168635	455	1023	61.694045	631.13008035	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	1635	0	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g291	i1	95.508	92.0205278592375	1024	44	100	2	1	1023	324756	323734	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	94137	1635	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
20766274	20766274	PRJNA168635_P_NODE_6217_length_339_cov_11.413793_g5807_i0	PRJNA168635	6217	339	11.413793	38.69275827	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	553	7.199999999999997e-153	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g5807	i0	96.154	10.4572271386431	338	13	99	0	1	338	326490	326827	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	3545	553	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
20766311	20766311	PRJNA168635_P_NODE_8017_length_298_cov_10.232932_g7603_i0	PRJNA168635	8017	298	10.232932	30.49413736	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	462	1.08e-125	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g7603	i0	94.949	203.201342281879	297	12	99	3	1	296	327339	327045	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	60554	462	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
20766322	20766322	PRJNA168635_P_NODE_8457_length_290_cov_3.875519_g8042_i0	PRJNA168635	8457	290	3.875519	11.2390051	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	442	1.3599999999999998e-119	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g8042	i0	94.444	1.25172413793103	288	15	99	1	1	287	327312	327599	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	363	442	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
23316636	23316636	PRJNA168635_P_NODE_25739_length_168_cov_5.655462_g25323_i0	PRJNA168635	25739	168	5.655462	9.50117616	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	267	4.63e-67	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g25323	i0	95.783	8.89880952380952	166	6	98	1	3	167	125175	125010	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	1495	267	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1

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