metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
924313	924313	PRJNA944406_P_NODE_24201_length_287_cov_3.247664_g23242_i0	PRJNA944406	24201	287	3.247664	9.32079568	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	246	1.13e-60	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g23242	i0	84.898	79.4529616724739	245	36	85	1	43	287	2850969	2850726	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	22803	246	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
2199973	2199973	PRJNA944406_P_NODE_4782_length_598_cov_6.287619_g3847_i0	PRJNA944406	4782	598	6.287619	37.59996162	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	291	1.1499999999999998e-73	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3847	i0	86.973	57.3561872909699	261	31	86	3	339	598	2850970	2850712	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	34299	291	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
2200282	2200282	PRJNA944406_P_NODE_7802_length_449_cov_6.898936_g6845_i0	PRJNA944406	7802	449	6.898936	30.97622264	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	664	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g6845	i0	93.318	274.244988864143	449	30	100	0	1	449	2851945	2852393	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	123136	664	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4752820	4752820	PRJNA944406_P_NODE_3204_length_757_cov_4.495614_g2356_i0	PRJNA944406	3204	757	4.495614	34.03179798	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	507	1.3499999999999995e-138	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g2356	i0	85.4	189.424042272127	500	59	82	13	264	757	2851052	2851543	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	143394	507	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4753112	4753112	PRJNA944406_P_NODE_57004_length_256_cov_2.693989_g56045_i0	PRJNA944406	57004	256	2.693989	6.89661184	Abditibacterium utsteinense	1960156	Bacteria	Bacteria	237	5.99e-58	NTclustered	gi\|1124890760\|gb\|KY386300.1\|	1960156	g56045	i0	100	106.22265625	128	0	50	0	1	128	1371	1498	Abditibacterium utsteinense strain R-68168 16S ribosomal RNA gene, partial sequence	blastn	27193	237	1	Bacteria	Pseudomonadati	Abditibacteriota	Abditibacteriia	Abditibacteriales	Abditibacteriaceae	Abditibacterium	Abditibacterium utsteinense
4753134	4753134	PRJNA944406_P_NODE_5924_length_527_cov_13.674009_g4973_i0	PRJNA944406	5924	527	13.674009	72.06202743	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	638	3.1199999999999997e-178	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4973	i0	90.224	242.576850094877	491	44	93	4	39	527	2851897	2851409	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	127838	638	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
4753309	4753309	PRJNA944406_P_NODE_75064_length_249_cov_0.875000_g74105_i0	PRJNA944406	75064	249	0.875	2.17875	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	231	2.7e-56	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g74105	i0	84.388	1.99196787148594	237	35	95	2	2	237	3813544	3813309	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	496	231	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
6027383	6027383	PRJNA944406_P_NODE_1325_length_1197_cov_6.911032_g816_i0	PRJNA944406	1325	1197	6.911032	82.72505304	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1354	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g816	i0	87.231	162.667502088555	1206	133	100	17	1	1197	2852381	2851188	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	194713	1354	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
7302784	7302784	PRJNA944406_P_NODE_57946_length_256_cov_1.185792_g56987_i0	PRJNA944406	57946	256	1.185792	3.03562752	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	211	3.63e-50	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g56987	i0	86.224	410.84375	196	26	76	1	62	256	2852152	2851957	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	105176	211	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8577296	8577296	PRJNA944406_P_NODE_2767_length_827_cov_4.014589_g1969_i0	PRJNA944406	2767	827	4.014589	33.20065103	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	501	6.87e-137	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g1969	i0	87.004	128.698911729141	454	47	80	12	379	827	2851097	2851543	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	106434	501	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
8577573	8577573	PRJNA944406_P_NODE_52667_length_260_cov_5.582888_g51708_i0	PRJNA944406	52667	260	5.582888	14.5155088	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	285	2.15e-72	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g51708	i0	86.873	1151.10769230769	259	28	99	4	1	259	2853584	2853332	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	299288	285	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9852137	9852137	PRJNA944406_P_NODE_106408_length_241_cov_1.827381_g105449_i0	PRJNA944406	106408	241	1.827381	4.40398821	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	276	1.1799999999999998e-69	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g105449	i0	87.5	518.157676348548	240	28	99	1	1	240	2851442	2851205	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	124876	276	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9852289	9852289	PRJNA944406_P_NODE_18868_length_302_cov_3.742358_g17909_i0	PRJNA944406	18868	302	3.742358	11.30192116	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	296	1.18e-75	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g17909	i0	84.667	670.956953642384	300	42	99	4	1	298	2852741	2853038	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	202629	296	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
9852318	9852318	PRJNA944406_P_NODE_21188_length_290_cov_3.322581_g20229_i0	PRJNA944406	21188	290	3.322581	9.6354849	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	403	6.44e-108	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g20229	i0	91.724	105.506896551724	290	24	100	0	1	290	2852361	2852072	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	30597	403	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
11127814	11127814	PRJNA944406_P_NODE_113589_length_207_cov_4.462687_g112630_i0	PRJNA944406	113589	207	4.462687	9.23776209	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	287	4.56e-73	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g112630	i0	91.589	72.024154589372	214	9	100	9	1	207	2849119	2848908	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	14909	287	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
12403356	12403356	PRJNA944406_P_NODE_1150_length_1275_cov_9.935940_g187_i1	PRJNA944406	1150	1275	9.93594	126.683235	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	1214	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g187	i1	84.161	179.949019607843	1288	167	99	29	1	1273	2852018	2850753	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	229435	1214	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
13677865	13677865	PRJNA944406_P_NODE_112531_length_229_cov_2.692308_g111572_i0	PRJNA944406	112531	229	2.692308	6.16538532	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	346	8.370000000000001e-91	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g111572	i0	93.886	11.5807860262009	229	14	100	0	1	229	1875848	1876076	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	2652	346	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
13677886	13677886	PRJNA944406_P_NODE_12331_length_359_cov_3.164336_g11372_i0	PRJNA944406	12331	359	3.164336	11.35996624	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	259	1.87e-64	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g11372	i0	84.528	409.139275766017	265	37	73	4	96	358	2850969	2850707	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	146881	259	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
14952490	14952490	PRJNA944406_P_NODE_4412_length_629_cov_6.895683_g3491_i0	PRJNA944406	4412	629	6.895683	43.37384607	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	723	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3491	i0	87.598	191.017488076312	637	61	100	13	1	629	2851893	2852519	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	120150	723	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
16227358	16227358	PRJNA944406_P_NODE_31333_length_281_cov_1.149038_g30374_i0	PRJNA944406	31333	281	1.149038	3.22879678	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	320	6.43e-83	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g30374	i0	87.189	401.932384341637	281	36	100	0	1	281	2851481	2851761	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	112943	320	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
21327086	21327086	PRJNA944406_P_NODE_7857_length_447_cov_14.569519_g6900_i0	PRJNA944406	7857	447	14.569519	65.12574993	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	725	0	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g6900	i0	95.982	234.375838926175	448	14	99	4	2	447	2851854	2851409	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	104766	725	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
25150810	25150810	PRJNA944406_P_NODE_4760_length_600_cov_3.967742_g3825_i0	PRJNA944406	4760	600	3.967742	23.806452	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	241	1.18e-58	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g3825	i0	83.459	89.955	266	37	71	6	1	264	2850709	2850969	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	53973	241	1	Bacteria	Pseudomonadati	Abditibacteriota					Abditibacteriota bacterium
25150892	25150892	PRJNA944406_P_NODE_5500_length_551_cov_3.265690_g4553_i0	PRJNA944406	5500	551	3.26569	17.9939519	Abditibacteriota bacterium	2783868	Bacteria	Bacteria	436	1.28e-117	NTclustered	gi\|2215576334\|dbj\|AP024152.1\|	2783868	g4553	i0	81.488	220.088929219601	551	84	99	17	1	544	2852468	2851929	Abditibacteriota bacterium IAD-21 DNA, complete genome	blastn	121269	436	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);;