metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA1198392" and tax_kingdom = "Orthornavirae"

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
4151378	4151378	PRJNA1198392_P_NODE_12944_length_267_cov_4.365979_g12803_i0	PRJNA1198392	12944	267	4.365979	11.65716393	Locarnavirus sp.	2809529	Viruses	Viruses	60.2	1.46e-4	NTclustered	gi\|2196309112\|gb\|MZ679237.1\|	2809529	g12803	i0	86.207	0.636704119850187	58	5	21	3	147	202	8561	8505	MAG: Locarnavirus sp. isolate 164-k141_58245 putative nonstructural protein and putative structural protein genes, complete cds	blastn	170	60.2	1	Viruses	Orthornavirae	Pisuviricota	Pisoniviricetes	Picornavirales	Marnaviridae	Locarnavirus	Locarnavirus sp.
6146568	6146568	PRJNA1198392_P_NODE_13445_length_265_cov_1.541667_g13304_i0	PRJNA1198392	13445	265	1.541667	4.08541755	Orthorubulavirus	2560195	Viruses	Viruses	473	4.3599999999999987e-129	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g13304	i0	99.237	63.9207547169811	262	2	99	0	1	262	6252	6513	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	16939	473	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
13078138	13078138	PRJNA1198392_P_NODE_15791_length_251_cov_0.865169_g15650_i0	PRJNA1198392	15791	251	0.865169	2.17157419	Malassezia restricta virus MrV40L	2727863	Viruses	Viruses	459	1.1499999999999996e-124	NTclustered	gi\|1832308141\|gb\|MN603497.1\|	2727863	g15650	i0	99.602	1	251	1	100	0	1	251	3989	4239	Malassezia restricta virus MrV40L, complete genome	blastn	251	459	1	Viruses	Orthornavirae	Duplornaviricota	Chrymotiviricetes	Ghabrivirales	Totiviridae		Malassezia restricta virus MrV40L
13797127	13797127	PRJNA1198392_P_NODE_331_length_1299_cov_4.242251_g258_i0	PRJNA1198392	331	1299	4.242251	55.10684049	Orthorubulavirus	2560195	Viruses	Viruses	2368	0	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g258	i0	99.691	83.8306389530408	1295	3	99	1	1	1295	1799	3092	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	108896	2379	0.995376208490963	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
16901681	16901681	PRJNA1198392_P_NODE_15514_length_252_cov_1.603352_g15373_i0	PRJNA1198392	15514	252	1.603352	4.04044704	Allexivirus deltallii	3433711	Viruses	Viruses	460	3.2e-125	NTclustered	gi\|1356588312\|gb\|MF363012.1\|	12430	g15373	i0	99.603	97.0952380952381	252	1	100	0	1	252	7878	8129	Garlic virus D isolate GVD-XM, complete genome	blastn	24468	460	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Allexivirus	Allexivirus deltallii
18895216	18895216	PRJNA1198392_P_NODE_155_length_1791_cov_3.058207_g104_i0	PRJNA1198392	155	1791	3.058207	54.77248737	Orthorubulavirus	2560195	Viruses	Viruses	3269	0	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g104	i0	99.609	83.178112786153	1791	7	100	0	1	1791	6521	8311	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	148972	3269	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
20170004	20170004	PRJNA1198392_P_NODE_156_length_1781_cov_5.977752_g105_i0	PRJNA1198392	156	1781	5.977752	106.46376312	Orthorubulavirus	2560195	Viruses	Viruses	3253	0	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g105	i0	99.831	75.1560920830994	1770	3	99	0	1	1770	8	1777	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	133853	3258	0.998465316144874	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
20170048	20170048	PRJNA1198392_P_NODE_516_length_1052_cov_2.758938_g418_i0	PRJNA1198392	516	1052	2.758938	29.02402776	Orthorubulavirus	2560195	Viruses	Viruses	1938	0	NTclustered	gi\|1540352612\|gb\|MK117734.1\|	2560580	g418	i0	99.905	97.9752851711027	1052	1	100	0	1	1052	1638	587	Mammalian orthorubulavirus 5 isolate XJ-WLMQ fusion protein mRNA, complete cds	blastn	103070	1938	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis
21445717	21445717	PRJNA1198392_P_NODE_337_length_1288_cov_3.219753_g264_i0	PRJNA1198392	337	1288	3.219753	41.47041864	Orthorubulavirus	2560195	Viruses	Viruses	2374	0	NTclustered	gi\|1806608684\|gb\|MN604146.1\|	2560580	g264	i0	99.922	69.0318322981366	1288	1	100	0	1	1288	3170	4457	Mammalian orthorubulavirus 5 isolate XJ033, complete genome	blastn	88913	2374	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Orthorubulavirus	Orthorubulavirus mammalis

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