metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA811714" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA811714" and tax_kingdom = "Thermotogati"

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
1223643	1223643	PRJNA811714_P_NODE_16601_length_260_cov_5.085561_g16408_i0	PRJNA811714	16601	260	5.085561	13.2224586	Deinococcus	1298	Bacteria	Bacteria	446	9.3e-121	NTclustered	gi\|2706837832\|gb\|CP149782.1\|	3112952	g16408	i0	97.683	429.857692307692	259	6	99	0	2	260	1454272	1454530	Deinococcus sp. VB142 chromosome 1, complete sequence	blastn	111763	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. VB142
3360657	3360657	PRJNA811714_P_NODE_7703_length_338_cov_6.803774_g7510_i0	PRJNA811714	7703	338	6.803774	22.99675612	Deinococcus ficus	317577	Bacteria	Bacteria	603	7.019999999999999e-168	NTclustered	gi\|1220362168\|gb\|CP021081.1\|	317577	g7510	i0	98.817	254.198224852071	338	4	100	0	1	338	2342003	2342340	Deinococcus ficus strain CC-FR2-10, complete genome	blastn	85919	603	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
6327694	6327694	PRJNA811714_P_NODE_26045_length_229_cov_26.211538_g25852_i0	PRJNA811714	26045	229	26.211538	60.02442202	Deinococcus	1298	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g25852	i0	99.563	214.655021834061	229	1	100	0	1	229	1792454	1792226	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	49156	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
8462483	8462483	PRJNA811714_P_NODE_2787_length_510_cov_7.551487_g2605_i0	PRJNA811714	2787	510	7.551487	38.5125837	Trueperaceae bacterium	2026798	Bacteria	Bacteria	649	0	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g2605	i0	90.909	86.8745098039216	484	42	95	2	2	484	8220	7738	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	44306	649	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
10152225	10152225	PRJNA811714_P_NODE_21668_length_241_cov_13.875000_g21475_i0	PRJNA811714	21668	241	13.875	33.43875	Deinococcus	1298	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g21475	i0	100	211.647302904564	241	0	100	0	1	241	1793402	1793642	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	51007	446	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11427536	11427536	PRJNA811714_P_NODE_7169_length_347_cov_5.463504_g6978_i0	PRJNA811714	7169	347	5.463504	18.95835888	Truepera	332248	Bacteria	Bacteria	392	1.6999999999999995e-104	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g6978	i0	87.069	293.688760806916	348	43	100	2	1	347	417	71	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	101910	392	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
19075328	19075328	PRJNA811714_P_NODE_26355_length_229_cov_2.961538_g26162_i0	PRJNA811714	26355	229	2.961538	6.78192202	Deinococcus	1298	Bacteria	Bacteria	418	1.7499999999999995e-112	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g26162	i0	99.563	135.676855895196	229	1	100	0	1	229	28	256	D.radiodurans 16S ribosomal RNA gene	blastn	31070	418	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
19075356	19075356	PRJNA811714_P_NODE_5175_length_394_cov_5.495327_g4985_i0	PRJNA811714	5175	394	5.495327	21.65158838	Truepera	332248	Bacteria	Bacteria	590	6.459999999999999e-164	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g4985	i0	93.655	553.48730964467	394	25	100	0	1	394	777	1170	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	218074	595	0.991596638655462	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
21211588	21211588	PRJNA811714_P_NODE_25917_length_230_cov_2.942675_g25724_i0	PRJNA811714	25917	230	2.942675	6.7681525	Deinococcus grandis	57498	Bacteria	Bacteria	254	5.24e-63	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g25724	i0	86.842	21.4652173913043	228	28	99	2	2	228	1095158	1095384	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	4937	254	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis

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