metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA509429" and tax_phylum = "Thermodesulfobacteriota"

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
3662044	3662044	PRJNA509429_P_NODE_42943_length_172_cov_1.277372_g42115_i0	PRJNA509429	42943	172	1.277372	2.19707984	Desulfobacca	60892	Bacteria	Bacteria	182	1.76e-41	NTclustered	gi\|470488362\|ref\|NR_076865.1\|	60893	g42115	i0	86.667	348.377906976744	165	20	95	2	9	172	395	558	Desulfobacca acetoxidans strain ASRB2 23S ribosomal RNA gene, complete sequence	blastn	59921	182	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfobaccia	Desulfobaccales	Desulfobaccaceae	Desulfobacca	Desulfobacca acetoxidans
15138814	15138814	PRJNA509429_P_NODE_33912_length_205_cov_1.241176_g33084_i0	PRJNA509429	33912	205	1.241176	2.5444108	Pseudomonadati	3379134	Bacteria	Bacteria	135	1.7300000000000003e-27	NTclustered	gi\|470490011\|ref\|NR_076962.1\|	2358	g33084	i0	89.623	77.6878048780488	106	11	52	0	100	205	1468	1363	Desulfomonile tiedjei strain DCB-1 23S ribosomal RNA gene, complete sequence	blastn	15926	135	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfomonilia	Desulfomonilales	Desulfomonilaceae	Desulfomonile	Desulfomonile tiedjei
18962395	18962395	PRJNA509429_P_NODE_43895_length_169_cov_1.492537_g43067_i0	PRJNA509429	43895	169	1.492537	2.52238753	Desulfohalobium	45662	Bacteria	Bacteria	110	8.26e-20	NTclustered	gi\|470484951\|ref\|NR_076677.1\|	45663	g43067	i0	85.577	330.171597633136	104	15	62	0	1	104	509	406	Desulfohalobium retbaense strain DSM 5692 23S ribosomal RNA gene, complete sequence	blastn	55799	110	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfovibrionia	Desulfovibrionales	Desulfohalobiaceae	Desulfohalobium	Desulfohalobium retbaense
20887295	20887295	PRJNA509429_P_NODE_30777_length_220_cov_2.086486_g29949_i0	PRJNA509429	30777	220	2.086486	4.5902692	Geomonas nitrogeniifigens	2843197	Bacteria	Bacteria	139	1.45e-28	NTclustered	gi\|2060223057\|gb\|CP077684.1\|	2847991	g29949	i0	78.972	35.7409090909091	214	37	94	5	10	215	757894	757681	Geomonas nitrogeniifigens strain RF4 chromosome, complete genome	blastn	7863	139	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfuromonadia	Geobacterales	Geobacteraceae	Geomonas	Geomonas nitrogeniifigens
22162043	22162043	PRJNA509429_P_NODE_41358_length_176_cov_4.645390_g40530_i0	PRJNA509429	41358	176	4.64539	8.1758864	Desulfarculaceae bacterium	2528248	Bacteria	Bacteria	222	1.0699999999999999e-53	NTclustered	gi\|2621780225\|emb\|OY776512.1\|	2528248	g40530	i0	92.308	352.011363636364	156	12	89	0	21	176	4511760	4511915	MAG: Desulfarculaceae bacterium isolate e2237022-3439-453f-a1e0-3d3180ebaa11 genome assembly, chromosome: 1	blastn	61954	222	1	Bacteria	Pseudomonadati	Thermodesulfobacteriota	Desulfarculia	Desulfarculales	Desulfarculaceae		Desulfarculaceae bacterium

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