metadata: contig_metadata: 10 rows where bioproject = "PRJNA980839", tax_kingdom = "Orthornavirae" and tax

10 rows where bioproject = "PRJNA980839", tax_kingdom = "Orthornavirae" and tax_phylum = "Negarnaviricota"

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
2546390	2546390	PRJNA980839_P_NODE_97842_length_367_cov_2.125850_g94058_i0	PRJNA980839	97842	367	2.12585	7.8018695	Respirovirus	186938	Viruses	Viruses	673	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g94058	i0	99.728	36.7656675749319	367	1	100	0	1	367	401	35	Sendai virus (strain Z) genome RNA 5'end	blastn	13493	673	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
5098716	5098716	PRJNA980839_P_NODE_34364_length_837_cov_3.019634_g30931_i0	PRJNA980839	34364	837	3.019634	25.27433658	Respirovirus	186938	Viruses	Viruses	1546	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g30931	i0	100	47.3775388291517	837	0	100	0	1	837	4473	3637	Sendai virus (strain Z) genome RNA 5'end	blastn	39655	1546	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
5098846	5098846	PRJNA980839_P_NODE_61424_length_513_cov_2.554545_g57647_i0	PRJNA980839	61424	513	2.554545	13.10481585	Respirovirus	186938	Viruses	Viruses	878	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g57647	i0	99.381	43.4736842105263	485	2	100	1	1	485	1883	2366	Sendai virus (strain Z) genome RNA 5'end	blastn	22302	878	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
6374657	6374657	PRJNA980839_P_NODE_69325_length_468_cov_3.298734_g65543_i0	PRJNA980839	69325	468	3.298734	15.43807512	Respirovirus	186938	Viruses	Viruses	857	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g65543	i0	99.786	43.8888888888889	467	1	99	0	2	468	1445	1911	Sendai virus (strain Z) genome RNA 5'end	blastn	20540	857	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
8923263	8923263	PRJNA980839_P_NODE_247347_length_211_cov_4.471014_g243563_i0	PRJNA980839	247347	211	4.471014	9.43383954	root	1	Root_unresolved	Root_unresolved	390	3.459999999999999e-104	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g243563	i0	100	41.2559241706161	211	0	100	0	1	211	4871	4661	Sendai virus (strain Z) genome RNA 5'end	blastn	8705	390	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
12749371	12749371	PRJNA980839_P_NODE_19170_length_1350_cov_2.438528_g16725_i0	PRJNA980839	19170	1350	2.438528	32.920128	Respirovirus	186938	Viruses	Viruses	2466	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g16725	i0	99.703	43.4925925925926	1347	4	99	0	1	1347	4898	6244	Sendai virus (strain Z) genome RNA 5'end	blastn	58715	2483	0.993153443415223	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
17848012	17848012	PRJNA980839_P_NODE_33094_length_864_cov_3.512010_g29715_i0	PRJNA980839	33094	864	3.51201	30.3437664	Respirovirus	186938	Viruses	Viruses	1596	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g29715	i0	100	45.6284722222222	864	0	100	0	1	864	469	1332	Sendai virus (strain Z) genome RNA 5'end	blastn	39423	1596	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
21672741	21672741	PRJNA980839_P_NODE_246237_length_226_cov_3.385621_g242453_i0	PRJNA980839	246237	226	3.385621	7.65150346	root	1	Root_unresolved	Root_unresolved	392	1.04e-104	NTclustered	gi\|334975\|gb\|M14887.1\|PAFVL	12730	g242453	i0	99.087	30.0398230088496	219	0	96	2	1	218	4137	3920	Sendai virus (5' end of the viral genome) L gene, complete cds	blastn	6789	392	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
22948234	22948234	PRJNA980839_P_NODE_62398_length_507_cov_1.730415_g58620_i0	PRJNA980839	62398	507	1.730415	8.77320405	Respirovirus	186938	Viruses	Viruses	915	0	NTclustered	gi\|60898\|emb\|X03614.1\|	12730	g58620	i0	99.211	39.9250493096647	507	4	100	0	1	507	3049	3555	Sendai virus (strain Z) genome RNA 5'end	blastn	20242	915	1	Viruses	Orthornavirae	Negarnaviricota	Monjiviricetes	Mononegavirales	Paramyxoviridae	Respirovirus	Respirovirus laryngotracheitidis
31511779	31511779	PRJNA980839_P_NODE_203336_length_250_cov_0.870056_g199552_i0	PRJNA980839	203336	250	0.870056	2.17514	Facey's Paddock virus	159143	Viruses	Viruses	43.1	0.0309	NR	YP_010085067.1	159143	g199552	i0	37.9	0.792	66	38	79.2	1	37	234	128	190	YP_010085067.1 membrane glycoprotein polyprotein [Facey's Paddock virus]	diamond	198	43.1	1	Viruses	Orthornavirae	Negarnaviricota	Bunyaviricetes	Elliovirales	Peribunyaviridae	Orthobunyavirus	Orthobunyavirus faceyense

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