metadata: contig_metadata: 11 rows where analysis = "diamond" and tax

11 rows where analysis = "diamond" and tax_phylum = "Commensaviricota"

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
12932203	12932203	PRJNA1061474_P_NODE_36471_length_299_cov_1.230088_g36225_i0	PRJNA1061474	36471	299	1.230088	3.67796312	TTV-like mini virus	93678	Viruses	Viruses	134	3.91e-34	NR	UGV35930.1	93678	g36225	i0	64.6	0.993311036789298	99	32	99.3	2	3	299	318	413	UGV35930.1 MAG: ORF1 [TTV-like mini virus]	diamond	297	134	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus
27735503	27735503	PRJNA1148190_P_NODE_793504_length_239_cov_2.108434_g782331_i0	PRJNA1148190	793504	239	2.108434	5.03915726	Anelloviridae sp.	2055263	Viruses	Viruses	43.1	0.0258	NR	QUB06994.1	2055263	g782331	i0	32.9	0.878661087866109	70	42	84.1	2	8	208	160	227	QUB06994.1 ORF1, partial [Anelloviridae sp.]	diamond	210	43.1	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae		Anelloviridae sp.
28077679	28077679	PRJNA1061474_P_NODE_49265_length_248_cov_0.880000_g49019_i0	PRJNA1061474	49265	248	0.88	2.1824	TTV-like mini virus	93678	Viruses	Viruses	84	1.21e-16	NR	UGV34516.1	93678	g49019	i0	70.5	0.737903225806452	61	17	72.6	1	28	207	164	224	UGV34516.1 MAG: ORF1 [TTV-like mini virus]	diamond	183	84	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus
28287525	28287525	PRJNA906294_P_NODE_74246_length_522_cov_1.732739_g70139_i0	PRJNA906294	74246	522	1.732739	9.04489758	Alphatorquevirus sp.	2809145	Viruses	Viruses	45.8	0.0379	NR	WMI31623.1	2809145	g70139	i0	34.3	0.402298850574713	70	46	40.2	0	184	393	127	196	WMI31623.1 hypothetical protein, partial [Alphatorquevirus sp.]	diamond	210	45.8	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Alphatorquevirus	Alphatorquevirus sp.
28646220	28646220	PRJNA1061474_P_NODE_16787_length_489_cov_1.528846_g16541_i0	PRJNA1061474	16787	489	1.528846	7.47605694	Torque teno midi virus	432261	Viruses	Viruses	167	2.61e-45	NR	UHK06829.1	432261	g16541	i0	80.1	0.895705521472393	146	29	89.6	0	452	15	516	661	UHK06829.1 MAG: ORF1 [Torque teno midi virus]	diamond	438	167	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae		Torque teno midi virus
29151671	29151671	PRJNA1061474_P_NODE_38209_length_289_cov_1.425926_g37963_i0	PRJNA1061474	38209	289	1.425926	4.12092614	Betatorquevirus sp.	2809199	Viruses	Viruses	118	1.79e-28	NR	DBA61078.1	2809199	g37963	i0	63.4	0.85121107266436	82	28	83	1	287	48	271	352	DBA61078.1 MAG TPA_asm: hypothetical protein [Betatorquevirus sp.]	diamond	246	118	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	Betatorquevirus sp.
29183066	29183066	PRJNA1061474_P_NODE_55929_length_242_cov_1.366864_g55683_i0	PRJNA1061474	55929	242	1.366864	3.30781088	Alphatorquevirus sp.	2809145	Viruses	Viruses	151	1.33e-40	NR	DBA61020.1	2809145	g55683	i0	89.3	0.929752066115702	75	8	93	0	2	226	362	436	DBA61020.1 MAG TPA_asm: hypothetical protein [Alphatorquevirus sp.]	diamond	225	151	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Alphatorquevirus	Alphatorquevirus sp.
29995806	29995806	PRJNA1061474_P_NODE_53451_length_244_cov_1.450292_g53205_i0	PRJNA1061474	53451	244	1.450292	3.53871248	Gammatorquevirus	687333	Viruses	Viruses	90.9	4.31e-19	NR	UHK05482.1	432261	g53205	i0	68.8	1.56147540983607	64	20	78.7	0	192	1	285	348	UHK05482.1 MAG: ORF1 [Torque teno midi virus]	diamond	381	91.3	0.995618838992333	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae		Torque teno midi virus
30325373	30325373	PRJNA1166865_P_NODE_27132_length_413_cov_1.170588_g26891_i0	PRJNA1166865	27132	413	1.170588	4.83452844	TTV-like mini virus	93678	Viruses	Viruses	44.7	0.0465	NR	UGV38236.1	93678	g26891	i0	31.8	0.617433414043584	85	49	56.7	2	180	413	385	467	UGV38236.1 MAG: ORF1 [TTV-like mini virus]	diamond	255	44.7	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus
30540965	30540965	PRJNA1061474_P_NODE_41653_length_271_cov_1.065657_g41407_i0	PRJNA1061474	41653	271	1.065657	2.88793047	Torque teno midi virus	432261	Viruses	Viruses	155	7.21e-42	NR	UHK06275.1	432261	g41407	i0	77.5	1.97047970479705	89	20	98.5	0	269	3	253	341	UHK06275.1 MAG: ORF1 [Torque teno midi virus]	diamond	534	155	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae		Torque teno midi virus
32794007	32794007	PRJNA453567_P_NODE_14200_length_241_cov_1.897059_g13963_i0	PRJNA453567	14200	241	1.897059	4.57191219	TTV-like mini virus	93678	Viruses	Viruses	42.7	0.0368	NR	UGV35367.1	93678	g13963	i0	41.3	0.784232365145228	63	32	78.4	2	40	228	7	64	UGV35367.1 MAG: ORF1 [TTV-like mini virus]	diamond	189	42.7	1	Viruses	Shotokuvirae	Commensaviricota	Cardeaviricetes	Sanitavirales	Anelloviridae	Betatorquevirus	TTV-like mini virus

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