metadata: contig_metadata: 8 rows where bioproject = "PRJNA751877" and tax

8 rows where bioproject = "PRJNA751877" 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
3277616	3277616	PRJNA751877_P_NODE_18143_length_277_cov_1.323529_g18021_i0	PRJNA751877	18143	277	1.323529	3.66617533	Deinococcus oregonensis	1805970	Bacteria	Bacteria	143	1.02e-40	NR	WP_380009940.1	1805970	g18021	i0	76.1	1.9927797833935	92	22	99.6	0	2	277	113	204	WP_380009940.1 hypothetical protein [Deinococcus oregonensis]	diamond	552	143	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus oregonensis
8379816	8379816	PRJNA751877_P_NODE_30067_length_241_cov_0.916667_g29945_i0	PRJNA751877	30067	241	0.916667	2.20916747	Deinococcus yunweiensis	367282	Bacteria	Bacteria	435	1.84e-117	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g29945	i0	99.17	39.5352697095436	241	2	100	0	1	241	1631946	1631706	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	9528	435	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
9655007	9655007	PRJNA751877_P_NODE_30368_length_238_cov_3.266667_g30246_i0	PRJNA751877	30368	238	3.266667	7.77466746	Deinococcus psychrotolerans	2489213	Bacteria	Bacteria	89.8	1.63e-13	NTclustered	gi\|1527207013\|gb\|CP034185.1\|	2489213	g30246	i0	89.855	2.33613445378151	69	7	29	0	128	196	117700	117768	Deinococcus psychrotolerans strain S14-83 plasmid unnamed1, complete sequence	blastn	556	89.8	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus psychrotolerans
10128635	10128635	PRJNA751877_P_NODE_10968_length_336_cov_1.756654_g10846_i0	PRJNA751877	10968	336	1.756654	5.90235744	Deinococcus	1298	Bacteria	Bacteria	106	2.4e-18	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g10846	i0	94.203	3.30654761904762	69	4	21	0	166	234	2062224	2062292	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	1111	106	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
12205949	12205949	PRJNA751877_P_NODE_28770_length_243_cov_0.905882_g28648_i0	PRJNA751877	28770	243	0.905882	2.20129326	Deinococcus ficus	317577	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|1220365372\|gb\|CP021083.1\|	317577	g28648	i0	99.588	1.98353909465021	243	1	100	0	1	243	356376	356134	Deinococcus ficus strain CC-FR2-10 plasmid pDFI2, complete sequence	blastn	482	444	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus ficus
27305794	27305794	PRJNA751877_P_NODE_20603_length_261_cov_1.638298_g20481_i0	PRJNA751877	20603	261	1.638298	4.27595778	Truepera radiovictrix	332249	Bacteria	Bacteria	103	8.44e-26	NR	WP_013177066.1	332249	g20481	i0	64	0.988505747126437	86	30	98.9	1	260	3	62	146	WP_013177066.1 helix-hairpin-helix domain-containing protein [Truepera radiovictrix]	diamond	258	103	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
28316144	28316144	PRJNA751877_P_NODE_23626_length_250_cov_0.870056_g23504_i0	PRJNA751877	23626	250	0.870056	2.17514	Deinococcota bacterium	1913990	Bacteria	Bacteria	61.6	2.79e-10	NR	MEM7737149.1	1913990	g23504	i0	53.6	1.356	56	26	67.2	0	249	82	28	83	MEM7737149.1 type II toxin-antitoxin system prevent-host-death family antitoxin [Deinococcota bacterium]	diamond	339	61.6	1	Bacteria	Thermotogati	Deinococcota					Deinococcota bacterium
32455827	32455827	PRJNA751877_P_NODE_25119_length_248_cov_0.880000_g24997_i0	PRJNA751877	25119	248	0.88	2.1824	Deinococcus antarcticus	1298767	Bacteria	Bacteria	99	4.159999999999999e-23	NR	WP_380075582.1	1298767	g24997	i0	97.9	0.568548387096774	47	1	56.9	0	107	247	1	47	WP_380075582.1 hypothetical protein [Deinococcus antarcticus]	diamond	141	99	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus antarcticus

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