metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA451191" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA451191" and tax_phylum = "Deinococcota"

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
440763	440763	PRJNA451191_P_NODE_40241_length_224_cov_3.349693_g39970_i0	PRJNA451191	40241	224	3.349693	7.50331232	Trueperaceae bacterium	2026798	Bacteria	Bacteria	326	1.06e-84	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g39970	i0	92.889	421.741071428571	225	15	100	1	1	224	6760	6536	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	94470	326	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
4920834	4920834	PRJNA451191_P_NODE_3184_length_961_cov_3.852222_g2972_i0	PRJNA451191	3184	961	3.852222	37.01985342	Deinococcus	1298	Bacteria	Bacteria	1703	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g2972	i0	98.65	305.351716961498	963	9	100	4	1	961	70680	69720	Deinococcus swuensis strain DY59, complete genome	blastn	293443	1703	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
7470632	7470632	PRJNA451191_P_NODE_25786_length_280_cov_1.625571_g25515_i0	PRJNA451191	25786	280	1.625571	4.5515988	Truepera	332248	Bacteria	Bacteria	390	4.809999999999999e-104	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g25515	i0	91.786	350.589285714286	280	23	100	0	1	280	822	543	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	98165	390	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix
10020863	10020863	PRJNA451191_P_NODE_23128_length_296_cov_2.970213_g22857_i0	PRJNA451191	23128	296	2.970213	8.79183048	Deinococcus	1298	Bacteria	Bacteria	531	2.899999999999999e-146	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g22857	i0	98.99	204.462837837838	297	2	100	1	1	296	69180	68884	Deinococcus swuensis strain DY59, complete genome	blastn	60521	531	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
14468315	14468315	PRJNA451191_P_NODE_10772_length_457_cov_2.050505_g10501_i0	PRJNA451191	10772	457	2.050505	9.37080785	Trueperaceae bacterium	2026798	Bacteria	Bacteria	614	4.509999999999998e-171	NTclustered	gi\|2108366028\|gb\|CP070651.1\|	2026798	g10501	i0	91.17	171.021881838074	453	38	99	2	6	457	7773	8224	MAG: Trueperaceae bacterium isolate bin86 chromosome	blastn	78157	614	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
17670404	17670404	PRJNA451191_P_NODE_9954_length_479_cov_3.818182_g9683_i0	PRJNA451191	9954	479	3.818182	18.28909178	Deinococcus	1298	Bacteria	Bacteria	885	0	NTclustered	gi\|730601855\|gb\|CP010028.1\|	57497	g9683	i0	100	306.611691022965	479	0	100	0	1	479	69672	69194	Deinococcus swuensis strain DY59, complete genome	blastn	146867	885	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiopugnans
18944091	18944091	PRJNA451191_P_NODE_15735_length_367_cov_2.235294_g15464_i0	PRJNA451191	15735	367	2.235294	8.20352898	Truepera	332248	Bacteria	Bacteria	516	1.03e-141	NTclustered	gi\|470486385\|ref\|NR_076754.1\|	332249	g15464	i0	93.162	491.983651226158	351	24	96	0	17	367	1197	847	Truepera radiovictrix strain RQ-24 23S ribosomal RNA gene, complete sequence	blastn	180558	516	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae	Truepera	Truepera radiovictrix

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