metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB11748" 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_class	tax_order	tax_family	tax_genus	tax_species
1289699	1289699	PRJEB11748_P_NODE_17662_length_1105_cov_40.419540_g16257_i0	PRJEB11748	17662	1105	40.41954	446.635917	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	555	7.029999999999998e-153	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g16257	i0	88.017	121.549321266968	484	38	68	16	1	481	2851563	2851097	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	134312	555	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
2564554	2564554	PRJEB11748_P_NODE_13943_length_1262_cov_54.440466_g12735_i0	PRJEB11748	13943	1262	54.440466	687.03868092	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1127	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12735	i0	85.572	139.572107765452	1102	130	87	22	153	1244	2850692	2851774	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	176140	1127	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
2567880	2567880	PRJEB11748_P_NODE_309703_length_215_cov_1.785714_g307520_i0	PRJEB11748	309703	215	1.785714	3.8392851	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g307520	i0	96.875	0.297674418604651	32	1	15	0	158	189	2851271	2851240	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	64	54.7	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
3841430	3841430	PRJEB11748_P_NODE_168164_length_314_cov_3.371542_g165981_i0	PRJEB11748	168164	314	3.371542	10.58664188	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	198	3.57e-46	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g165981	i0	80.385	18.8662420382166	260	51	83	0	27	286	1544468	1544209	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	5924	198	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5117486	5117486	PRJEB11748_P_NODE_16045_length_1168_cov_34.697380_g14722_i0	PRJEB11748	16045	1168	34.69738	405.2653984	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1077	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g14722	i0	83.756	251.839897260274	1182	147	100	34	1	1168	2852343	2851193	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	294149	1077	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
5119054	5119054	PRJEB11748_P_NODE_23845_length_929_cov_41.483871_g22212_i0	PRJEB11748	23845	929	41.483871	385.38516159	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	944	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g22212	i0	87.207	377.664155005382	852	81	91	21	85	929	2852023	2851193	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	350850	944	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6394062	6394062	PRJEB11748_P_NODE_203146_length_281_cov_2.913636_g200963_i0	PRJEB11748	203146	281	2.913636	8.18731716	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	113	1.17e-20	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g200963	i0	100	102.02846975089	61	0	22	0	1	61	2853197	2853257	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	28670	113	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6396818	6396818	PRJEB11748_P_NODE_355286_length_195_cov_3.238806_g353103_i0	PRJEB11748	355286	195	3.238806	6.3156717	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	248	2e-61	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g353103	i0	89.744	189.394871794872	195	18	100	2	1	195	2851164	2851356	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	36932	248	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6397027	6397027	PRJEB11748_P_NODE_370806_length_187_cov_2.007937_g368623_i0	PRJEB11748	370806	187	2.007937	3.75484219	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	217	5.36e-52	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g368623	i0	87.701	149.625668449198	187	21	100	1	1	187	2851356	2851172	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	27980	217	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8947589	8947589	PRJEB11748_P_NODE_98488_length_421_cov_3.291667_g96318_i0	PRJEB11748	98488	421	3.291667	13.85791807	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	200	1.37e-46	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g96318	i0	80.074	40.8669833729216	271	53	64	1	123	393	3476008	3476277	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	17205	200	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
11492103	11492103	PRJEB11748_P_NODE_114690_length_388_cov_3.972477_g112516_i0	PRJEB11748	114690	388	3.972477	15.41321076	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	196	1.62e-45	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g112516	i0	85.263	39.6082474226804	190	28	49	0	24	213	2633445	2633256	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	15368	196	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
11494476	11494476	PRJEB11748_P_NODE_22890_length_952_cov_78.549944_g21283_i0	PRJEB11748	22890	952	78.549944	747.79546688	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	481	1.0399999999999996e-130	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g21283	i0	85.504	168.696428571429	476	51	79	14	1	474	2851563	2851104	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	160599	481	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
12769305	12769305	PRJEB11748_P_NODE_19391_length_1048_cov_17.831814_g17914_i0	PRJEB11748	19391	1048	17.831814	186.87741072	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	915	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g17914	i0	85.925	81.1106870229008	881	96	98	24	184	1048	2852647	2851779	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	85004	915	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
12769623	12769623	PRJEB11748_P_NODE_211651_length_274_cov_2.746479_g209468_i0	PRJEB11748	211651	274	2.746479	7.52535246	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	329	1.04e-85	NTclustered	gi\|1124890760\|gb\|KY386300.1\|	1960156	g209468	i0	100	109.671532846715	178	0	65	0	97	274	1498	1321	Abditibacterium utsteinense strain R-68168 16S ribosomal RNA gene, partial sequence	blastn	30050	329	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
12773972	12773972	PRJEB11748_P_NODE_88051_length_446_cov_9.823377_g85885_i0	PRJEB11748	88051	446	9.823377	43.81226142	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	399	1.3399999999999998e-106	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g85885	i0	83.796	343.195067264574	432	59	96	10	1	427	2851321	2851746	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	153065	399	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14043869	14043869	PRJEB11748_P_NODE_196492_length_286_cov_24.115556_g194309_i0	PRJEB11748	196492	286	24.115556	68.97049016	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	316	8.489999999999998e-82	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g194309	i0	86.76	432.342657342657	287	35	100	3	1	286	2851187	2851471	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	123650	316	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
16591527	16591527	PRJEB11748_P_NODE_14094_length_1254_cov_56.591785_g12876_i0	PRJEB11748	14094	1254	56.591785	709.6609839	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1319	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12876	i0	88.736	138.530303030303	1092	106	86	15	153	1236	2850692	2851774	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	173717	1319	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
20416003	20416003	PRJEB11748_P_NODE_17597_length_1108_cov_43.718243_g16193_i0	PRJEB11748	17597	1108	43.718243	484.39813244	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	604	6.899999999999998e-168	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g16193	i0	87.902	131.751805054152	529	44	72	16	1	527	2851563	2851053	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	145981	604	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
20420440	20420440	PRJEB11748_P_NODE_61857_length_539_cov_16.523013_g59720_i0	PRJEB11748	61857	539	16.523013	89.05904007	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	403	1.2699999999999997e-107	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g59720	i0	81.693	340.849721706865	508	71	93	18	1	499	2851779	2852273	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	183718	403	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
21693963	21693963	PRJEB11748_P_NODE_27318_length_857_cov_39.521357_g25569_i0	PRJEB11748	27318	857	39.521357	338.69802949	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	477	1.2e-129	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g25569	i0	83.616	163.333722287048	531	63	81	20	1	526	2851563	2851052	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	139977	477	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
24240576	24240576	PRJEB11748_P_NODE_13980_length_1260_cov_74.513761_g12770_i0	PRJEB11748	13980	1260	74.513761	938.8733886	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1092	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g12770	i0	85.041	141.856349206349	1103	132	87	27	153	1242	2850692	2851774	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	178739	1092	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);;