metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB14803" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB14803" 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
2261102	2261102	PRJEB14803_P_NODE_38562_length_169_cov_1.746269_g38096_i0	PRJEB14803	38562	169	1.746269	2.95119461	Deinococcus	1298	Bacteria	Bacteria	302	1.27e-77	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g38096	i0	98.817	201.532544378698	169	2	100	0	1	169	70989	70821	Deinococcus swuensis strain DY59, complete genome	blastn	34059	302	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
3847673	3847673	PRJEB14803_P_NODE_34904_length_180_cov_1.496552_g34438_i0	PRJEB14803	34904	180	1.496552	2.6937936	Deinococcus gobiensis	502394	Bacteria	Bacteria	307	2.9500000000000003e-79	NTclustered	gi\|379998737\|gb\|CP002191.1\|	745776	g34438	i0	97.753	92.5666666666667	178	4	99	0	3	180	803305	803128	Deinococcus gobiensis I-0, complete genome	blastn	16662	307	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis
5123765	5123765	PRJEB14803_P_NODE_13625_length_333_cov_2.258389_g13160_i0	PRJEB14803	13625	333	2.258389	7.52043537	Deinococcus actinosclerus	1768108	Bacteria	Bacteria	566	9.06e-157	NTclustered	gi\|972944657\|gb\|CP013910.1\|	1768108	g13160	i0	97.305	243.597597597598	334	8	100	1	1	333	75034	74701	Deinococcus actinosclerus strain BM2 chromosome, complete genome	blastn	81118	566	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus actinosclerus
15013644	15013644	PRJEB14803_P_NODE_19872_length_260_cov_1.804444_g19406_i0	PRJEB14803	19872	260	1.804444	4.6915544	Deinococcus	1298	Bacteria	Bacteria	219	2.21e-52	NTclustered	gi\|485099143\|ref\|NR_102538.1\|	432329	g19406	i0	82.51	457.657692307692	263	32	97	10	8	260	284	26	Deinococcus peraridilitoris strain KR-200 23S ribosomal RNA gene, complete sequence	blastn	118991	219	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus peraridilitoris
16288502	16288502	PRJEB14803_P_NODE_40013_length_165_cov_1.915385_g39547_i0	PRJEB14803	40013	165	1.915385	3.16038525	Deinococcus	1298	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g39547	i0	100	206.684848484848	165	0	100	0	1	165	73081	72917	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	34103	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
18837619	18837619	PRJEB14803_P_NODE_41175_length_162_cov_3.070866_g40709_i0	PRJEB14803	41175	162	3.070866	4.97480292	Petrotoga	28236	Bacteria	Bacteria	84.2	4.78e-12	NTclustered	gi\|470482695\|ref\|NR_076547.1\|	69499	g40709	i0	88.406	2.65432098765432	69	8	43	0	1	69	48	116	Petrotoga mobilis strain SJ95 23S ribosomal RNA gene, complete sequence	blastn	430	84.2	1	Bacteria	Thermotogati	Thermotogota	Thermotogae	Petrotogales	Petrotogaceae	Petrotoga	Petrotoga mobilis
23938156	23938156	PRJEB14803_P_NODE_16979_length_288_cov_35.027668_g16513_i0	PRJEB14803	16979	288	35.027668	100.87968384	Deinococcus	1298	Bacteria	Bacteria	472	1.73e-128	NTclustered	gi\|2113031129\|gb\|OK500351.1\|	47478	g16513	i0	96.181	106.006944444444	288	11	100	0	1	288	850	563	Deinococcus sp. strain R11 16S ribosomal RNA gene, partial sequence	blastn	30530	472	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp.
25211865	25211865	PRJEB14803_P_NODE_12320_length_356_cov_1.601246_g11855_i0	PRJEB14803	12320	356	1.601246	5.70043576	Deinococcus	1298	Bacteria	Bacteria	555	2.1099999999999994e-153	NTclustered	gi\|470486828\|ref\|NR_076782.1\|	502394	g11855	i0	95.665	172.587078651685	346	13	97	2	12	356	1476	1132	Deinococcus gobiensis strain I-0 23S ribosomal RNA gene, complete sequence	blastn	61441	555	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus gobiensis

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