metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA674048" and tax_phylum = "Duplornaviricota"

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
1919270	1919270	PRJNA674048_P_NODE_24502_length_177_cov_2.960938_g24299_i0	PRJNA674048	24502	177	2.960938	5.24086026	Kadipiro virus	104580	Viruses	Viruses	107	1.86e-25	NR	WZI48451.1	104580	g24299	i0	91.4	0.983050847457627	58	5	98.3	0	2	175	1069	1126	WZI48451.1 MAG: VP1 protein [Kadipiro virus]	diamond	174	107	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Sedoreoviridae	Seadornavirus	Seadornavirus kadipiroense
26669943	26669943	PRJNA674048_P_NODE_6841_length_382_cov_1.846847_g6638_i0	PRJNA674048	6841	382	1.846847	7.05495554	Callinectes sapidus toti-like virus 1	2916962	Viruses	Viruses	115	8.040000000000001e-27	NR	UKZ10722.1	2916962	g6638	i0	46.4	0.981675392670157	125	55	93.5	3	359	3	424	542	UKZ10722.1 RNA-dependent RNA polymerase [Callinectes sapidus toti-like virus 1]	diamond	375	115	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Callinectes sapidus toti-like virus 1
27839681	27839681	PRJNA674048_P_NODE_20744_length_193_cov_2.013889_g20541_i0	PRJNA674048	20744	193	2.013889	3.88680577	Malassezia globosa associated totivirus 1	3048756	Viruses	Viruses	128	1.0099999999999999e-32	NR	CAI9858974.1	3048756	g20541	i0	93.7	0.979274611398964	63	4	97.9	0	3	191	292	354	CAI9858974.1 capsid protein [Malassezia globosa associated totivirus 1]	diamond	189	128	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Malassezia globosa associated totivirus 1
28723968	28723968	PRJNA674048_P_NODE_18367_length_206_cov_3.617834_g18164_i0	PRJNA674048	18367	206	3.617834	7.45273804	Callinectes sapidus toti-like virus 1	2916962	Viruses	Viruses	63.2	1.44e-9	NR	UKZ10722.1	2916962	g18164	i0	51.8	0.815533980582524	56	27	81.6	0	34	201	66	121	UKZ10722.1 RNA-dependent RNA polymerase [Callinectes sapidus toti-like virus 1]	diamond	168	63.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Callinectes sapidus toti-like virus 1
28945230	28945230	PRJNA674048_P_NODE_22428_length_186_cov_1.072993_g22225_i0	PRJNA674048	22428	186	1.072993	1.99576698	Bolbocoleon piliferum toti-like virus	2933139	Viruses	Viruses	43.5	0.00936	NR	CAI5383831.1	2933139	g22225	i0	43.1	1.61290322580645	58	29	90.3	2	11	178	736	791	CAI5383831.1 RNA-dependent RNA polymerase [Bolbocoleon piliferum toti-like virus]	diamond	300	43.5	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Bolbocoleon piliferum toti-like virus
29355531	29355531	PRJNA674048_P_NODE_26969_length_169_cov_0.866667_g26766_i0	PRJNA674048	26969	169	0.866667	1.46466723	Totiviridae sp.	1955172	Viruses	Viruses	47.4	3.25e-4	NR	UHS72542.1	1955172	g26766	i0	45.8	0.85207100591716	48	26	85.2	0	2	145	544	591	UHS72542.1 MAG: hypothetical protein 1 [Totiviridae sp.]	diamond	144	47.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
29544717	29544717	PRJNA674048_P_NODE_13170_length_250_cov_3.427861_g12967_i0	PRJNA674048	13170	250	3.427861	8.5696525	Kadipiro virus	104580	Viruses	Viruses	150	7.34e-40	NR	WZI48451.1	104580	g12967	i0	91.5	0.984	82	7	98.4	0	3	248	1137	1218	WZI48451.1 MAG: VP1 protein [Kadipiro virus]	diamond	246	150	1	Viruses	Orthornavirae	Duplornaviricota	Resentoviricetes	Reovirales	Sedoreoviridae	Seadornavirus	Seadornavirus kadipiroense
29797315	29797315	PRJNA674048_P_NODE_8291_length_336_cov_1.630662_g8088_i0	PRJNA674048	8291	336	1.630662	5.47902432	Parry's Creek toti-like virus 1	2755155	Viruses	Viruses	89.4	5.25e-18	NR	QLJ83490.1	2755155	g8088	i0	38.9	1.00892857142857	113	68	100	1	336	1	502	614	QLJ83490.1 RNA-dependent RNA polymerase [Parry's Creek toti-like virus 1]	diamond	339	89.4	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Parry's Creek toti-like virus 1
30113249	30113249	PRJNA674048_P_NODE_26932_length_169_cov_0.866667_g26729_i0	PRJNA674048	26932	169	0.866667	1.46466723	Totiviridae sp.	1955172	Viruses	Viruses	71.2	1.05e-12	NR	UHS72529.1	1955172	g26729	i0	57.1	2.94674556213018	56	24	99.4	0	169	2	37	92	UHS72529.1 MAG: putative RNA-dependent RNA polymerase, partial [Totiviridae sp.]	diamond	498	71.2	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Totiviridae sp.
32579661	32579661	PRJNA674048_P_NODE_11899_length_267_cov_1.908257_g11696_i0	PRJNA674048	11899	267	1.908257	5.09504619	Geotrichum candidum totivirus 1	2971326	Viruses	Viruses	52	2.83e-5	NR	UUT40374.1	2971326	g11696	i0	31.9	2.95505617977528	91	58	100	2	267	1	463	551	UUT40374.1 coat protein [Geotrichum candidum totivirus 1]	diamond	789	52	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Orthototiviridae	Totivirus	Geotrichum candidum totivirus 1

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