metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax

8 rows where analysis = "diamond", bioproject = "PRJEB2368" and tax_superkingdom = "Viruses"

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
27823076	27823076	PRJEB2368_P_NODE_284_length_1571_cov_81.546284_g203_i0	PRJEB2368	284	1571	81.546284	1281.09212164	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	553	1.2600000000000002e-192	NR	7XVR_A	RQ01	g203	i0	67.9	1.48949713558243	392	126	74.9	0	304	1479	13	404	7XVR_A Chain A, Neuraminidase [Wuhan spiny eel influenza virus]	diamond	2340	553	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus
28580796	28580796	PRJEB2368_P_NODE_9267_length_287_cov_1.432000_g8949_i0	PRJEB2368	9267	287	1.432	4.10984	uncultured Caudovirales phage	2100421	Viruses	Viruses	47.4	0.00127	NR	CAB4138560.1	2100421	g8949	i0	84	0.261324041811847	25	4	26.1	0	213	287	87	111	CAB4138560.1 KaiC-like domain containing protein [uncultured Caudovirales phage]	diamond	75	47.4	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Peduoviridae	Maltschvirus	Maltschvirus maltsch
29401598	29401598	PRJEB2368_P_NODE_169_length_1842_cov_161.344044_g121_i0	PRJEB2368	169	1842	161.344044	2971.95729048	Zebrafish influenza B-like virus	RQ01	Viruses	Viruses	699	3.7e-246	NR	AVM87624.1	RQ01	g121	i0	62.2	0.913680781758958	561	208	91.2	3	1798	119	11	568	AVM87624.1 hemagglutinin, partial [Wuhan spiny eel influenza virus]	diamond	1683	699	1	Viruses	Orthornavirae	Negarnaviricota	Insthoviricetes	Articulavirales	Orthomyxoviridae		Zebrafish influenza B-like virus
29685444	29685444	PRJEB2368_P_NODE_4010_length_396_cov_2.011142_g3698_i0	PRJEB2368	4010	396	2.011142	7.96412232	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	103	7.729999999999999e-23	NR	YP_009361866.1	RQ15	g3698	i0	58.8	0.734848484848485	97	40	73.5	0	3	293	502	598	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	291	103	1	Viruses							Zebrafish rhabdo-like virus
31107299	31107299	PRJEB2368_P_NODE_55_length_2750_cov_4.192407_g36_i0	PRJEB2368	55	2750	4.192407	115.2911925	Zebrafish rhabdo-like virus	RQ15	Viruses	Viruses	360	7.899999999999999e-107	NR	YP_009361866.1	RQ15	g36	i0	57.1	0.343636363636364	315	130	34	2	1063	128	103	415	YP_009361866.1 polyprotein [Salmovirus WFRC1]	diamond	945	360	1	Viruses							Zebrafish rhabdo-like virus
31417178	31417178	PRJEB2368_P_NODE_10316_length_287_cov_1.252000_g9998_i0	PRJEB2368	10316	287	1.252	3.59324	Bequatrovirus	1917990	Viruses	Viruses	47.4	0.00141	NR	YP_008770431.1	1406791	g9998	i0	79.2	1.25435540069686	24	5	25.1	0	214	285	43	66	YP_008770431.1 hypothetical protein Spock_207 [Bacillus phage Spock]	diamond	360	47.8	0.99163179916318	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes		Herelleviridae	Bequatrovirus	Bequatrovirus spock
31739748	31739748	PRJEB2368_P_NODE_8897_length_287_cov_1.500000_g8579_i0	PRJEB2368	8897	287	1.5	4.305	Caudoviricetes sp.	2832643	Viruses	Viruses	45.8	0.00495	NR	DAR60264.1	2832643	g8579	i0	72	0.261324041811847	25	7	26.1	0	2	76	212	236	DAR60264.1 MAG TPA: hypothetical protein, partial [Caudoviricetes sp.]	diamond	75	45.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Caudoviricetes sp.
32625410	32625410	PRJEB2368_P_NODE_7160_length_287_cov_2.528000_g6842_i0	PRJEB2368	7160	287	2.528	7.25536	Psittaciform aveparvovirus	3042447	Viruses	Viruses	43.5	0.0268	NR	UQB76439.1	3042447	g6842	i0	89.5	0.198606271777003	19	2	19.9	0	269	213	74	92	UQB76439.1 nonstructural protein [Flumine parvovirus 18]	diamond	57	43.5	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Psittaciform aveparvovirus

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