metadata: contig_metadata: 9 rows where bioproject = "PRJNA627467" and tax

9 rows where bioproject = "PRJNA627467" and tax_phylum = "Kitrinoviricota"

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
8252258	8252258	PRJNA627467_P_NODE_11867_length_181_cov_2.848485_g11798_i0	PRJNA627467	11867	181	2.848485	5.15575785	Pestivirus bovis	3052619	Viruses	Viruses	300	4.970000000000001e-77	NTclustered	gi\|642594\|gb\|L35849.1\|BVDP125B	11099	g11798	i0	97.175	98.475138121547	177	5	98	0	5	181	1642	1818	Bovine viral diarrhea virus (strain Draper) p125 gene, partial cds	blastn	17824	300	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
8252427	8252427	PRJNA627467_P_NODE_7327_length_239_cov_2.036842_g7258_i0	PRJNA627467	7327	239	2.036842	4.86805238	Pestivirus bovis	3052619	Viruses	Viruses	326	1.15e-84	NTclustered	gi\|2419860354\|dbj\|LC727648.1\|	11099	g7258	i0	91.845	97.1757322175732	233	19	97	0	4	236	2195	1963	Bovine viral diarrhea virus 1 Tokachi-27 RNA, nearly complete genome	blastn	23225	326	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
10079497	10079497	PRJNA627467_P_NODE_9808_length_188_cov_3.100719_g9739_i0	PRJNA627467	9808	188	3.100719	5.82935172	Pestivirus	11095	Viruses	Viruses	315	1.8599999999999999e-81	NTclustered	gi\|1129880133\|gb\|KX170434.1\|	11099	g9739	i0	97.283	97.8510638297872	184	5	98	0	5	188	1423	1606	Bovine viral diarrhea virus 1 isolate V098 NS3 gene, partial cds	blastn	18396	315	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
14628071	14628071	PRJNA627467_P_NODE_15252_length_170_cov_1.669421_g15183_i0	PRJNA627467	15252	170	1.669421	2.8380157	Pestivirus bovis	3052619	Viruses	Viruses	276	7.75e-70	NTclustered	gi\|1129879735\|gb\|KX170235.1\|	11099	g15183	i0	96.407	97.5941176470588	167	6	98	0	2	168	530	364	Bovine viral diarrhea virus 1 isolate V087 Erns gene, partial cds	blastn	16591	276	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
17177110	17177110	PRJNA627467_P_NODE_18314_length_163_cov_1.350877_g18245_i0	PRJNA627467	18314	163	1.350877	2.20192951	Pestivirus bovis	3052619	Viruses	Viruses	263	5.77e-66	NTclustered	gi\|1129880205\|gb\|KX170470.1\|	11099	g18245	i0	96.25	98.7546012269939	160	6	98	0	1	160	520	361	Bovine viral diarrhea virus 1 isolate V083 NS3 gene, partial cds	blastn	16097	263	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
19725688	19725688	PRJNA627467_P_NODE_12596_length_179_cov_1.538462_g12527_i0	PRJNA627467	12596	179	1.538462	2.75384698	Pestivirus bovis	3052619	Viruses	Viruses	233	5.0499999999999995e-57	NTclustered	gi\|2127986396\|gb\|MW250798.1\|	11099	g12527	i0	90.805	93.2960893854749	174	16	97	0	5	178	3058	3231	Bovine viral diarrhea virus 1 strain 62-2, complete genome	blastn	16700	233	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
21552754	21552754	PRJNA627467_P_NODE_19957_length_158_cov_4.495413_g19888_i0	PRJNA627467	19957	158	4.495413	7.10275254	Pestivirus	11095	Viruses	Viruses	237	3.36e-58	NTclustered	gi\|2731951075\|gb\|PP770551.1\|	11099	g19888	i0	95.302	94.297468354430407	149	7	94	0	5	153	10566	10714	Bovine viral diarrhea virus 1 isolate YN2-11/2023, complete genome	blastn	14899	237	1	Viruses	Orthornavirae	Kitrinoviricota	Flasuviricetes	Amarillovirales	Flaviviridae	Pestivirus	Pestivirus bovis
22276306	22276306	PRJNA627467_P_NODE_19618_length_160_cov_2.846847_g19549_i0	PRJNA627467	19618	160	2.846847	4.5549552	Allexivirus deltallii	3433711	Viruses	Viruses	84.2	4.71e-12	NTclustered	gi\|1722561338\|gb\|MN059370.1\|	12430	g19549	i0	79.2	1.5625	125	23	77	3	28	150	1987	1864	Garlic virus D isolate G45-2, complete genome	blastn	250	84.2	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii
24825340	24825340	PRJNA627467_P_NODE_18320_length_163_cov_1.307018_g18251_i0	PRJNA627467	18320	163	1.307018	2.13043934	Allexivirus deltallii	3433711	Viruses	Viruses	263	5.77e-66	NTclustered	gi\|1722561121\|gb\|MN059339.1\|	12430	g18251	i0	95.706	23.6319018404908	163	7	100	0	1	163	413	251	Garlic virus D isolate G102, complete genome	blastn	3852	263	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii

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