metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA771359" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA771359" 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
747053	747053	PRJNA771359_S_NODE_401_length_476_cov_27.569476_g322_i0	PRJNA771359	401	476	27.569476	131.23070576	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	676	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g322	i0	92.308	175.086134453782	481	29	100	8	1	476	57125	56648	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	83341	676	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
747063	747063	PRJNA771359_S_NODE_4381_length_162_cov_0.928000_g4298_i0	PRJNA771359	4381	162	0.928	1.50336	Deinococcus grandis	57498	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g4298	i0	99.383	2	162	1	100	0	1	162	2258975	2258814	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	324	294	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
2023045	2023045	PRJNA771359_S_NODE_302_length_541_cov_22.065476_g225_i0	PRJNA771359	302	541	22.065476	119.37422516	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	953	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g225	i0	98.521	200.96303142329	541	6	99	2	2	541	57187	56648	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	108721	953	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
2023060	2023060	PRJNA771359_S_NODE_3922_length_170_cov_2.105263_g3839_i0	PRJNA771359	3922	170	2.105263	3.5789471	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g3839	i0	100	137.917647058824	170	0	100	0	1	170	56194	56025	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	23446	315	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
3298230	3298230	PRJNA771359_S_NODE_2203_length_225_cov_6.244681_g2120_i0	PRJNA771359	2203	225	6.244681	14.05053225	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	399	6.199999999999999e-107	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g2120	i0	98.667	212.768888888889	225	3	100	0	1	225	58007	58231	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	47873	399	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
3298243	3298243	PRJNA771359_S_NODE_283_length_560_cov_32.147228_g207_i0	PRJNA771359	283	560	32.147228	180.0244768	Deinococcus yunweiensis	367282	Bacteria	Bacteria	902	0	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g207	i0	95.737	219.067857142857	563	19	99	3	2	560	2671296	2671857	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	122678	902	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
4575308	4575308	PRJNA771359_S_NODE_224_length_612_cov_25.146087_g151_i0	PRJNA771359	224	612	25.146087	153.89405244	Deinococcus grandis	57498	Bacteria	Bacteria	1002	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g151	i0	96.242	207.929738562092	612	22	100	1	1	612	3061095	3060485	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	127253	1002	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
14775952	14775952	PRJNA771359_S_NODE_4172_length_165_cov_4.828125_g4089_i0	PRJNA771359	4172	165	4.828125	7.96640625	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2636772739\|gb\|CP140100.1\|	3093660	g4089	i0	100	2.99393939393939	165	0	100	0	1	165	150774	150610	Deinococcus sp. AB2017081 plasmid unnamed2, complete sequence	blastn	494	305	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
15235266	15235266	PRJNA771359_S_NODE_632_length_391_cov_20.830508_g549_i0	PRJNA771359	632	391	20.830508	81.44728628	Deinococcus	1298	Bacteria	Bacteria	521	2.37e-143	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g549	i0	92.562	457.695652173913	363	27	93	0	29	391	2147764	2148126	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	178959	521	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
21149600	21149600	PRJNA771359_S_NODE_117_length_813_cov_43.145619_g49_i0	PRJNA771359	117	813	43.145619	350.77388247	Deinococcus grandis	57498	Bacteria	Bacteria	1314	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g49	i0	95.844	208.750307503075	818	24	100	9	1	813	424715	423903	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	169714	1314	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
22424355	22424355	PRJNA771359_S_NODE_3618_length_177_cov_1.642857_g3535_i0	PRJNA771359	3618	177	1.642857	2.90785689	Deinococcus grandis	57498	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|1751874214\|dbj\|AP021850.1\|	57498	g3535	i0	99.435	43.864406779661	177	1	100	0	1	177	181392	181216	Deinococcus grandis ATCC 43672 plasmid: pDEGR-1 DNA, complete genome	blastn	7764	322	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
23699978	23699978	PRJNA771359_S_NODE_119_length_811_cov_50.180879_g51_i0	PRJNA771359	119	811	50.180879	406.96692869	Deinococcus grandis	57498	Bacteria	Bacteria	1448	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g51	i0	98.893	342.880394574599	813	5	100	4	1	811	73294	74104	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	278076	1448	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
24973653	24973653	PRJNA771359_S_NODE_280_length_562_cov_46.196190_g204_i0	PRJNA771359	280	562	46.19619	259.6225878	Deinococcus grandis	57498	Bacteria	Bacteria	924	0	NTclustered	gi\|1751871007\|dbj\|AP021849.1\|	57498	g204	i0	96.454	93.8220640569395	564	13	100	4	1	562	20813	20255	Deinococcus grandis ATCC 43672 DNA, complete genome	blastn	52728	924	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);;