metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA999747" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA999747" 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
3826118	3826118	PRJNA999747_S_NODE_223_length_501_cov_25.627660_g196_i0	PRJNA999747	223	501	25.62766	128.3945766	Deinococcus	1298	Bacteria	Bacteria	900	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g196	i0	99.198	216.612774451098	499	4	99	0	1	499	1793159	1793657	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	108523	900	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
11183904	11183904	PRJNA999747_S_NODE_389_length_414_cov_21.412533_g357_i0	PRJNA999747	389	414	21.412533	88.64788662	Deinococcus grandis	57498	Bacteria	Bacteria	529	1.5099999999999996e-145	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g357	i0	91.304	204.432367149758	391	28	93	5	28	414	116880	116492	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	84635	529	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
11477944	11477944	PRJNA999747_S_NODE_2429_length_197_cov_125.710843_g2397_i0	PRJNA999747	2429	197	125.710843	247.65036071	Deinococcus	1298	Bacteria	Bacteria	364	1.929999999999999e-96	NTclustered	gi\|145033\|gb\|M21413.1\|DEIRGDA	1299	g2397	i0	100	118.005076142132	197	0	100	0	1	197	668	472	D.radiodurans 16S ribosomal RNA gene	blastn	23247	364	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus radiodurans
13734080	13734080	PRJNA999747_S_NODE_1611_length_237_cov_14.529126_g1579_i0	PRJNA999747	1611	237	14.529126	34.43402862	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	433	6.5e-117	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g1579	i0	100	200.675105485232	234	0	99	0	4	237	58245	58012	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	47560	433	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
15008494	15008494	PRJNA999747_S_NODE_452_length_391_cov_16.411111_g420_i0	PRJNA999747	452	391	16.411111	64.16744401	Deinococcus grandis	57498	Bacteria	Bacteria	665	0	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g420	i0	97.215	235.30179028133	395	7	100	3	1	391	116401	116795	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	92003	665	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus grandis
16283318	16283318	PRJNA999747_S_NODE_1413_length_256_cov_5.782222_g1381_i0	PRJNA999747	1413	256	5.782222	14.80248832	Trueperaceae bacterium	2026798	Bacteria	Bacteria	357	4.4e-94	NTclustered	gi\|2621701816\|emb\|OY759346.1\|	2026798	g1381	i0	91.797	366.18359375	256	21	100	0	1	256	3600511	3600766	MAG: Trueperaceae bacterium isolate dd143a13-9bf8-4812-ba0e-a3cf349d91ff genome assembly, chromosome: 1	blastn	93743	357	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Trueperales	Trueperaceae		Trueperaceae bacterium
16576799	16576799	PRJNA999747_S_NODE_1513_length_246_cov_25.409302_g1481_i0	PRJNA999747	1513	246	25.409302	62.50688292	Deinococcus	1298	Bacteria	Bacteria	431	2.4399999999999992e-116	NTclustered	gi\|470483488\|ref\|NR_076595.1\|	310783	g1481	i0	98.374	404.211382113821	246	3	100	1	1	246	2263	2507	Deinococcus deserti strain VCD115 23S ribosomal RNA gene, complete sequence	blastn	99436	431	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus deserti
16576816	16576816	PRJNA999747_S_NODE_33_length_889_cov_34.636364_g27_i0	PRJNA999747	33	889	34.636364	307.91727596	Deinococcus	1298	Bacteria	Bacteria	1182	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g27	i0	92.271	252.18335208099	841	53	94	10	4	840	1791876	1792708	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	224191	1188	0.994949494949495	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
17558469	17558469	PRJNA999747_S_NODE_194_length_519_cov_30.178279_g168_i0	PRJNA999747	194	519	30.178279	156.62526801	Deinococcus sp. AB2017081	3093660	Bacteria	Bacteria	835	0	NTclustered	gi\|2636768990\|gb\|CP140098.1\|	3093660	g168	i0	95.954	108.562620423892	519	14	99	5	4	515	477667	478185	Deinococcus sp. AB2017081 chromosome, complete genome	blastn	56344	835	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus sp. AB2017081
20400541	20400541	PRJNA999747_S_NODE_1316_length_264_cov_10.690987_g1284_i0	PRJNA999747	1316	264	10.690987	28.22420568	Deinococcus	1298	Bacteria	Bacteria	468	2.02e-127	NTclustered	gi\|2890653062\|gb\|CP177252.1\|	367282	g1284	i0	98.855	173.075757575758	262	3	99	0	1	262	2672667	2672928	Deinococcus yunweiensis strain KCTC 3955 chromosome, complete genome	blastn	45692	468	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus yunweiensis
21676574	21676574	PRJNA999747_S_NODE_217_length_505_cov_27.464135_g191_i0	PRJNA999747	217	505	27.464135	138.69388175	Deinococcus	1298	Bacteria	Bacteria	737	0	NTclustered	gi\|1435316362\|gb\|CP031158.1\|	980427	g191	i0	94.561	198.790099009901	478	24	95	2	1	478	1793159	1793634	Deinococcus wulumuqiensis strain NEB 479 chromosome, complete genome	blastn	100389	737	1	Bacteria	Thermotogati	Deinococcota	Deinococci	Deinococcales	Deinococcaceae	Deinococcus	Deinococcus wulumuqiensis
23933010	23933010	PRJNA999747_S_NODE_399_length_410_cov_19.071240_g367_i0	PRJNA999747	399	410	19.07124	78.192084	Deinococcus grandis	57498	Bacteria	Bacteria	651	0	NTclustered	gi\|1751874559\|dbj\|AP021851.1\|	57498	g367	i0	95.377	194.919512195122	411	15	99	3	4	410	116902	116492	Deinococcus grandis ATCC 43672 plasmid: pDEGR-2 DNA, complete genome	blastn	79917	651	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);;