metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA737474" and tax_phylum = "Thermodesulfobacteriota"

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
25580394	25580394	PRJNA737474f_S_NODE_45489_length_349_cov_1.876812_g44811_i0	PRJNA737474	45489	349	1.876812	6.55007388	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	396	1.32e-105	NTclustered	gi\|2621701778\|emb\|OY759308.1\|	2044940	g44811	i0	87.32	0.994269340974212	347	43	99	1	3	349	219596	219251	MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1	blastn	347	396	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
25583456	25583456	PRJNA737474g_S_NODE_159273_length_292_cov_1.776256_g157979_i0	PRJNA737474	159273	292	1.776256	5.18666752	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	198	3.28e-46	NTclustered	gi\|2621701778\|emb\|OY759308.1\|	2044940	g157979	i0	82.008	0.818493150684932	239	38	80	5	58	292	219094	218857	MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1	blastn	239	198	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
25764987	25764987	PRJNA737474e_S_NODE_9074_length_379_cov_2.143791_g8192_i0	PRJNA737474	9074	379	2.143791	8.12496789	Pseudomonadati	3379134	Bacteria	Bacteria	442	1.829999999999999e-119	NTclustered	gi\|2431395895\|gb\|CP116246.1\|	881	g8192	i0	96.283	33.5277044854881	269	10	71	0	111	379	2383438	2383706	Nitratidesulfovibrio vulgaris strain L2 chromosome, complete genome	blastn	12707	442	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Nitratidesulfovibrio	Nitratidesulfovibrio vulgaris
25842125	25842125	PRJNA737474b_S_NODE_46779_length_241_cov_2.220238_g45740_i0	PRJNA737474	46779	241	2.220238	5.35077358	Desulfarculus baarsii DSM 2	453230	Bacteria	Bacteria	134	7.530000000000001e-27	NTclustered	gi\|301638057\|gb\|CP002085.1\|	644282	g45740	i0	81.481	24.4605809128631	162	30	67	0	12	173	1996941	1997102	Desulfarculus baarsii DSM 2075, complete genome	blastn	5895	134	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae	Desulfarculus	Desulfarculus baarsii
25851078	25851078	PRJNA737474f_S_NODE_244011_length_245_cov_4564.534884_g243333_i0	PRJNA737474	244011	245	4564.534884	11183.1104658	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	75	4.72e-9	NTclustered	gi\|2166245353\|dbj\|LC663086.1\|	2049433	g243333	i0	100	160.955102040816	40	0	16	0	39	78	40	79	Desulfobacteraceae bacterium ARSSAG-00002168 DNA, putative prophage region, clone: 00002168_pp1	blastn	39434	75	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
25851994	25851994	PRJNA737474f_S_NODE_330443_length_225_cov_1456.513158_g329765_i0	PRJNA737474	330443	225	1456.513158	3277.1546055	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	84.2	7.1e-12	NTclustered	gi\|2166243161\|dbj\|LC662973.1\|	2049433	g329765	i0	94.545	186.915555555556	55	1	24	2	39	92	36	89	Desulfobacteraceae bacterium ARSSAG-00001653 DNA, putative prophage region, clone: 00001653_pp2	blastn	42056	84.2	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
25860515	25860515	PRJNA737474g_S_NODE_484315_length_231_cov_978.430380_g483021_i0	PRJNA737474	484315	231	978.43038	2260.1741778	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	76.8	1.22e-9	NTclustered	gi\|2166243161\|dbj\|LC662973.1\|	2049433	g483021	i0	89.062	204.580086580087	64	3	26	4	29	89	27	89	Desulfobacteraceae bacterium ARSSAG-00001653 DNA, putative prophage region, clone: 00001653_pp2	blastn	47258	76.8	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
26124014	26124014	PRJNA737474f_S_NODE_306053_length_233_cov_3318.743750_g305375_i0	PRJNA737474	306053	233	3318.74375	7732.6729375	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	78.7	3.44e-10	NTclustered	gi\|2166243161\|dbj\|LC662973.1\|	2049433	g305375	i0	92.727	191.965665236052	55	2	23	2	30	82	26	80	Desulfobacteraceae bacterium ARSSAG-00001653 DNA, putative prophage region, clone: 00001653_pp2	blastn	44728	78.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
26126062	26126062	PRJNA737474f_S_NODE_89757_length_298_cov_1.066667_g89079_i0	PRJNA737474	89757	298	1.066667	3.17866766	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	318	2.4699999999999995e-82	NTclustered	gi\|2621701778\|emb\|OY759308.1\|	2044940	g89079	i0	85.906	1	298	42	100	0	1	298	220567	220270	MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1	blastn	298	318	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
26126851	26126851	PRJNA737474g_S_NODE_120293_length_312_cov_18273.753138_g118999_i0	PRJNA737474	120293	312	18273.753138	57014.10979056	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	75	6.23e-9	NTclustered	gi\|2166243161\|dbj\|LC662973.1\|	2049433	g118999	i0	89.831	147.208333333333	59	4	19	2	145	202	89	32	Desulfobacteraceae bacterium ARSSAG-00001653 DNA, putative prophage region, clone: 00001653_pp2	blastn	45929	75	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
26400452	26400452	PRJNA737474g_S_NODE_19071_length_701_cov_1.961783_g17876_i0	PRJNA737474	19071	701	1.961783	13.75209883	Desulfomicrobium baculatum DSM 4	899	Bacteria	Bacteria	512	2.67e-140	NTclustered	gi\|256576994\|gb\|CP001629.1\|	525897	g17876	i0	80.085	102.151212553495	703	128	99	12	5	701	811286	810590	Desulfomicrobium baculatum DSM 4028, complete genome	blastn	71608	512	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfomicrobiaceae	Desulfomicrobium	Desulfomicrobium baculatum
26448821	26448821	PRJNA737474g_S_NODE_94191_length_333_cov_1.350000_g92897_i0	PRJNA737474	94191	333	1.35	4.4955	Desulfobacca	60892	Bacteria	Bacteria	228	4.8599999999999986e-55	NTclustered	gi\|470488362\|ref\|NR_076865.1\|	60893	g92897	i0	83.951	200.021021021021	243	33	72	5	22	262	36	274	Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence	blastn	66607	228	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
26531343	26531343	PRJNA737474f_S_NODE_236536_length_246_cov_2.658960_g235858_i0	PRJNA737474	236536	246	2.65896	6.5410416	Taurinivorans muris	2787751	Bacteria	Bacteria	390	4.15e-104	NTclustered	gi\|2304091556\|gb\|CP065938.1\|	2787751	g235858	i0	98.206	0.90650406504065	223	4	91	0	6	228	1970362	1970140	Taurinivorans muris strain LT0009 chromosome, complete genome	blastn	223	390	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfovibrionaceae	Taurinivorans	Taurinivorans muris
26538739	26538739	PRJNA737474g_S_NODE_30296_length_522_cov_1.579065_g29020_i0	PRJNA737474	30296	522	1.579065	8.2427193	Desulfobacterales bacterium	2044940	Bacteria	Bacteria	547	5.3499999999999986e-151	NTclustered	gi\|2621701778\|emb\|OY759308.1\|	2044940	g29020	i0	86.282	0.96360153256705	503	69	96	0	20	522	220067	220569	MAG: Desulfobacterales bacterium isolate 4b48c405-a8b0-44ce-a896-9916d3c4254b genome assembly, chromosome: 1	blastn	503	547	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales			Desulfobacterales bacterium
26540461	26540461	PRJNA737474g_S_NODE_439384_length_241_cov_0.904762_g438090_i0	PRJNA737474	439384	241	0.904762	2.18047642	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	73.1	1.67e-8	NTclustered	gi\|2166245324\|dbj\|LC663084.1\|	2049433	g438090	i0	100	176.095435684647	39	0	16	0	32	70	11792	11754	Desulfobacteraceae bacterium ARSSAG-00001218 DNA, putative prophage region, clone: 00001218_pp1	blastn	42439	73.1	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae bacterium
26540719	26540719	PRJNA737474g_S_NODE_464960_length_235_cov_633.129630_g463666_i0	PRJNA737474	464960	235	633.12963	1487.8546305	Desulfobacteraceae bacterium	2049433	Bacteria	Bacteria	78.7	3.47e-10	NTclustered	gi\|2166245324\|dbj\|LC663084.1\|	2049433	g463666	i0	100	181.23829787234	42	0	18	0	157	198	11753	11794	Desulfobacteraceae bacterium ARSSAG-00001218 DNA, putative prophage region, clone: 00001218_pp1	blastn	42591	78.7	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobacteria	Desulfobacterales	Desulfobacteraceae		Desulfobacteraceae 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);;